WorksheetsCheckpoint - Spreadsheet Functions
Total questions: 20
Worksheet time: 20mins
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
Which function would you use to count the number of cells that meet a specific condition?
COUNT
COUNTIF
COUNTA
SUM
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)
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
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)
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"
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
Which function would you use to find the highest value in a range of cells?
MIN
MAX
AVERAGE
SUM
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
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
How would you write a formula to sum the values in cells B1 to B5?
=SUM(B1:B5)
=AVERAGE(B1:B5)
=COUNT(B1:B5)
=IF(B1:B5)
Which of the following is a correct use of the AVERAGE function?
=AVERAGE(A1, A2, A3)
=AVERAGE(A1:A3)
=AVERAGE(A1+A2+A3)
=AVERAGE(A1:A3, A4:A6)
What is the purpose of the IF function in a spreadsheet?
To add up values
To count cells
To perform a logical test and return one value if true and another if false
To find the average
How would you write a formula to count the number of cells in the range C1 to C10 that contain the text "Pass"?
=COUNT(C1:C10, "Pass")
=COUNTA(C1:C10, "Pass")
=COUNTIF(C1:C10, "Pass")
=SUM(C1:C10, "Pass")
Which function would you use to find the lowest value in a range of cells?
MIN
MAX
AVERAGE
SUM
How would you write a formula to count the number of empty cells in the range D1 to D10?
=COUNTBLANK(D1:D10)
=COUNTA(D1:D10)
=COUNT(D1:D10)
=IF(D1:D10)
What is the purpose of the VLOOKUP function in a spreadsheet?
To look up a value in a table and return a corresponding value
To count the number of cells
To find the average value
To add up values
Which function would you use to count the number of non-empty cells in a range?
COUNT
COUNTA
COUNTIF
SUM
How would you write a formula to find the sum of the values in cells C1 to C15?
=SUM(C1:C15)
=AVERAGE(C1:C15)
=COUNT(C1:C15)
=IF(C1:C15)
What is the purpose of the HLOOKUP function in a spreadsheet?
To look up a value in a table and return a corresponding value from a row
To count the number of cells
To find the average value
To add up values
