Introduction to Google Sheets

Multiple Choice

Which of the following is the correct way to select an entire row?

• Select the first column only.
• Click the row number on the left

• Click the column letter on the top

• Use the formula bar

Multiple Choice

What is the purpose of the formula bar?

• To calculate the sum of numbers in a cell.
• To create charts and graphs from data.
• To view and edit cell contents and formulas.
• To format the appearance of the spreadsheet.

Multiple Choice

Which of the following is a basic formula function in Google Sheets?

• MAX
• ADD

• SUM
• COUNT

Multiple Choice

How would you add a new sheet (page) to a Google Sheets document?

• Press Ctrl + N to create a new sheet.
• Right-click and select 'Add Sheet' from the menu.
• Click the '+' icon at the bottom left of the Google Sheets document.
• Use the 'File' menu and choose 'New' to add a sheet.

Multiple Choice

Which option is used to merge multiple cells together?

• Format > Align Cells

• Insert > Merge Cells

• Format > Merge Cells

• Tools > Merge Cells

Open Ended

What is the main purpose of using Google Sheets?

Open Ended

Explain the difference between relative and absolute cell references.

Open Ended

What is a quick way to format multiple cells at once in Google Sheets?

Open Ended

Why would you use a formula in Google Sheets? Provide an example.

Open Ended

Describe how to delete a row or column in Google Sheets.