LO5 - Spreadsheets (1)
Authored by Samantha Cook
Computers
10th - 11th Grade
Used 22+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A sales manager has requested the highest sale for the first quarter. Which function will be used?
SUM
MAX
MIN
AVERAGE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A sales manager has requested the lowest sale for the first quarter. Which function will be used?
SUM
MIN
MAX
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bob needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
Label
Value
Formula
Function
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A sales manager has requested the total sale for the first quarter. Which function will be used?
SUM
MIN
MAX
AVERAGE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In spreadsheets, columns are marked with _________
Letters
Numbers
= sign
Both a letter and a number
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In spreadsheets, rows are marked with _____
Letters
Numbers
= sign
Both a letter and a number
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
All spreadsheet formulas begin with which symbol?
=
^
$
#
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
