How to use Google Sheets

Perry and Addison are working on a Google Sheets document to track their monthly lunch expenses. They want to add the total expenses of each month. What formula should they use for addition in Google Sheets?

• A. +

• B. -

• C. *

• D. /

Nolan, Brooks, and Catherine are working on a spreadsheet for their science project and need to create a formula. How should they create a formula using cell references?

• A. Enter the numbers directly into the formula

• B. Use cell addresses instead of numbers in the formula

• C. Use the point and click method to select cells for the formula

• D. Start the formula with an equal sign

Fisher is working on his Food Truck Menu spreadsheet in Google Sheets. He wants to calculate the total cost of items he bought. What key should he use for multiplication?

• A. +

• B. -

• C. *

• D. /

Willie is working on his Food Truck Menu spreadsheet in Google Sheets and he needs to edit a formula. How can he do this?

• A. Double click the cell

• B. Press the Enter key

• C. Use the point and click method

• D. Rewrite the entire formula

Lawton has a spreadsheet where he keeps track of the monthly sales of his Food Truck. He has a formula that calculates the total sales. What happens when Evelyn changes the values in the cells that Lawton's formula references?

• A. The formula becomes invalid

• B. The formula remains the same

• C. The formula updates automatically

• D. The formula needs to be rewritten by Aiden

Weston and Addie are working on their Food Truck Menu spreadsheet in Google Sheets and need to adjust their formula. How can they do this?

• A. Weston and Addie can double click the cell containing the formula

• B. Weston and Addie can press the Enter key

• C. Weston and Addie can use the point and click method

• D. Weston and Addie needs to rewrite the entire formula

Mrs. O'Donnell's STEAM class is working on their Food Truck Menu Google Sheets project. They need to subtract some numbers. What is the formula he should use for subtraction in Google Sheets?

• A. +

• B. -

• C. *

• D. /

Mrs. O'Donnell is working on a Google Sheets document and needs to divide the values in two cells. What formula should she use for division?

• A. +

• B. -

• C. *

• D. /