Technology and Computing Quiz

What does the SUM formula in Google Sheets do?

• Adds cells based on a specified condition

• Multiplies cells in a range

• Adds a range of cells

• Subtracts a range of cells

How can you apply conditional formatting to a range of cells in Google Sheets?

• Apply a cell style from the toolbar

• Press Ctrl+C and then Ctrl+V

• Select File, and then cry.

• Use the 'Format' menu and choose 'Conditional formatting'

Which formula is used for finding the average in Google Sheets?

• MEAN

• AVERAGE

• SUM

• AVG

What is the purpose of the 'Freeze' feature in Google Sheets?

• Hides rows or columns

• Deletes selected cells

• Locks cells to prevent editing

• Freezes rows or columns to keep them visible while scrolling

What is the purpose of the Table of Contents feature in Google Docs?

• It lists all tables in the document

• It creates a reference list at the end of the document

• It automatically generates a list of headings with links

• It provides a summary of the document

Which tool in Google Docs provides suggestions for improving writing style and content?

• Grammarly

• Explore

• Word Count

• Thesaurus

How can you insert a hyperlink in a Google Docs document?

• Press Ctrl+H

• Type the URL directly into the document

• Right-click and select 'Insert Hyperlink'

• Use the 'Insert' menu and choose 'Link'

What does the 'Explore' tool in Google Docs do?

• It searches the web for relevant information based on the document content

• It suggests alternate words for selected text

• It helps create charts and graphs

• It provides design suggestions for the document

When sharing a Google document, what does 'View' access allow collaborators to do?

• View the document only

• View and comment on the document

• Edit the document

• Share the document with others

What happens when you collaborate in real-time on a Google Sheets document?

• Only one person can edit at a time

• Changes are visible to collaborators instantly

• Changes are saved locally

• Collaborators receive notifications but cannot edit