Search Header Logo

Google Sheets Quiz

Authored by Robert LaBanca

Computers

12th Grade

Used 4+ times

Google Sheets Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In a Google Spreadsheet, the letters across the top represent __________.

Rows
Numbers
Columns
Functions

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a feature of Google Sheets?

Offline access, image editing tools, video conferencing

Real-time collaboration, data analysis tools, formulas and functions, import and export data

Spreadsheets, word processing, presentation software

Social media integration, cloud storage, project management

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Avery, Ethan, and Priya are working on a group project in Google Sheets. They want to highlight the important points by changing the font size of certain cells. How can they do this?

Select the cell or cells they want to change, then click on the 'Font size' drop-down menu in the toolbar and select the desired font size.

Right-click on the cell and select 'Font size'

Go to the 'Format' menu and select 'Font size'

Type the font size in the cell and press enter

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function used to sum a range of cells in Google Sheets?

AVERAGE

MAX

SUM

COUNT

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a valid cell reference in Google Sheets?

AA1

0A

B2

C3

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply a border to a cell in Google Sheets?

Select the cell or range of cells, click on the 'Borders' button, and choose the desired border style.

Right-click on the cell and select 'Apply Border'

Go to the 'Format' menu and choose 'Border'

Press Ctrl+B to apply a border to the cell

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to calculate the average of cells A1 to A10 in Google Sheets?

=AVERAGE(A1:A10)*10

=AVERAGE(A1:A10)

=SUM(A1:A10)/10

=AVERAGE(A1:A10)/10

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?