# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1, 000. What function should she use?
 A SUMIF B AVERAGEIF C TOTALIF D COUNTIF
Explanation:

Detailed explanation-1: -The COUNTIF Function[1] will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions.

Detailed explanation-2: -VLOOKUP Formula The VLOOKUP function uses the following arguments: Lookup value (required argument) β Lookup value specifies the value that we want to look up in the first column of a table.

Detailed explanation-3: -When using TRUE or FALSE as criteria in a function, they are considered to be boolean values and therefore should not be put in quotes. In the COUNTIFS( ) function, every optional argument is treated as an βORβ scenario, meaning only one criteria must be evaluated to true in order for the item to be counted.

There is 1 question to complete.