Search Header Logo

Excel Cell Reference

Authored by Thomas Martinez

Computers

9th - 12th Grade

Excel Cell Reference
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In the picture, why is D2 through D5 placed in parenthesis?

So Excel knows to total the cells before performing the next operation.

So the total of the cells can be multiplied rather than added.

So the calculation will be done last.

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

If the parenthesis is removed, what will 9.5% be multiplied by? 

D2 +D3+D4+D5
D5
D2
None

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which response best completes the following statement: A formula is used to

perform calculations or other actions.

find averages.

Look Up data

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.

total

Sum

percentage

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

True
False

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Excel follows the ___________________ and first adds the values inside the parentheses.

Order of Operations
Formula Guidelines

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

___________ are often the best way to define which calculations will be performed first in Excel.

Parentheses
Forumlas

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?