Font size
WorksheetsTechnology and Computing Quiz
Total questions: 39
Worksheet time: 20mins
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
What does the 'Comment' feature in Google Docs allow you to do?
Add notes to the document without changing the content
Change the font style of the text
Delete sections of the document
Share the document with others
What does the 'COUNT' function in Google Sheets do?
Counts the number of cells in a range that contain numbers
Adds a range of cells
Subtracts a range of cells
Multiplies cells in a range
How can you share a Google Docs document with others?
Press Ctrl+S
Right-click and select 'Share'
Click 'Share' in the top right
Type the email addresses directly into the document
Which component is often overclocked?
What is the function of the CPU in a computer?
It stores data and software
It performs all the processing inside the computer
It connects the computer to the internet
It provides power to the computer
What is the primary function of a computer's processor?
It stores data and information
It performs calculations and executes instructions
It provides a user interface
It manages peripherals and external devices
What is the purpose of RAM in a computer?
It stores the operating system
It provides a user interface
It stores data and applications currently in use
It manages peripherals and external devices
What is the role of a computer's hard drive?
It performs calculations and executes instructions
It provides a user interface
It manages peripherals and external devices
It stores data and information
What is the function of 'Sort Range' in Google Sheets?
It arranges the cells in a specific order
It deletes a range of cells
It merges a range of cells
It changes the color of a range of cells
What is the shortcut for 'Paste' operation in Google Docs?
Ctrl+V
Ctrl+P
Ctrl+C
Ctrl+X
How can you create a new sheet in Google Sheets?
Click on 'File' and select 'New Sheet'
Right-click on the tab bar and select 'New Sheet'
Click on the '+' button next to the sheet tabs
Press Ctrl+N
What does 'Comment' access allow collaborators to do in a shared Google document?
View and comment on the document
Edit the document
Share the document with others
View the document only
How can you insert a table in a Google Docs document?
Press Ctrl+T
Type 'Table' directly into the document
Right-click and select 'Insert Table'
Use the 'Insert' menu and choose 'Table'
What does the 'SUM' function in Google Sheets do?
Counts the number of cells in a range
Adds the values in a range of cells
Subtracts the values in a range of cells
Divides the values in a range of cells
Which tool in Google Docs helps in checking spelling errors?
Grammarly
Spell Check
Word Count
Thesaurus
What does the 'Research' 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
What is the role of the Hard Drive in a computer?
It performs all the processing inside the computer
It stores data and software
It provides power to the computer
It connects the computer to the internet
What is the purpose of the 'Find and Replace' feature in Google Docs?
It lists all instances of a specific word or phrase
It creates a reference list at the end of the document
It automatically replaces a specific word or phrase with another
It provides a summary of the document
What is the function of the Graphics Processing Unit (GPU) in a computer?
It stores data and applications currently in use
It provides a user interface
It manages peripherals and external devices
It handles rendering graphics and image processing
What function does the AVERAGE formula serve in Google Sheets?
It calculates the median of a range of cells
It calculates the average of a range of cells
It calculates the sum of a range of cells
It calculates the mode of a range of cells
How can you freeze rows or columns in Google Sheets?
Use the 'View' menu and choose 'Freeze'
Use the 'Format' menu and choose 'Freeze'
Press Ctrl+F and then Ctrl+Z
Select File, and then scream.
What does the 'Revision History' feature in Google Docs allow you to do?
Change the font style of the text
Track changes made to the document over time
Delete sections of the document
Share the document with others
What is the primary function of a computer's RAM?
It performs calculations and executes instructions
It provides a user interface
It stores data and information for quick access
It manages peripherals and external devices
What does the COUNT formula in Google Sheets do?
Counts the number of cells in a range that contain numbers
Adds a range of cells
Subtracts a range of cells
Multiplies cells in a range
What is the primary function of a computer's RAM?
It stores data and information
It provides a user interface
It manages peripherals and external devices
It temporarily holds data and information for quick access
How can you make a copy of a Google Docs document?
Press Ctrl+C
Right-click and select 'Copy'
Click 'File' then 'Make a copy'
Type the document into a new file
What happens when you share a Google Docs document with 'View' permissions?
The person can edit the document
The person can only view the document
The person can delete the document
The person receives notifications but cannot view the document
What is the function of a computer's CPU?
It stores data and information
It performs calculations and executes instructions
It manages peripherals and external devices
It provides a user interface
How can you add a comment to a Google Docs document?
Press Ctrl+C
Right-click and select 'Comment'
Click 'Insert' then 'Comment'
Type the comment directly into the document
