Search Header Logo

Cell Referencing in Excel Quiz

Authored by Gyem Tshering

Computers

9th Grade

Used 3+ times

Cell Referencing in Excel Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does cell referencing in Excel allow users to refer to?

Entire worksheet

Formatting options

Specific cell or range of cells in a formula or function

Only text in a cell

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of cell referencing adjusts to the new location when copied to another cell?

Static Cell Referencing

Mixed Cell Referencing

Absolute Cell Referencing

Relative Cell Referencing

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When a formula is copied to another cell, what happens to cell references in Excel by default?

They are automatically adjusted based on the new location

They remain the same

They are deleted

They become bold

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Absolute Cell Referencing in Excel allow you to lock?

Entire row

Specific cell or range of cells

Entire worksheet

Entire column

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Absolute Cell Referencing, what do you add before the column letter and row number of the cell reference to remain constant?

$

&

#

@

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Mixed Cell Referencing in Excel allow you to fix while allowing the other to change when copied or filled?

Only the first cell

Both row and column

Neither row nor column

Either the row or column

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of cell referencing is a mixture of both absolute and relative referencing?

Mixed Cell Referencing

Dynamic Cell Referencing

Hybrid Cell Referencing

Variable Cell Referencing

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?