Google Sheets Essentials Unit 2

Front

What is the definition of the vocabulary word: Formula?

Back

A mathematical relationship or rule expressed in symbols

Front

Why do formulas make spreadsheets more powerful?

Back

They allow for automatic calculations and data analysis.

Front

Which of the following describes the three parts of a formula? Options: Operands, Operators, and Functions; Variables, Constants, and Expressions; Inputs, Outputs, and Processes; Numbers, Symbols, and Equations

Back

Operands, Operators, and Functions

Front

Which of the following are ways to enter a formula in a spreadsheet? Options: Using the formula bar and typing directly into a cell, Using the formula bar and clicking on the 'Insert Function' button, Using the 'Data' tab and selecting 'Data Validation', Using the 'Review' tab and selecting 'Track Changes'

Back

Using the formula bar and typing directly into a cell

Front

How can you see the formula in a cell in a spreadsheet? Options: Double-click the cell, Press F2, Look at the formula bar, Right-click and select 'Show Formula'

Back

Look at the formula bar

Front

Which of the following are ways to edit a formula?
- Double-click the cell containing the formula
- Use the formula bar to make changes
- Right-click the cell and select 'Edit'
- Press the 'Delete' key

Back

Double-click the cell containing the formula

Front

What is the benefit of entering or editing a formula using the Formula Bar?

Back

It allows for easier editing and viewing of complex formulas.

Front

What is a Cell Reference?

Back

A unique identifier for a cell in a spreadsheet, consisting of the column letter and row number.

Front

Explain how the color coding of cell references in a formula works and why it is useful.

Back

Color coding helps in identifying different cell references easily and reduces errors.

Front

Describe the two ways you can enter cell references into a formula.

Back

Using the keyboard to type the cell reference directly; Clicking on the cell to automatically insert the reference.