Excel Functions Quiz

What does the Count function do?

• Counts the number of blank records

• Counts the number of records that contain a number

• Counts the number of unique records

• Counts the number of records that contain text

What is the purpose of the CountIf function?

• To sum records in a table

• To find the maximum value in a table

• To count records based on a logical formula

• To count all records in a table

What does the IF function allow you to do?

• Count records in a table

• Look up values in a table

• Perform arithmetic operations

• Make logical comparisons

In the formula =IF(C2='Yes',1,2), what does the '1' represent?

• The value returned if the comparison is False

• The value returned if the comparison is True

• The value in cell C2

• The number of records counted

What does the SUMIF function do?

• Sums all values in a range

• Sums values that meet specified criteria

• Finds the average of a range

• Counts the number of records

What is the first argument in the HLOOKUP function?

• Range_lookup

• Table_array

• Lookup_value

• Row_index_num

What does the formula =SUMIF(B2:B25, '>5') do?

• Counts the number of values greater than 5 in B2:B25

• Sums values greater than 5 in B2:B25

• Sums values less than 5 in B2:B25

• Sums all values in B2:B25

Which function would you use to count non-blank records?

• Count

• CountIf

• SUMIF

• CountA

What does the IF function return if the comparison is False?

• The first result

• The second result

• An error

• Nothing

In the formula =COUNTIF(A1:A10, 'Yes'), what does 'Yes' represent?

• The range of cells

• The criteria for counting

• The total count of records

• The value to be summed