Yr 7 Spreadsheets
Authored by Rhiannon McAndrew
Computers
7th - 9th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these is used to visualise information as a picture?
Pie Chart
Pizza chart
Apple chart
Circle chart
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these would you use to add up a range of numbers?
TOTAL
ADD
PLUS
SUM
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You use the MAX function to find:
The largest value
The total
The smallest value
The first value
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the smallest value?
MAX
MIN
LEAST
COUNTA
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNTA function tell you?
The average
The largest value
The number of non-blank cells
The number of A's
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?
(a)
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What would be the cell range for the first ten cells of column B:
(a)
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?
