wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets for Middle School

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

The correct formula to add cell B1 and B2 is

a)

AddB1+C1

b)

=add(b1:b2)

c)

=B1+B2

d)

=total(B1-B2)

2.

B1 is a?

a)

row

b)

column

c)

cell

d)

sheet

3.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
4.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
5.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
6.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
7.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
8.

Which is the correct formula to add cells A1 thru A5?

a)

=SUM(A1+A5)

b)

=SUM(A1:A5)

c)

=A1+A5

d)

=SUM(A1:A4)

9.

When you sort information, it can only be sorted by the first column of information.

a)

True

b)

False

10.

The function to find the smallest value in a group is

a)

max

b)

min

c)

sum

d)

average

11.
Which item is FALSE regarding charts in Google Sheets?
a)
You can create pie and line charts.
b)
Charts can't be inserted on their own sheet.
c)
You can change the chart title.
d)
You can put a background color on your chart.
12.
Text wrapping in Sheets means the text will be on more than 1 line within the same cell.
a)
True
b)
False
13.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
14.

You can adjust the size of columns in Sheets.

a)

True

b)

False

15.
Merging cells automatically centers the text within the merged cells.
a)
True
b)
False
16.

You are able to change the colors shown in a chart.

a)

True

b)

False

17.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
18.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
19.

You can only apply a border to the bottom of cells in Google Sheets

a)

True

b)

False

20.
The only colors you can change your sheet tabs to are red, blue, green, or yellow.
a)
True
b)
False
21.

Which Menu tab would you use to access the command to clear a cell's format?

a)

File

b)

Edit

c)

View

d)

Format

e)

Data

22.

Where would you click to select a column?

a)

A

b)

B

c)

C

d)

D

23.

Which letter on the image is a column?

a)

A

b)

B

c)

C

d)

D

24.

Which letter on the image is a Cell?

a)

A

b)

B

c)

C

d)

D

25.

What is the address of the indicated cell?

a)

B4

b)

4B

c)

C4

d)

B5

26.

Which keyboard shortcut would you press to cancel a command?

a)

Backspace

b)

Escape

c)

Tab

d)

Delete

27.

To select a very large group of cells, you can click on the first cell in the group, hold down the (a)   key, and then click on the last cell in the group.

28.

Which of the following statements is TRUE?

a)

The content and format of a cell are the same.

b)

The content and format of a cell are independent.

c)

Changing the format of a cell also affects its content.

29.

Which method is best for selecting the cells highlighted in red?

a)

Press the Shift key and click on the cells.

b)

Click and drag the mouse to select the cells.

c)

Press the Ctrl key and click on the cells.

d)

Press the Alt key and click on the cells.

30.

Which method is best for selecting the cells highlighted in red?

a)

Press the Ctrl key and click on the cells.

b)

Click and drag the mouse to select the cells

c)

Press the Shift key and click on the cells.

d)

Press the Alt key and click on the cells.

31.

Which sequence of keyboard shortcuts would you use to COPY information from one cell to another?

a)

Ctrl+X then Ctrl+Z

b)

Ctrl+C then Ctrl+V

c)

Ctrl+V then Ctrl+Z

d)

Ctrl+X then Ctrl+V

32.

What does the keyboard shortcut "Ctrl+Z" do?

a)

Paste

b)

Cut

c)

Copy

d)

Undo

33.

What symbol is used to designate an absolute cell reference?

a)

!

b)

%

c)

@

d)

$

34.

In a spreadsheet all formulas must begin with what symbol?

a)

#

b)

$

c)

!

d)

=

35.

What function should be entered into B7 to calculate the total budget?

a)

=SUM(B3:B6)

b)

=CALCULATE(B3:B6

c)

=SUM(B3-B6)

d)

=AVERAGE(B3:B6)

36.

Where is the formula bar?

a)

A

b)

B

c)

C

d)

D

37.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
38.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
39.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
40.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
41.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
42.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
43.
Which of the following is NOT a spreadsheet?
a)

Google Sheets

b)

Microsoft Excel

c)

Google Docs

44.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
45.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
46.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
47.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
48.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
49.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
50.
You can not give an exact size for a row height or column width.
a)
True
b)
False
51.
It is possible to insert images in Google Sheets
a)
True
b)
False
52.
What type of graph is shown in the image? 
a)
Bar Graph
b)
Line Graph
c)
Pie Graph
d)
Data Table
53.
Which of the following applications are for spreadsheets?
a)
Word and Docs
b)
PowerPoint and Slides
c)
Excel and Sheets
d)
Outlook and Gmail 
54.
When using spreadsheets, what does the term cell mean? 
a)
A blank field where data can be entered 
b)
A box used for organizing images
c)
A cage designed to hold bad information
d)
A small, basic unit of all living things
55.
True or False, spreadsheets can use data and formulas to make calculations. 
a)
True
b)
False
56.
What type of graph is shown in the image? 
a)

Bar Graph

b)

Line Graph

c)

Pie Graph

d)

Data Table

57.

How can you force a certain order of operations in a formula?

a)

By using simple formulas

b)

By positioning the operations from left to right

c)

They cannot be forced

d)

By using parentheses

58.

Defined the following operator: /

a)

Division

b)

Multiplication

c)

Subtraction

d)

Addition

59.

Using the correct order of operations, what does this formula equal? =16/4*2

a)

4 (four)

b)

8 (eight)

c)

2 (two)

d)

16 (sixteen)

60.

Using the correct order of operations, what does this formula equal? =(4-2)*16/2

a)

4 (four)

b)

8 (eight)

c)

2 (two)

d)

16 (sixteen)

61.

What is the keyboard shortcut to undo an action?

a)

Ctrl+Z

b)

Ctrl+C

c)

Ctrl+V

d)

Ctrl+X

62.

Which function would you use to find the highest value in a range of cells?

a)

average

b)

count

c)

max

d)

sum

63.

What does the little green triangle in the top left corner of a cell indicate?

a)

error

b)

comment

c)

formula

d)

warning

64.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
65.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
66.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
67.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
68.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
69.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
70.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
71.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
72.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
73.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
74.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
75.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
76.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
77.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
78.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
79.
You can not give an exact size for a row height or column width.
a)
True
b)
False
80.
It is possible to insert images in Google Sheets
a)
True
b)
False
81.

You can only apply a border to the bottom of cells in Google Sheets

a)

True

b)

False

82.
The only colors you can change your sheet tabs to are red, blue, green, or yellow.
a)
True
b)
False
83.

You are able to change the colors shown in a chart.

a)

True

b)

False

84.
Merging cells automatically centers the text within the merged cells.
a)
True
b)
False
85.

You can adjust the size of columns in Sheets.

a)

True

b)

False

86.
Which item is FALSE regarding charts in Google Sheets?
a)
You can create pie and line charts.
b)
Charts can't be inserted on their own sheet.
c)
You can change the chart title.
d)
You can put a background color on your chart.
87.

Which is the correct formula to add cells A1 thru A5?

a)

=SUM(A1+A5)

b)

=SUM(A1:A5)

c)

=A1+A5

d)

=SUM(A1:A4)

88.

When you sort information, it can only be sorted by the first column of information.

a)

True

b)

False

89.

Jamoree, Koedi, and Raydrick are part of a basketball team. They have collected data on the number of points each player scored in the season and want to find the middle value. Which Excel function should they use?

a)

SUM

b)

AVERAGE

c)

MEDIAN

d)

COUNT

90.

Dafne is finalizing a Google Sheets spreadsheet for her biology class project. She wants to enhance the readability of her data by adding lines around the cells. Which toolbar option should she select to add borders to the cells?

a)

Format

b)

Insert

c)

Borders

d)

View

91.
Which cursor allows you to drag and fill a series?
a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)
Arrow
92.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
93.
Which cursor would you use to auto fit content in a column?
a)
vertical line with arrows pointing left and right
b)
plus sign
c)
hand
d)
white arrow
94.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
95.

Which Menu tab would you use to access the command to clear a cell's format?

a)

File

b)

Edit

c)

View

d)

Format

e)

Data

96.

To select a very large group of cells, you can click on the first cell in the group, hold down the (a)   key, and then click on the last cell in the group.

97.

Which of the following statements is TRUE?

a)

The content and format of a cell are the same.

b)

The content and format of a cell are independent.

c)

Changing the format of a cell also affects its content.

98.

Which method is best for selecting the cells highlighted in red?

a)

Press the Shift key and click on the cells.

b)

Click and drag the mouse to select the cells.

c)

Press the Ctrl key and click on the cells.

d)

Press the Alt key and click on the cells.

99.

Which method is best for selecting the cells highlighted in red?

a)

Press the Ctrl key and click on the cells.

b)

Click and drag the mouse to select the cells

c)

Press the Shift key and click on the cells.

d)

Press the Alt key and click on the cells.

100.

What symbol is used to designate an absolute cell reference?

a)

!

b)

%

c)

@

d)

$

Similar Resources on Wayground

ICT revision

96 questions

ICT revision

quiz

Worksheet

•

5th - 11th Grade

PAS SEMGENAP 1819 KELAS 7

96 questions

PAS SEMGENAP 1819 KELAS 7

quiz

Worksheet

•

7th Grade

Year 9 EOT1 Nov 2022

100 questions

Year 9 EOT1 Nov 2022

quiz

Worksheet

•

7th - 9th Grade

CS - A year in Review

100 questions

CS - A year in Review

quiz

Worksheet

•

8th Grade

Semester 1 Exam Review pt1 Word Processing

104 questions

Semester 1 Exam Review pt1 Word Processing

quiz

Worksheet

•

6th - 8th Grade

PRINTiT REVIEW

101 questions

PRINTiT REVIEW

quiz

Worksheet

•

8th Grade

Animation & Game Design For Teens - Final Assessment Summer 2022

100 questions

Animation & Game Design For Teens - Final Assessment Summer 2022

quiz

Worksheet

•

7th - 10th Grade

Tin học, công nghệ, máy tính và an ninh mạng

105 questions

Tin học, công nghệ, máy tính và an ninh mạng

quiz

Worksheet

•

KG - University