WorksheetsGoogle Sheets Lesson 1 & 2 Vocabulary Review
Total questions: 27
Worksheet time: 9mins
Name
Class
Date
1.
What part of the spreadsheet appears vertically and is identified by letters?
a)
Columns
b)
Rows
c)
Cells
d)
Ranges
2.
What part of the spreadsheet appears horizontally and is identified by numbers?
a)
Columns
b)
Rows
c)
Cells
d)
Ranges
3.
Name the red circled part of the worksheet in the image below.
a)
Formula Bar
b)
Active Cell
c)
Name Box
d)
Cell Reference
4.
Name the red circled part of the worksheet in the image below.
a)
Row Numbers
b)
Column Numbers
c)
Row Letters
d)
Column Letters
5.
Name the red circled part of the worksheet in the image below.
a)
Row Numbers
b)
Column Numbers
c)
Row Letters
d)
Column Letters
6.
Name the red circled part of the worksheet in the image below.
a)
Formula Bar
b)
Active Cell
c)
Name Box
d)
Cell Reference
7.
What is the active cell in the image below?
a)
C4
b)
A2
c)
D5
d)
A1
8.
The cell in which you can type data is called the
a)
Reference Cell
b)
Active Cell
c)
Row
d)
Range
9.
A grid of rows and columns in which you enter text, numbers, and the results of calculations is called a(n)...
a)
Spreadsheet
b)
Cell
c)
Range
d)
Workbook
10.
A computerized Spreadsheet is called a...
a)
Worksheet
b)
Cell
c)
Work area
d)
Grid
11.
A collection of worksheets is called a
a)
Workbook
b)
Worksheet
c)
Formula Sheet
d)
Spreadsheet
12.
What is a unique name that identifies each cell?
a)
Cell Identifier
b)
Cell Number
c)
Cell Range
d)
Cell Reference
13.
What displays the contents of the active cell?
a)
Formula Bar
b)
Adjacent Range
c)
Name Box
d)
Nonadjacent Range
14.
A group of selected cells is called
a)
Cell Reference
b)
Range
c)
Formula
d)
Active Cell
15.
The Intersection of a row and a column is called a
a)
Range
b)
Formula
c)
Cell
d)
Adjacent Range
16.
Which of the following is an example of a cell reference?
a)
B5
b)
B
c)
5
d)
All of these are examples of a cell reference
17.
Which of the following is an example of a range reference (range name)?
a)
C2:D6
b)
C:F
c)
C2 - D6
d)
D26
18.
Which cell number formats (more than one) display numerical data with a dollar sign ($)?
(Select BOTH correct answers! There are 2!!!)
a)
Accounting
b)
Currency
c)
General
d)
Number
e)
Text
19.
TRUE or FALSE? AutoFit determines the best width for a column or the best height for a row based on its contents.
a)
True
b)
False
20.
TRUE or False? You can apply a border around the entire cell or on any side of the cell.
a)
True
b)
False
21.
Which of the following can be adjusted if text is too long to fit within a cell to make the text fit?
a)
All of these can help make the text fit
b)
Change the column width with Autofit
c)
Apply Text Wrap
d)
Rotate the Text
e)
Merge Cells
22.
TRUE or FALSE? Changing the fill color of a cell changes the color of the text/font.
a)
True
b)
False
23.
FILL IN THE BLANK: Text that does not fit in a cell is __________, or hidden from view.
a)
Truncated
b)
Merged
c)
Wrapped
d)
Indented
24.
FILL IN THE BLANK: Bold, italic, and underlining are examples of font _____.
a)
Styles
b)
Alignments
c)
Sizes
d)
Orientations
25.
FILL IN THE BLANK: The default _____ (or background) color of cells is white.
a)
Fill
b)
Alignment
c)
Orientation
d)
Font/Text
26.
FILL IN THE BLANK: The _____ copies all the formatting from one cell and pastes it to another cell or range without copying the contents of the cell.
a)
Format Painter
b)
Autofit
c)
Text Wrapping
d)
Row Heading
27.
TRUE or FALSE? You can merge multiple cells into a single cell in a spreadsheet.
a)
True
b)
False
100 %
