Checkpoint - Spreadsheet Functions

What is the primary purpose of filtering data in a spreadsheet?

• To delete unnecessary data

• To hide rows that do not meet certain criteria

• To change the format of the data

• To create a chart

Answer explanation

To hide rows that do not meet certain criteria

Which function would you use to count the number of cells that meet a specific condition?

• COUNT

• COUNTIF

• COUNTA

• SUM

Answer explanation

The function COUNTIF is used to count the number of cells that meet a specific condition, making it the correct choice for this scenario.

How would you write a formula to find the average of the numbers in cells A1 to A10?

• =SUM(A1:A10)

• =AVERAGE(A1:A10)

• =COUNT(A1:A10)

• =IF(A1:A10)

Answer explanation

Choose the formula that calculates the average of numbers in cells A1 to A10, which is =AVERAGE(A1:A10)

What does the SUM function do in a spreadsheet?

• Counts the number of cells

• Finds the maximum value

• Adds up the values in a range of cells

• Finds the average value

Answer explanation

The SUM function in a spreadsheet adds up the values in a range of cells, making it the correct choice among the options provided.

Which of the following is a correct use of the IF function?

• =IF(A1>10, "High", "Low")

• =IF(A1:A10)

• =IF(A1, A2, A3)

• =IF(A1+A2)

Answer explanation

The correct use of the IF function is =IF(A1>10, 'High', 'Low'). This formula checks if the value in cell A1 is greater than 10 and returns 'High' if true, 'Low' if false.

How can you sort data in ascending order in a spreadsheet?

• Select the data and click on "Sort Z to A"

• Select the data and click on "Sort A to Z"

• Select the data and click on "Filter"

• Select the data and click on "Format"

Answer explanation

Select the data and click on 'Sort A to Z' to sort data in ascending order in a spreadsheet.

What is the result of the formula =COUNTIF(B1:B10, ">5") if cells B1 to B10 contain the numbers 1, 2, 3, 6, 7, 8, 9, 10, 11, 12?

• 5

• 6

• 7

• 8

Answer explanation

The formula =COUNTIF(B1:B10, ">5") counts the numbers in the range B1:B10 that are greater than 5. In this case, there are 7 numbers (6, 7, 8, 9, 10, 11, 12) that are greater than 5, so the result is 7.

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

• MIN

• MAX

• AVERAGE

• SUM

Answer explanation

To find the highest value in a range of cells, you would use the MAX function as it returns the maximum value from the specified range.

How would you filter data to show only rows where the value in column A is greater than 50?

• Use the Sort function

• Use the Filter function and set a condition

• Use the SUM function

• Use the AVERAGE function

Answer explanation

Use the Filter function and set a condition

What does the COUNTA function do?

• Counts the number of empty cells

• Counts the number of non-empty cells

• Counts the number of cells that meet a specific condition

• Adds up the values in a range of cells

Answer explanation

Counts the number of non-empty cells