wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

4th Quarter Exam

Total questions: 45

Worksheet time: 29mins

Name
Class
Date
1.
In a Google Spreadsheet, the letters across the top represent __________.
a)
Rows
b)
Numbers
c)
Columns
d)
Functions
2.
In a Google Spreadsheet, the numbers down the left side represent __________.
a)
Rows
b)
 Columns
c)
Headers
d)
Functions
3.
In a Google Spreadsheet, you can widen an entire column anywhere in the sheet.
a)
True
b)
False
4.
In a Google Spreadsheet, you can format a column by clicking on the $ sign in the toolbar to format it as ___________.
a)
Numbers
b)
Automatic
c)
Decimals
d)
Currency (money)
5.
In a Google Spreadsheet, where a column and row intersect is called a ________.
a)
Rectangle
b)
Square
c)
Cell
d)
Intersection
6.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
7.
In a Google Spreadsheet, you must use ONLY the Function icon on the Toolbar to do ALL mathematical equations.
a)
True
b)
False
8.
It is essential for a business owner to track their expenses and income by using a spreadsheet application like Google Sheets.
a)
True
b)
False
9.
In a Google Spreadsheet, the first thing you should type in a cell where you want to insert a formula/function to get an answer is a(n) ____________.
a)
Plus sign
b)
Minus sign
c)
Equal sign
d)
Multiplication sign
10.
In a Google Spreadsheet, you can manually type the function/formula in a cell if the operation is not available in the function drop-down list.
a)
True
b)
False
11.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

you cannot know the name from this picture

12.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
13.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
14.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
15.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
16.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
17.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
18.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
19.
In a Google Spreadsheet, the numbers down the left side represent __________.
a)
Rows
b)
 Columns
c)
Headers
d)
Functions
20.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
21.
In a Google Spreadsheet, the first thing you should type in a cell where you want to insert a formula/function to get an answer is a(n) ____________.
a)
Plus sign
b)
Minus sign
c)
Equal sign
d)
Multiplication sign
22.

Google Sheets is used to? (Select ALL that apply?)

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

23.

A Sheets document is called a?

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide

24.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
25.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
26.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
27.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
28.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

29.

What number is in B1?

a)
1
b)
2
c)
blank
d)
4
30.

What does your mouse pointer change to in order to use the drag and drop feature?

a)

Mouse

b)

Hand

c)

Plus Sign

d)

Arrow

31.

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

32.

The cell ready to enter text or numbers with the blue box around it is call the....

a)

Active Cell

b)

Active Box

c)

Ready Cell

d)

Cell Box

33.

Any new spreadsheet is named Untitled. Click this to rename it.

a)

Name Box

b)

File Box

c)

Name Spot

d)

Spreadsheet Title

34.

Multiple adjacent cells selected at the same time is called a...

a)

Cell Cluster

b)

Cluster Cells

c)

Cell Range

d)

Cell group

35.

The boxes at the top of each column with a letter inside is called the...

a)

Column Heading

b)

Column Label

c)

Column Box

d)

Label Box

36.

What does this button do?

a)

Merge the cells

b)

Border the cells

c)

Change the alignment in the cells

d)

Change the color in the cells

37.
Name this Google icon?
a)
Drive
b)
Doc
c)
Sheets
d)
Word
38.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
39.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
40.

What number is in E1?

a)
1
b)
2
c)
blank
d)
4
41.

In a Google Spreadsheet, which function would you use to find the average of a range of numbers?

a)

MAX

b)

SUM

c)

COUNT

d)

AVERAGE

42.

What is the shortcut key to open a new Google Spreadsheet?

a)

Ctrl + S

b)

Ctrl + N

c)

Ctrl + P

d)

Ctrl + O

43.

In a Google Spreadsheet, what does the 'Filter' option do?

a)

Displays only selected data

b)

Formats data

c)

Hides data

d)

Sorts data

44.

In a Google Spreadsheet, which function would you use to find the average of a range of numbers?

a)

AVERAGE

b)

SUM

c)

MAX

d)

COUNT

45.

In Google Sheets, how can you quickly fill a series of numbers in a column?

a)

Drag the fill handle

b)

Copy and paste

c)

Use the SUM function

d)

Type each number manually

Similar Resources on Wayground

CSS11_4TH_QTR_EXAM

50 questions

CSS11_4TH_QTR_EXAM

quiz

Worksheet

•

11th Grade

Révisions TLM3A - CPMB - Colombier

42 questions

Révisions TLM3A - CPMB - Colombier

quiz

Worksheet

•

10th Grade - Professi...

MS office 2016

40 questions

MS office 2016

quiz

Worksheet

•

1st Grade - Professio...

Av1 - Informática Básica - IFAL Coruripe

50 questions

Av1 - Informática Básica - IFAL Coruripe

quiz

Worksheet

•

10th - 12th Grade

ICT in society

50 questions

ICT in society

quiz

Worksheet

•

5th Grade - University

Software Design Models: Waterfall and Iterative

44 questions

Software Design Models: Waterfall and Iterative

quiz

Worksheet

•

8th Grade - University

B11-13 L11

50 questions

B11-13 L11

quiz

Worksheet

•

11th Grade

L3 Digital Technology (entry test)

45 questions

L3 Digital Technology (entry test)

quiz

Worksheet

•

11th - 12th Grade