Google Sheet Chapter 1

What is the purpose of a Google Sheet?

• To help with mathematical calculations

• To create presentations

• To store and organize data

• To edit images and videos

What is the cell reference for David's seat?

• A3

• B3

• C5

• D4

Where was Nancy's seat?

• A3

• B3

• C5

• D4

How can you change the data in a cell?

• Double click the cell and type the new data

• Right click the cell and select 'Edit'

• Press the 'Delete' key to clear the cell

• Drag and drop the data into the cell

What is the result of 3 adults and 3 children using the Fare Table?

• $10.2

• $13.6

• $30.6

• $51

What is the purpose of using formulas in Google Sheets?

• To calculate mathematical operations

• To format cells and apply conditional formatting

• To create charts and graphs

• To import and export data

How can you enter a formula in a cell?

• Double click on the cell and type the formula

• Click on the Fx button next to the formula bar

• Type the formula directly in the cell

• Double click on the cell, press the equal (=) sign and then type the formula

In Google Sheet, how can we represent a cell address？

• C2

• 2C

What is the formula to calculate the sum of cells A1 and B1 in Google Sheets?

• =A1*B1

• =SUM(A1,B1)

• =A1+B1

• =A1-B1

What formula should be used to calculate the product of cells A1 and B1 in Google Sheets?

• =A1*B1

• =A1+B1

• =A1/B1

• =A1-B1