
Google Sheets Quiz
Authored by Robert LaBanca
Computers
12th Grade
Used 4+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a Google Spreadsheet, the letters across the top represent __________.
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

Continue with Google

Continue with Email

Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?