S3 Spreadsheets - Absolute Cell References

Flashcard
•
Business, Other
•
9th Grade
•
Hard
Wayground Content
FREE Resource
Student preview

15 questions
Show all answers
1.
FLASHCARD QUESTION
Front
Select the relative cell reference from the following options: A, A7, 7, $A$7.
Back
A7
2.
FLASHCARD QUESTION
Front
Which formula uses an absolute cell reference? Options: =A1+B2, =A1+$B$2, =A1*B2, =A1/B2
Back
=A1+$B$2
3.
FLASHCARD QUESTION
Front
Which symbol makes a cell reference absolute? Options: @, &, #, $
Back
$
4.
FLASHCARD QUESTION
Front
Absolute cell references should be used when possible to avoid having to make multiple updates when a key value changes.
Back
True
5.
FLASHCARD QUESTION
Front
Absolute cell references do not change when replicated (filled down).
Back
True
6.
FLASHCARD QUESTION
Front
Which key on the keyboard do we press to make a cell reference absolute?
Back
F4
7.
FLASHCARD QUESTION
Front
A type to cell reference that does not change when copied or filled is called
Back
Absolute cell reference
Create a free account and access millions of resources
Similar Resources on Wayground
13 questions
Speed Quiz

Flashcard
•
8th Grade
9 questions
Lesson 1- Distance and Displacement

Flashcard
•
10th Grade
15 questions
Solving Absolute Value Inequalities Practice Set

Flashcard
•
9th Grade
15 questions
Absolute Value Functions

Flashcard
•
9th Grade
15 questions
Absolute Value Transformations

Flashcard
•
9th Grade
16 questions
Persuasive Techniques in Birmingham Jail

Flashcard
•
8th Grade
10 questions
Google Sheets: Working with Functions Flashcard

Flashcard
•
8th Grade
13 questions
Resumes, References and Job Applicants

Flashcard
•
8th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade