Excel: Relative/Absolute Addressing
Authored by deethreecay deethreecay
Computers
7th Grade
Used 2+ 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.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell D2 formula: =A2
Copied to Cell D3, formula: ???
=A2
=A3
=B2
=B3
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell D4 formula: =A2
Copied to Cell G4, formula: ???
=D2
=F2
=G2
=A5
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell D2 formula: =A2+C1
Copied to Cell E2, formula: ???
=B2+D1
=B3+C2
=A2+C1
=A3+C2
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Cell D2 formula: =SUM(A2:C2)
Copied to Cell E3, formula:
=SUM(B2:C2)
=SUM(B2:D2)
=SUM(B3:D3)
=SUM(A3:C3)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell A2 formula: = $A$20
Copied to Cell D2, formula:
= A20
= $A20
= A$20
= $A$20
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell A2 formula: = $B2
Copied to Cell A3, formula:
= $B2
= $B3
= $C2
= $A3
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell B1 formula: = $B4+$C4
Copied to Cell C1, formula:
= $B4+$C4
= $C4+$D4
= $B5+$C5
= $C5+$D5
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
10 questions
TIK Excel
Quiz
•
KG - 7th Grade
10 questions
Microsoft Publisher
Quiz
•
7th - 10th Grade
11 questions
Year 7 HTML
Quiz
•
7th - 9th Grade
11 questions
Extreme Sports Homework Quiz 2
Quiz
•
7th Grade
10 questions
Computer trivia!
Quiz
•
5th - 8th Grade
10 questions
1º ESO Electricity
Quiz
•
7th - 8th Grade
10 questions
Excel đơn giản 1
Quiz
•
7th Grade
16 questions
Google Sheets
Quiz
•
3rd - 8th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
14 questions
Volume of rectangular prisms
Quiz
•
7th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
11 questions
Valentines Day
Quiz
•
6th - 8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
25 questions
7th Reading STAAR Vocabulary
Quiz
•
6th - 8th Grade
20 questions
Revising & Editing practice
Quiz
•
7th Grade