Quiz - Dec 11
Authored by Aye Nyein
Computers
5th Grade
Used 10+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which cell reference will not change if copied or moved?
&A&2
A*2
$A$2
%A%2
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
How does a relative reference differ from an absolute reference?
A relative reference specifies column and row references
A relative reference adjusts to its location on the worksheet
A relative reference refers to an existing cell reference
A relative reference refers to an original value
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is an absolute cell reference?
P72
G$9
$K356
$F$8
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the name given to a value that does NOT change when used within a formula?
Reference
Constant
Function
Address
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is an mixed cell reference with a fixed column address?
P72
G$9
$K356
$F$8
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is mixed cell reference with a fixed row address?
P72
G$9
$K356
$F$8
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is a relative cell reference?
P72
G$9
$K356
$F$8
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?
