Search Header Logo

Introduction to Microsoft Excel

Authored by Fayon McCalla

Computers

9th Grade

Used 1+ times

Introduction to Microsoft Excel
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

38 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

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

Absolute
relative

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the Average formula return?

Returns the lowest argument.

Returns the middle argument.

Returns the three highest arguments.

Returns the mean of all its arguments.

4.

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.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

By default, all cell references are _________ references. 

Absolute
Relative

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

What does the Average formula return?

Returns the lowest argument.

Returns the middle argument.

Returns the three highest arguments.

Returns the mean of all its arguments.

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?

Discover more resources for Computers