Google Sheet Chapter 2

What should be included in a cell in a Spreadsheet that contains two types of data?

• Address and content

• Number and text

• Formula and number

• Address and formula

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

• C2

• 2C

What can a cell contain in Google Sheet?

• Numbers and text

• Text and formulas

• Numbers and formulas

• Numbers, text, and formulas

How to represent a formula in Google Sheets?

• Add an equal sign

• Add a plus sign

• Add a minus sign

• Add a multiplication sign

What happens to the cell containing the formula when the values of the related cells are changed in Google Sheet?

• Remains unchanged

• Becomes blank

• Recalculates based on the formula

• Becomes an error value

How to drag a formula to other related cells in Google Sheet?

• Hold Shift key and drag

• Select the blue dot of the cell and drag

• Hold Alt key and drag

• Hold Crtl key and drag

How to filter a range of cells in Google Sheets?

• Select all cells and click the Filter button

• Select the cells to be filtered and click the Filter button

• Select the cells to be filtered and click the Sort button

• Select all cells and click the Sort button

How to sort a range of cells in Google Sheet?

• Select all cells and click on the Filter button

• Select the cells to be sorted and click on the Filter button

• Select the cells to be sorted and click on the Sort button

• Select all cells and click on the Sort button

What is the purpose of sorting in Google Sheets?

• To organize data in a specific order

• To filter data based on specific criteria

• To calculate the average of a range of values

• To format cells with specific styles

What does the 'Header Row' refer to in Google Sheets?

• The first row of a spreadsheet

• The row that contains the column names

• The row that contains the total sum of values

• The row that contains the average of values