USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The worksheet data to be included in the formula’s results
|
|
|
The range containing a condition that must be met in order for data to be included in the result
|
|
|
The type of formula being used for the calculation
|
|
|
The type of data contained in the cells to be included in the formula
|
Detailed explanation-1: -What does criteria range in a formula refer to? The range containing a condition that must be met in order for data to be included in the result.
Detailed explanation-2: -What is a Criteria Range? The criteria range for an Excel advanced filter, is a group of cells on a worksheet, where you set the rules for filtering the data. The criteria range must have a specific setup, with heading cells and criteria cells.
Detailed explanation-3: -The formula you use in the criteria range must evaluate to TRUE or FALSE. The criteria range should contain at least 2 cells: formula cell and header cell. The header cell of the formula-based criteria should be either blank or different from any of the table (list range) headings.
Detailed explanation-4: -In Microsoft Excel, criteria can be set by typing the exact value that is desired in the criteria cells, or by using cell references or defined names.