Search Header Logo

Excel Formula Practice

Authored by Elizabeth Coughlin

Business

9th Grade

Used 6+ times

Excel Formula Practice
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

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

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Order of Operations
Formula Guidelines

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

By default, all cell references are _________ references. 

Absolute
Relative

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

%

$

&

#

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want a cell reference to change when copied to other cells, use _________ references

Absolute
Relative

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not an arithmetic operator?

=

+

s

^

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?