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]
Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?
A
SUMIFS
B
AVERAGEIFS
C
TOTALIFS
D
COUNTIFS
Explanation: 

Detailed explanation-1: -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-2: -The SUMIF Function[1] is categorized under Excel Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, and text.

There is 1 question to complete.