S3 Spreadsheets - Absolute Cell References

S3 Spreadsheets - Absolute Cell References

9th Grade

10 Qs

quiz-placeholder

Similar activities

Ch 13 Political and Economic Institutions

Ch 13 Political and Economic Institutions

KG - University

10 Qs

Types of Government Review

Types of Government Review

6th - 12th Grade

10 Qs

Politics

Politics

9th Grade

15 Qs

Fashion Era

Fashion Era

9th - 12th Grade

14 Qs

AMI Day 2

AMI Day 2

9th - 12th Grade

8 Qs

Energy, Plants, Inquiry

Energy, Plants, Inquiry

KG - University

15 Qs

Digital Video Production Vocab 1

Digital Video Production Vocab 1

8th - 12th Grade

11 Qs

Vague pronouns

Vague pronouns

6th Grade - Professional Development

13 Qs

S3 Spreadsheets - Absolute Cell References

S3 Spreadsheets - Absolute Cell References

Assessment

Quiz

Business, Other

9th Grade

Practice Problem

Medium

Created by

McC

Used 38+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?