Search Header Logo

Excel 2016 Advanced Formulas Mastery

Authored by Thomas Martinez

Computers

6th - 9th Grade

Excel 2016 Advanced Formulas Mastery
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

19 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

perform calculations or other actions.
find averages.

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Media Image

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

True

False

3.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

Order of Operations
Formula Guidelines

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Define Formula Bar?

An element in Excel or Google Sheets that appears below the grid and to the left of the zoom control that shows the deleted commands.

A button or key in your keyboard to write the formulas.

An element in Excel or Google Sheets that appears below the Ribbon that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the Sum formula?

Sum( )

Sum( )=

=Sum( )

=( )Sum

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

When starting a formula what is the first thing you type in the cell?

;

?

%

=

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

How would you write a cell reference formula for cell A1 subtracted from Cell C3?

A1-C3

A1-C3=

=A1-C3

=C3-A1

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?