Google Sheets and Docs Quiz

What is the first step to create a new spreadsheet in Google Sheets?

• Open Google Sheets and click on '+ Blank'

• Right-click on a cell and select 'Insert'

• Navigate to Google Drive and select 'Google Sheets'

• Click on 'File' and select 'New'

Which of the following is NOT a way to format text in Google Sheets?

• Adjusting text color

• Inserting hyperlinks

• Applying bold or italic styles

• Changing font size

How can you protect a range of cells in Google Sheets?

• Right-click and select 'Protect range'

• Use the 'Format' menu to lock cells

• Select cells and press Ctrl + P

• Click on 'Data' and choose 'Protect'

What is the purpose of the Autosum feature in Google Sheets?

• To create a new spreadsheet

• To quickly sum a range of numbers

• To insert comments

• To automatically format cells

In Google Docs, how can you add a comment to a specific part of the document?

• Highlight the text and press Ctrl + C

• Click on the 'Comment' button in the toolbar

• Right-click on the text and choose 'Add Comment'

• Select the text and click 'Insert' then 'Comment'

Which permission allows users to view and comment on a Google Sheets document but not edit it?

• Collaborator

• Commenter

• Viewer

• Editor

What feature allows multiple users to edit a Google Docs document simultaneously?

• Suggesting changes

• Version history

• Real-time editing

• Commenting

How can you restore a previous version of a Google Docs document?

• Click on 'File' and select 'Restore version'

• Select 'Undo' from the toolbar

• Access 'Version history' and choose 'Restore this version'

• Use the 'Edit' menu to revert changes

Which function would you use to calculate the average of a range of numbers in Google Sheets?

• SUM

• AVERAGE

• MAX

• COUNT

What is the purpose of the fill handle in Google Sheets?

• To copy and paste data

• To format cells

• To fill a series of data

• To insert rows and columns