8th Grade Google sheets diagnostic

What is the purpose of Google Sheets?

• Creating and managing spreadsheets
• Sending emails
• Editing photos
• Watching videos
• I don't know

Which tool is used to change the color of a cell in Google Sheets?

• Fill Color tool
• Paintbrush
• Text Color tool
• Highlighter
• I don't know

What function is used to add up a range of cells in Google Sheets?

• SUM
• TOTAL
• ADD
• PLUS
• I don't know

Which feature(s) allows you to sort data in alphabetical or numerical order?

• Sort
• Filter
• Arrange
• Organize
• I don't know

How can you apply automatic formatting to highlight cells that meet certain criteria?

• Conditional Formatting tool
• Bold tool
• Italicize tool
• Underline tool
• I don't know

Which function is used to find the highest value in a range of cells?

• MAX
• HIGHEST
• TOP
• PEAK
• I don't know

What feature allows you to create visual representations of data, such as charts and graphs?

• Google Chart
• Google Slides
• Google Forms
• Google Drawings
• I don't know

What does the formula =A1+B1 do in Google Sheets?

• Adds the values in cells A1 and B1
• Multiplies the values in cells A1 and B1
• Subtracts the value in cell B1 from the value in cell A1
• Divides the value in cell A1 by the value in cell B1
• I don't know

How can you protect a sheet in Google Sheets from being edited by others?

• Locking cells
• Using a password
• Hiding the sheet
• Applying conditional formatting
• I don't know

How can you insert a new row above the selected cell in Google Sheets?

• Right-click and select Insert row
• Press Ctrl + R
• Press Ctrl + Shift + R
• Press Ctrl + I
• I don't know