KS3 Spreadsheets 2 - Formulas and functions
Authored by James Greenwood
Computers
7th - 9th Grade
Used 429+ 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
30 sec • 1 pt
What formula should be used in cell D4?
=B4+C4
=B4*C4
=B4/C4
=B4-C4
2.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
Type the formula that should appear in cell D4.
(a)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is happening in this spreadsheet?
A formula is being replicated
A formula is being duplicated
A formula is being copied
A formula is being moved
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula should be used in cell D8?
=SUM(D4+D7)
=SUM(D4:D7)
=SUM(D4+D5+D6+D7)
=SUM(D4:D8)
5.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What is missing from the formula for cell D8?
= (a) (D4:D7)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell D8 should contain a function. What kind?
=SUM
=AVERAGE
=MIN
=MAX
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which month is the wettest?
January
February
March
April
May
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?
