
Understanding Spreadsheet Formulas and References
Authored by J Blakley
Information Technology (IT)
8th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct way to start a formula in a spreadsheet cell?
By typing a colon (:)
By typing an equals sign (=)
By typing a plus sign (+)
By typing a hash (#)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the formula `=A1+B1` do in a spreadsheet?
Adds the values in cells A1 and B1
Multiplies the values in cells A1 and B1
Subtracts B1 from A1
Divides A1 by B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of a relative cell reference?
A$1
$A1
A1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of copying the formula `=B2+C2` from cell D2 to D3?
=B2+C2
=B3+C3
=B1+C1
=B2+C3
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used to make a cell reference absolute in a spreadsheet formula?
$
#
&
%
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Both references are relative
Both references are absolute
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you copy the formula `=A1*2` from cell B1 to cell B2, what will the formula become in B2?
=A1*2
=A2*2
=B1*2
=B2*2
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?
Similar Resources on Wayground
25 questions
DAYS 2 TIK
Quiz
•
8th Grade
25 questions
Unit 1: Being Social Online - TEST
Quiz
•
8th Grade
25 questions
CSS Font Property Quizziz
Quiz
•
6th Grade - University
27 questions
Microsoft PowerPoint Review Part 1
Quiz
•
6th - 8th Grade
30 questions
Team Game Tournament
Quiz
•
8th Grade - University
30 questions
Year 8 ICT Summative Assessment - Term 3.1 - 2024-2025
Quiz
•
8th Grade
30 questions
PENILAIAN TENGAH SEMESTER
Quiz
•
7th Grade - University
25 questions
Ulangan Harian 2
Quiz
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Information Technology (IT)
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
15 questions
Graphing Inequalities
Quiz
•
7th - 9th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
10 questions
SOL REVIEW 4: Organizational Patterns
Quiz
•
6th - 8th Grade
12 questions
Final Figurative Language Review
Lesson
•
6th - 8th Grade
8 questions
8th U5L20 Volume of Sphere
Quiz
•
8th Grade