Google Sheets Essentials Unit 2

What is the definition of the vocabulary word: Formula?

• A mathematical relationship or rule expressed in symbols

• A type of chemical compound

• A type of document format

• A type of programming language

Why do formulas make spreadsheets more powerful?

• They allow for automatic calculations and data analysis.

• They make the spreadsheet look more colorful.

• They reduce the file size of the spreadsheet.

• They increase the loading time of the spreadsheet.

Which of the following describes the three parts of a formula?

• Operands, Operators, and Functions

• Variables, Constants, and Expressions

• Inputs, Outputs, and Processes

• Numbers, Symbols, and Equations

Define the following operators: +, -, *, and /.

Evaluate responses using AI:

OFF

Which of the following are ways to enter a formula in a spreadsheet?

• 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'

How can you see the formula in a cell in a spreadsheet?

• Double-click the cell

• Press F2

• Look at the formula bar

• Right-click and select 'Show Formula'

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

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

• It allows for easier editing and viewing of complex formulas.

• It automatically corrects errors in the formula.

• It provides a list of all available functions.

• It formats the formula for printing.

What is a Cell Reference?

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

• A formula used to calculate values in a spreadsheet.

• A type of data format used in spreadsheets.

• A function that sorts data in a spreadsheet.

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

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

• Color coding is used to make the spreadsheet look more attractive.

• Color coding is a feature that automatically corrects errors in formulas.

• Color coding is used to highlight the most important cells in a spreadsheet.