wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Test

Total questions: 33

Worksheet time: 17mins

Name
Class
Date
1.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
You cannot know the name from this picture
2.
A file that can contain one or more worksheets
a)
Workbook
b)
Worksheet
c)
File
3.
What defines a cell in a spreadsheet?
a)
A standalone box that is not related to rows or columns
b)
The intersection of a column and a row
c)
The space between two rows
d)
The space between two columns
4.
An expression, typically starting with an equals sign (=), that performs calculations or manipulates data within a cell, using cell references, operators, and potentially functions
a)
Formula
b)
Function
5.
All formulas in Google Sheets begin with the following symbol?
a)
+
b)
=
c)
-
d)
%
6.
Columns are labeled by ________.
a)
numbers
b)
letters
c)
symbols
d)
colors
7.
Rows are labeled by ___________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
A __________________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
9.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
10.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
11.
Select ______________ from the functions drop-down menu to add a set of numbers together.
a)
sum
b)
subtract
c)
chart
12.
What is the name of this button?
a)
Function button
b)
the backwards 3 button
13.
If you want to make a cell a particular color, which button would you click on?
a)
Format tab
b)
Font style
c)
Text color
d)
Fill color
14.
What is it called when you hold your mouse button down to select a group of cells?
a)
Fill down
b)
Fill right
c)
Drag
d)
Row
15.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
16.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
17.
If you want to make a cell a particular color, which button would you click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
18.
The small box in the bottom right corner of a cell is called?
a)
Fill Handle
b)
Fill Box
c)
Box Option
d)
Box Fill
19.
These are tabs located at the bottom of the screen to click on different worksheets inside the workbook.
a)
Sheet tabs
b)
Sheet files
c)
Tab Files
d)
Tab Sheets
20.
An equation that calculates a new value from values currently in a worksheet.
a)
Formula
b)
Equation
c)
Sum
d)
Addition
21.
What is this?
a)
equation
b)
sheet
c)
formula bar
d)
formula
22.
What formula would be used in cell B14 to add up the total number of miles the person biked in a month?
a)
=(B2+B10)
b)
=(B2*B10)
c)
=SUM(B2:B10)
d)
=SUM(B2+B10)
23.
In Google Sheets, a FUNCTION is
a)
a group of cells that run vertically
b)
a predefined formula that performs calculations using specific values in a particular order
c)
the place to enter and edit data, functions, and formulas for a specific cell
d)
a group of cells that run horizontally
24.
A visual representation of data, often used to display trends, comparisons, and patterns that might be difficult to discern from raw numbers alone
a)
Chart
b)
Graph
25.

What is the term for a horizontal section of a spreadsheet?

a)

row

b)

cell

c)

sheet

d)

column

26.

In a spreadsheet, what is the name of the feature that allows you to automatically fill cells with a series of data?

a)

Data Fill

b)

Fill Series

c)

AutoComplete

d)

AutoFill

27.

Which of these is the correct way to refer to cell A1?

a)

1A

b)

(A,1)

c)

A1

d)

1:A

28.

Which term refers to the currently selected cell that appears with a bold border?

a)

Draft cell

b)

Active cell

c)

Fill cell

d)

Range cell

29.

What is a continuous selection of cells in Google Sheets called?

a)

Chart selection

b)

Sheet selection

c)

Range

d)

Function group

30.

What do you call the text at the bottom of the spreadsheet that helps you navigate between different sheets?

a)

Navigation bar

b)

Sheet tabs

c)

Function bar

d)

Formula bar

31.

What is the term for a cell that contains text describing data?

a)

Value

b)

Formula

c)

Label

d)

Reference

32.

What is the bar at the top of the spreadsheet where you can edit formulas?

a)

Navigation bar

b)

Menu bar

c)

Formula bar

d)

Status bar

33.

What feature allows you to automatically fill a series of numbers or dates?

a)

Auto series

b)

Fill series

c)

Auto fill

d)

Series generator

Similar Resources on Wayground

Taller ciberseguridad

28 questions

Taller ciberseguridad

quiz

Worksheet

•

7th Grade

FOWAG

30 questions

FOWAG

quiz

Worksheet

•

1st - 12th Grade

UD3 : ELECTRICIDAD ELECTRÓNICA REPASO

28 questions

UD3 : ELECTRICIDAD ELECTRÓNICA REPASO

quiz

Worksheet

•

6th - 8th Grade

Repaso para séptimo

32 questions

Repaso para séptimo

quiz

Worksheet

•

7th Grade

Công nghệ 5

28 questions

Công nghệ 5

quiz

Worksheet

•

5th Grade - University

Câu hỏi ôn tập trắc nghiệm môn Công nghệ 5 HKI

29 questions

Câu hỏi ôn tập trắc nghiệm môn Công nghệ 5 HKI

quiz

Worksheet

•

5th Grade - University

Engineering Design Process

33 questions

Engineering Design Process

quiz

Worksheet

•

6th - 8th Grade

Computer Class ACS

30 questions

Computer Class ACS

quiz

Worksheet

•

4th - 8th Grade