S3 Spreadsheets - Absolute Cell References

S3 Spreadsheets - Absolute Cell References

9th Grade

10 Qs

quiz-placeholder

Similar activities

BA10 1.03

BA10 1.03

9th - 12th Grade

8 Qs

Excel 1-3

Excel 1-3

9th Grade

15 Qs

Taller de Discapacidad 2021

Taller de Discapacidad 2021

1st - 12th Grade

12 Qs

Vitamins and Minerals

Vitamins and Minerals

9th - 12th Grade

15 Qs

Cell Referencing in Excel

Cell Referencing in Excel

9th - 12th Grade

6 Qs

Електронні таблиці Excel.

Електронні таблиці Excel.

7th - 9th Grade

10 Qs

Multiplying Exponents with Same Base

Multiplying Exponents with Same Base

7th - 9th Grade

10 Qs

Business Excel FInal

Business Excel FInal

9th - 12th Grade

10 Qs

S3 Spreadsheets - Absolute Cell References

S3 Spreadsheets - Absolute Cell References

Assessment

Quiz

Business, Other

9th Grade

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?