Year 7 Spreadsheet FA
Authored by Priya Melvin Thomas
Education
7th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
How many rows are shown in the spreadsheet?
(a)
2.
FILL IN THE BLANK QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
How many columns are shown in the spreadsheet?
(a)
3.
FILL IN THE BLANK QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
Give the cell reference that contains 124.
(a)
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
Give the item that has the maximum profit per item.
Mars Bar
Twix
M&Ms
Bounty
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
Give the item that has the minimum number in stock.
Mars Bar
Twix
M&Ms
Bounty
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
Give the formula that would have been used in D4 to calculate the Profit per item.
=C4-B4
=B4-C4
C4-B4
=SUBTRACT(C4-B4)
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
The table shows part of a spreadsheet file.
Select all the columns that would be formatted as currency.
B
C
D
E
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?
