Google Sheets for Beginners

How can you freeze rows and columns in Google Sheets?

• Select the rows and columns to be frozen and click "Freeze" from the "Edit" menu.

• Right-click on the row or column header and choose "Freeze" from the context menu.

• Go to "View" in the menu, then select "Freeze" and choose the number of rows or columns to freeze.

• All the above.

What is the purpose of adding headings to a spreadsheet in Google Sheets?

• Headings help organize and categorize data in the spreadsheet.

• It adds a title to the sheet for decoration purposes.

• Headings allow you to format the text in various styles and colors.

• All the above.

How can you add checkboxes in Google Sheets?

• Type an "X" in the cell where you want the checkbox to appear.

• Use the "Checkboxes" option from the "Insert" menu.

• Checkboxes cannot be added in Google Sheets.

• All the above.

Which option allows you to add a dropdown menu to a cell in Google Sheets?

• Use the "Data Validation" feature from the "Data" menu.

• Create a list of options and use the "Dropdown" button from the "Format" menu.

• Right-click on the cell and choose "Dropdown" from the context menu.

• All the above.

How can you delete rows and columns in Google Sheets?

• Use the "Edit" menu and select "Delete Rows" or "Delete Columns."

• Press the "Ctrl + R" or "Ctrl + C" keyboard shortcuts to delete a row or column.

• Click on the first cell in the row or column and click X.

• All the above.

How do you add a new row or column in Google Sheets?

• Use the "Add Row" or "Add Column" option from the "Edit" menu.

• Use the "Add Row" or "Add Column" option from the "Format" menu.

• Use the "Add Row" or "Add Column" option from the "File" menu.

• All the above.

How can you format cells in Google Sheets?

• Use the "Format Cells" option from the "Format" menu.

• Use the icons on the toolbar to apply different formatting options.

• Right-click on the cells and choose "Format Cells" from the context menu.

• All the above.

What can you achieve using the "Explore" tool in Google Sheets?

• It allows you to visually analyze data and create charts and graphs.

• Explore suggests the most appropriate formulas to use for specific calculations.

• It provides real-time collaboration features with other users.

• All the above.