Checkpoint - Spreadsheet Functions
Authored by Jonathan Saurine
Computers
9th Grade
Used 28+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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)
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
