WorksheetsGoogle Sheets for Beginners
Total questions: 8
Worksheet time: 4mins
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.
