FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.