GCF Global Creating Simple Formulas Google Sheets Quiz

What can Google Sheets be used for when working with numerical information?

• Creating complex algorithms

• Performing automatic data analysis

• Performing calculations and analyzing data

• Designing graphics and illustrations

In Google Sheets, what will happen if you change a value in a cell that is referenced by a formula?

• The formula will need to be manually recalculated

• The cell's address in the formula will change

• The formula will automatically recalculate

• The change will not affect the formula

What is the advantage of using cell references in your formulas in Google Sheets?

• It ensures the values in your formulas are accurate

• It allows you to merge cells automatically

• It changes the format of the cells

• It locks the cells for editing

What will this lesson focus on regarding formulas in Google Sheets?

• Formulas that contain multiple mathematical operators

• Formulas that contain one mathematical operator

• Formulas that require manual calculation

• Formulas that are used for text manipulation

What does the formula =A1+A2 do in Google Sheets?

• Subtracts cell A1 from A2

• Adds cells A1 and A2

• Divides cell A1 by A2

• Multiplies cells A1 and A2

What is the result of the formula =C4-3 in Google Sheets?

• Divides cell C4 by 3

• Adds 3 to cell C4

• Subtracts 3 from cell C4

• Multiplies cell C4 by 3

How does the formula =E7/J4 function in Google Sheets?

• Adds cell E7 to J4

• Subtracts cell J4 from E7

• Divides cell E7 by J4

• Multiplies cell E7 by J4

What operation is performed by the formula =N10*1.05 in Google Sheets?

• Divides cell N10 by 1.05

• Subtracts 1.05 from cell N10

• Adds 1.05 to cell N10

• Multiplies cell N10 by 1.05

What does the formula =R5^2 do in Google Sheets?

• Divides cell R5 by 2

• Adds 2 to cell R5

• Subtracts 2 from cell R5

• Finds the square of cell R5

What is the first step in creating a formula according to the example provided?

• Type the cell address of the cell you want to reference second in the formula.

• Press the Enter key on your keyboard.

• Select the cell that will display the calculated value.

• Type the operator you want to use.