Basic Formulas Review

Question 1

All formulas and functions start with a/an ______ sign.

Accepted Answer

Equal

Question 2

What order does Google Sheets follow when calculating formulas?

Accepted Answer

Order of Operations

Question 3

An equal sign is inserted for you when a function is used.

Accepted Answer

True

Question 4

Formulas in Google Sheets can use

Accepted Answer

Both A and B

Question 5

Calculation the following equation as Google Sheets would. (5+5)*3

Accepted Answer

30

Question 6

Which is the correct formula? Divide cell A7 by cell C7, then subtract 22

Accepted Answer

=(A7/C7)-22

Question 7

Write a correct formula: Subtract 12 from B6.

Accepted Answer

=B6-12

Question 8

If you are creating a formula, the equal sign is inserted for you.

Accepted Answer

False

Question 9

The correct acronym for the order of operations is

Accepted Answer

PEMDAS

Question 10

Calculation the following equation as Google Sheets would. 5+5*3

Accepted Answer

20

Question 11

Write a Formula that multiplies cell D4 by 12%.

Accepted Answer

=D4*12%

Question 12

Write a Formula that multiplies the sum of B3 and B12 by the sum of C4 and C14.

Accepted Answer

=(B3+B12)*(C4+C14)

Question 13

What is the correct operator/symbol for division in Google Sheets?

Accepted Answer

/

Question 14

Write a correct formula: Add 25 to cell B6

Accepted Answer

=B6+25

Question 15

What is the correct operator/symbol for multiplication in Google Sheets?

Accepted Answer

*

Questions 15