BigBasket Data Entry Operator Interview Questions and Answers

Conditional formatting is a feature in spreadsheet applications that allows you to apply formatting to cells based on certain criteria.

• It is used to highlight specific data based on certain conditions

• It can be used to identify trends or outliers in data

• Examples include highlighting cells with values above or below a certain threshold, or cells that contain specific text

• It can also be used to create visual aids such as

The sumif function is used to calculate the sum of a range of cells that meet specific criteria.

• The sumif function takes three arguments: range, criteria, and sum_range.

• The range is the range of cells to be evaluated for the criteria.

• The criteria is the condition that must be met for a cell to be included in the sum.

• The sum_range is the range of cells to be summed if the corresponding cells in the range meet the criter...read more

Count if is a function used to count the number of cells in a range that meet a certain criteria.

• The COUNTIF function takes two arguments: the range of cells to evaluate and the criteria to use when evaluating those cells.

• The criteria can be a number, text, or logical expression.

• For example, =COUNTIF(A1:A10,">50") would count the number of cells in the range A1:A10 that contain a value greater than 50.

• The function is c...read more