S3 Spreadsheets - Absolute Cell References

Quiz
•
Business, Other
•
9th Grade
•
Medium

McC
Used 38+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
There are 2 types of cell reference, absolute and relative. Select the relative cell reference.
A
A7
7
$A$7
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula uses an absolute cell reference?
=A1+B2
=A1+$B$2
=A1*B2
=A1/B2
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol makes a cell reference absolute?
@
&
#
$
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Absolute cell references should be used when possible to avoid having to make multiple updates when a key value changes.
True
False
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Absolute cell references do not change when replicated (filled down).
True
False
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these formula will calculate 10% of an amount.
= 10% / B3
= B3 / 10
= 10% * B3
= B3 * 5%
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which key on the keyboard do we press to make a cell reference absolute?
F2
F4
F6
F8
Create a free account and access millions of resources
Similar Resources on Wayground
8 questions
Las casillas

Quiz
•
1st - 10th Grade
8 questions
BA10 1.03

Quiz
•
9th - 12th Grade
12 questions
Taller de Discapacidad 2021

Quiz
•
1st - 12th Grade
10 questions
Introduction to Excel

Quiz
•
9th - 12th Grade
15 questions
Microsoft Excel Functions & Formulas

Quiz
•
3rd Grade - Professio...
10 questions
Електронні таблиці Excel.

Quiz
•
7th - 9th Grade
10 questions
ICT CAT 3 - YR 5

Quiz
•
5th Grade - University
15 questions
Táblázatkezelés alapjai. 9.osztály

Quiz
•
9th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Business
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
24 questions
Scientific method and variables review

Quiz
•
9th Grade
10 questions
Characteristics of Life

Quiz
•
9th - 10th Grade
19 questions
Mental Health Vocabulary Pre-test

Quiz
•
9th Grade
14 questions
Points, Lines, Planes

Quiz
•
9th Grade