Spreadsheet Functions and Chart Types Quiz

Which formula correctly adds up the numbers in cells A1 to A5?

• =ADD(A1:A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

• =A1+A2+A3+A4+A5

What is the purpose of the AVERAGE function?

• To find the middle number in a list.

• To find the most common number.

• To calculate the sum of a range and divide by the count of numbers in that range.

• To count how many numbers are in a list.

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

• MIN

• HIGH

• TOP

• MAX

You have a list of students' test scores. Which function would you use to count how many students passed if the pass mark was 50?

• COUNT

• IF

• COUNTIF

• SUM

What does the formula =IF(A1>10, "Yes", "No") do?

• It checks if A1 contains the word "Yes" or "No".

• It puts the word "Yes" in cell A1.

• It displays "Yes" if the value in A1 is greater than 10, otherwise it displays "No".

• It causes an error because text and numbers are mixed.

Which function would you use to find the lowest value in a list of numbers?

• MIN

• MAX

• LOWEST

• BOTTOM

What is the main purpose of the VLOOKUP function?

• To look up a value in the top row of a table.

• To find a value in the first column of a table and return a corresponding value from another column.

• To verify that a lookup table is correct.

• To create a vertical list of data.

If you want to count the number of cells in a range that are not empty (including text), which function should you use?

• COUNT

• COUNTA

• COUNTALL

• IFEMPTY

What result would the formula =MAX(A1:A4) give for the following data: A1=5, A2=15, A3=8, A4=12?

• 5

• 8

• 15

• 40

A teacher wants to give students a "Pass" or "Fail" grade based on their score in B2. If a score of 50 or more is a pass, which formula is correct?

• =IF(B2>=50, "Fail", "Pass")

• =IF(B2<50, "Pass", "Fail")

• =IF(B2>=50, "Pass", "Fail")

• =IF(B2="Pass", 50, 0)