Spreadsheets Major Test Retest

Front

In Google Sheets, how does an equation start?

Back

With an equal sign

Front

How do you recalculate totals automatically in Google Sheets?

Back

By using cell references

Front

What method can be used to make cell references in Google Sheets?

Back

Point and click method

Front

What is the purpose of using formulas in Google Sheets?

Back

To calculate data

Front

What is the correct order of operations?

Back

Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

Front

What phrase helps to remember the order of operations?

Back

Please Excuse My Dear Aunt Sally

Front

What is the first step in the order of operations?

Back

Parentheses

Front

What are mixed references in Google Sheets?

Back

References that only lock the row or the column when copied

Front

How can you make a cell reference absolute in Google Sheets?

Back

By adding a dollar sign before the column and row

Front

Formula example for calculating the amount spent on food items (Hint: you have 5 apples that cost $0.25 each)

Back

=B4*C4