Advanced Spreadsheet Skills Quiz

What is the purpose of the =SUM function in Excel?

• Counts the number of cells in a range

• Calculates the sum of the values of a range of cells

• Calculates the maximum value in a range of cells

• Calculates the average of a range of cells

Which function would you use to find the minimum value in a range of cells?

• =COUNT

• =MIN

• =MAX

• =AVERAGE

What does the COUNTIF function do?

• Counts all cells in a range

• Calculates the average of a range

• Calculates the sum of a range

• Counts cells with a specified content within a range

Which operator is used for multiplication in Excel formulas?

• +

• -

• *

• /

What does the IF function do in Excel?

• Finds the maximum value in a range

• Performs a logical test and returns a value based on the result

• Calculates the sum of a range of cells

• Counts the number of cells in a range

Which function would you use to combine text from multiple fields into one cell?

• =IF

• =SUM

• =AVERAGE

• =CONCATENATE

What does the VLOOKUP function do?

• Counts the number of cells in a range

• Finds the minimum value in a range

• Calculates the average of a range of cells

• Searches for a value in the first column of a table and returns a value in the same row

Which function would you use to insert the current date in a cell?

• =TODAY()

• =NOW()

• =DATE()

• =CURRENT()

What is the purpose of the AVERAGEIF function?

• Finds the maximum value in a range

• Counts the number of cells in a range

• Calculates the sum of a range if a certain condition is met

• Calculates the average of a range if a certain condition is met

Which of the following is a logical function in Excel?

• AVERAGE

• IF

• COUNT

• SUM