Google Sheets Quiz

What is Google Sheets?

• A spreadsheet program

• A word processing tool

• A web browser

• A social media app

Which of the following can you use Google Sheets for?

• Create spreadsheets

• Edit documents

• Organize data

• Perform calculations

True or False: Google Sheets is only available offline.

• True

• False

Which menu in Google Sheets contains the option to insert a chart?

• File

• Insert

• Format

• Data

Which feature allows you to apply rules to format data automatically?

• Conditional Formatting

• Find and Replace

• Chart Editor

• Data Validation

True or False: You can collaborate with others in real time on Google Sheets.

• True

• False

Which formula is used to add a range of numbers?

• =SUM()

• =ADD()

• =TOTAL()

• =PLUS()

Which of the following are valid ways to sort data in Google Sheets?

• Alphabetically

• By color

• Numerically

• By date

True or False: Google Sheets can only contain one worksheet per file.

• True

• False

Which tool would you use to remove duplicate values in a column?

• Find and Replace

• Remove Duplicates

• Filter Data

• Sort Sheet