CAT Grade 12 Module 3 AMA Quiz

What does the #DIV/0 error indicate in Excel functions?

• Trying to divide by 0

• Invalid cell reference

• Incorrect cell values

• Incorrect function name

What is the purpose of the COUNTIF function in Excel?

• To calculate the average

• To insert the current date

• To find the smallest numerical value

• To determine the number of cells with specific criteria

Which functions inserts the current date and time set by the computer?

• TODAY

• NOW

• DATE_TIME

• CURRENT

Which function would you use to get the third greatest numerical value from a cell range?

• MAX

• MIN

• LARGE

• GREATEST

What is wrong in this function?

 =SUMIF(B1:B30,>10,D1:D30)

• The quotation marks for the condition is missing.

• There are too many cell ranges.

• The function should end with a semi-colon (;)

• A condition is missing.

What does the #NUM! error indicate?

•  An incorrect function name is used.

•  The cell reference is not valid.

•  The function has numeric values that are not valid.

•  The column is not wide enough to display the cell's numerical value.