Understanding Google Sheets Basics

Which menu would you use to insert a chart in Google Sheets?

• File

• Edit

• Insert

• Tools

Karleigh is working on a project in Google Sheets and needs to insert a chart to represent her data visually. Which menu would she use to insert a chart?

• File

• Edit

• Insert

• Tools

What symbol is used to start a formula in Google Sheets?

• $

• @

• =

• #

Which function would you use to find the sum of values in cells A1 to A5?

• =AVERAGE(A1:A5)

• =SUM(A1:A5)

• =COUNT(A1:A5)

• =MIN(A1:A5)

What does the fill handle in Google Sheets allow you to do?

• Change font size

• Copy cell contents or continue a sequence

• Insert a new sheet

• Delete a row

Which of the following is NOT a valid data type in Google Sheets?

• Text

• Audio

• Number

How can you share a Google Sheets file with someone else for real time shared editing?

• By printing it

• By using the Share button

• By deleting it

• By renaming it

What is the purpose of the “Freeze” feature in Google Sheets?

• To lock certain rows or columns in place while scrolling

• To delete data

• To change cell color

• To insert images

If you want to calculate the average of numbers in cells B1 to B10, which formula should you use?

• =SUM(B1:B10)

• =AVERAGE(B1:B10)

• =MIN(B1:B10)

• =COUNT(B1:B10)

What is the best way to sort a list of names in alphabetical order?

• 
• 
•