NEW
Font size
S
M
L
XL
WorksheetsExcel Chapter 1 Basic Terminology
Total questions: 27
Worksheet time: 14mins
Name
Class
Date
1.
the intersection of a column and row on a worksheet
a)
data
b)
cell
c)
value
d)
address
2.
the location of a cell in a worksheet as identified by its column letter and row number
a)
cell reference
b)
active cell
c)
series
d)
default value
3.
another term for cell reference
a)
cell value
b)
cell location
c)
cell address
d)
cell block
4.
a document that contains formatting, styles, and sample text to help you create new documents
a)
example
b)
reference sheet
c)
style guide
d)
template
5.
the work area for entering and calculating data; contains columns and rows divided by gridlines
a)
workbook
b)
gridline page
c)
worksheet
d)
Excel page
6.
the cell that contains the cell pointer; has a green border around it
a)
primary cell
b)
current cell
c)
dominant cell
d)
active cell
7.
the feature that enables Excel to create a series automatically
a)
Auto Series
b)
Auto Fill
c)
Auto Formula
d)
Auto Format
8.
to see how a worksheet will look when printed
a)
overview
b)
pre-print
c)
preview
9.
additional location where entered data is displayed
a)
cell reference
b)
name box
c)
cell address
d)
formula bar
10.
a new workbook that contains three worksheets with no data
a)
blank workbook
b)
clean workbook
c)
empty workbook
d)
fresh workbook
11.
a cell address that will not change when you copy the formula to another location
a)
relative reference
b)
absolute reference
12.
a cell address that can change in a copied formula; new address is in relation to location of cell
a)
absolute reference
b)
relative reference
13.
row and column labels that reprint on each page of a printout
a)
print titles
b)
print labels
c)
print references
d)
print headers
14.
a Windows feature that holds data or graphics that you cut or copy prior to pasting
a)
storage space
b)
clipboard
c)
file cabinet
d)
home ribbon
15.
the command used to place a copy of the data from the selected cell or range on the clipboard
a)
copy
b)
cut
c)
move
16.
when you remove data from one location to paste into another you need to _________ the data
a)
copy
b)
cut
c)
move
17.
the command used to place data from the clipboard to a new location on the worksheet
a)
copy
b)
cut
c)
paste
d)
move
18.
an instruction Excel uses to calculate a result; must being a = sign
a)
formula
b)
function
c)
calculator
19.
a built-in calculation used to add a range of values together
a)
formula
b)
SUM function
c)
calculator
20.
a block of cells in an Excel worksheet
a)
group
b)
cell block
c)
range
d)
series
21.
a block of adjacent cells in a worksheeet
a)
contiguous range
b)
non-contiguous range
22.
cells in a worksheet that act as a block, but are not necessarily adjacent to each other
a)
non-contiguous range
b)
contiguous range
23.
a cell entry that consists of a number and numeric formatting only
a)
text data
b)
value
c)
date code
d)
series
24.
a cell entry that indicates a date or time and is stored as a date code in Excel
a)
timestamp
b)
date
c)
calendar data
25.
a small box on the lower-right corner of the selected cell or range you use to fill (copy) data
a)
series handle
b)
auto fill option
c)
fill handle
26.
the default number of characters that display in a column based on the default font
a)
default size
b)
default column width
c)
default cell area
27.
a list of sequential numbers, dates, times or text
a)
series
b)
data range
c)
filled values
Reset
