Chapter 13
An absolute cell reference makes use of the ____ symbol in its formula.
$
The ________ at the beginning of a cell entry determines whether a spreadsheet cell contains a formula or data.
=
___________ formatting controls the display of the contents in spreadsheet cells based on the values stored in the cell.
Conditional
In Microsoft Excel, all of the contents of the spreadsheet's cells, including the formulas, can be displayed by using the keyboard shortcut:
Ctrl+` Note: grave accent is on the key with tilde (~)
All cells of a spreadsheet are always visible.
False
Column widths in a spreadsheet must be set manually.
False
Data can be copied from one cell to another, but formulas cannot.
False
Spreadsheet columns can be hidden but rows cannot.
False
Spreadsheets can only sort in ascending order.
False
The fill handle can be used to copy values but not formulas.
False
You cannot mix absolute and relative references in the same cell reference.
False
A formula in a cell always starts with an equal sign.
True
A group of cells is called a range.
True
Cell entries in spreadsheets can be formatted similarly to formatting in word processors.
True
Filtering is a process (especially in spreadsheets) for selecting items based on one or more criteria.
True
Functions and column letters in a spreadsheet are not case sensitive.
True
In a spreadsheet, conditional formatting allows you to specify a format for cells that meet certain criteria.
True
Cell references that do not change when copied from one cell to another are called ________ references.
absolute
The IF function specifies a(n):
action on true outcome, condition, action on false outcome
An example of conditional formatting is:
applying a font color, e.g., green, to values over 500
Spreadsheets:
can be sorted by any column
The basic unit of a spreadsheet is a:
cell
To help us create a list, spreadsheets give us an array of _____ that we fill in to set up our list.
cells
What symbol is used to denote absolute cell references?
dollar sign ($)
To select a range of cells:
drag the cursor across the cells
The process of copying from one cell to many others by simply dragging is called _______.
filling
What is another word that describes "pulling" the formula into other cells?
filling
Which of the following is used for computing common summary applications in a spreadsheet?
functions
Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it:
is truncated
The Max function is used to display the _______ item in a list.
largest
Spreadsheet columns are labeled with _______.
letters
The rows of a spreadsheet are designated with _______.
numbers
A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n):
series fill
The Min function is used to display the ________ item in a list.
smallest
What is the most common application of a spreadsheet?
to process numerical data
