Lesson 15 Creating Simple Formulas

Lesson 15 Creating Simple Formulas

Assessment

Passage

Computers

6th - 8th Grade

Easy

Created by

Colleen ES]

Used 105+ times

FREE Resource

7 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Google Sheets uses mathematical expressions called ___ to perform calculations.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the symbol used for multiplication in Google Sheets formulas?

*

/

+

-

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Google Sheets, all formulas must begin with which symbol?

=

+

-

*

4.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Using a cell's address in a formula is known as using a ___ reference.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a standard operator in Google Sheets?

%

^

*

/

6.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

To create a formula, you must first select the cell that will display the ___ value.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens when you change a value in a referenced cell in Google Sheets?

The formula automatically recalculates.

The formula remains the same.

The cell address changes.

The formula is deleted.