excel absolute reference

excel absolute reference

4th Grade - University

10 Qs

quiz-placeholder

Similar activities

M8 - AddSub RatExp FormQuiz

M8 - AddSub RatExp FormQuiz

8th Grade

10 Qs

Parallelogram-Lets Dig In

Parallelogram-Lets Dig In

9th Grade

10 Qs

SEATWORK #1:INTEGERS AND THE NUMBER LINE

SEATWORK #1:INTEGERS AND THE NUMBER LINE

7th Grade

10 Qs

VOLUME OF LIQUID YEAR 4

VOLUME OF LIQUID YEAR 4

4th Grade

10 Qs

Math Practice Paper Booklet A (16 July)

Math Practice Paper Booklet A (16 July)

6th Grade

15 Qs

All about Decimals

All about Decimals

4th - 6th Grade

15 Qs

Multiplication

Multiplication

3rd - 4th Grade

11 Qs

General Maths Week 2 Quiz Consumer Arithmetic 1b

General Maths Week 2 Quiz Consumer Arithmetic 1b

11th - 12th Grade

10 Qs

excel absolute reference

excel absolute reference

Assessment

Quiz

Mathematics

4th Grade - University

Practice Problem

Medium

Created by

Soraya elsayed

Used 12+ 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

By default, all cell references are _________ references. 

Absolute
Relative

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of an absolute cell reference?

A9

A$9

$A$9

A9:E9

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is always best to use the exact value instead of the cell reference when using formulas.

TRUE

FALSE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can press the F4 key to add the $'s to an absolute reference.

TRUE

FALSE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Unlike _________ references, _________ references do not change when copied or filled. 

Absolute, Relative
Relative, Absolute

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

relative
relational

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A_________ is a built in mathematical formula included in excel.

Function
Cell
Formula

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?