Fluency with Information Technology, 6e (Snyder)
Chapter 13 The Basics of Spreadsheets: Fill in the Blank Computing
13.1 True/False Questions
1) Cell entries in spreadsheets can be formatted similarly to formatting in word processors.
2) Spreadsheets can only sort in ascending order.
3) A group of cells is called a range.
4) Column widths in a spreadsheet must be set manually.
5) All cells of a spreadsheet are always visible.
6) A formula in a cell always starts with an equal sign.
7) Data can be copied from one cell to another, but formulas cannot.
8) Functions and column letters in a spreadsheet are not case sensitive.
9) Spreadsheets can only display time as military time.
10) You cannot mix absolute and relative references in the same cell reference.
11) By default, a formula in a spreadsheet will automatically recalculate if the value contained in
any of the formula’s cell references change.
12) Hidden columns cannot be referenced in a formula.
13) Conditional formatting is used to format a range of cells; each cell is formatted depending on
the value in the cell.
14) A text file is the same thing as a tab-delimited file.
15) Tables from a Web page can be pasted into a spreadsheet.
16) The fill handle can be used to copy values but not formulas.
17) Because there are two dimensions in spreadsheets—columns and rows—there are actually
two ways a formula can be relative.
1) What is the most common application of a spreadsheet?
A) as a journal
B) to process text data
C) to process numerical data
D) as a drawing application
2) The basic unit of a spreadsheet is a:
A) box
B) cube
C) cell
D) grid
3) Spreadsheets:
A) can only be sorted by column A
B) can be sorted by any column provided the column is named
C) are sorted by rows then columns
D) can be sorted by any column
4) A range of cells can include:
A) cells from more than one row
B) cells from more than one column
C) the entire spreadsheet
D) all of the above
5) Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it:
A) is truncated
B) is abbreviated
C) is hyphenated
D) cannot be entered into a cell
6) The main purpose of a spreadsheet is to:
A) display numerical results
B) process numerical data
C) organize factual data
D) graphically present data
7) In Microsoft Excel, all of the contents of the spreadsheet’s cells, including the formulas, can
be displayed by using the keyboard shortcut:
A) Ctrl+Alt+Tab
B) Ctrl+F1
C) Ctrl+` Note: grave accent (`) is on the same key with tilde (~)
D) Ctrl+C
8) Which of the following is used for computing common summary applications in a
spreadsheet?
A) formulas
B) functions
C) tables
D) formatting
9) A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of
cells is called a(n):
A) date copy
B) auto-increment
C) conditional fill
D) series fill
10) An example of conditional formatting is:
A) applying a font color, e.g., green, to values over 500
B) applying currency format to cells that refer to money values
C) applying italics to one column and bold to another column
D) formatting a spreadsheet with alternate colors for each row
11) To select a range of cells:
A) double-click the first and last cells
B) drag the cursor across the cells
C) click Select on the Edit menu
D) click the Add icon
12) We can see spreadsheet results graphically by creating:
A) complex formulas
B) hidden columns
C) charts
D) absolute cell references
13) What is another word that describes “pulling” the formula into other cells?
A) dropping
B) creating
C) filling
D) duplicating
1) Spreadsheet columns are labeled with ________.
2) The rows of a spreadsheet are designated with ________.
3) The ________ at the beginning of a cell entry determines whether a spreadsheet cell contains
a formula or data.
4) Data from another application that one wants to import into a spreadsheet is called ________.
5) An absolute cell reference makes use of the ________ symbol in its formula.
6) The process of copying from one cell to many others by simply dragging is called ________.
7) In a spreadsheet, a(n) ________ is a naming scheme that allows the user to refer to a group of
cells by naming the first cell and the last cell and placing a colon (:) in between.
8) Cell references that do not change when copied from one cell to another are called ________
references.
9) The Min function is used to display the ________ item in a list.
10) A file with a .txt extension is an ASCII ________ file.
11) To change the way contents of a cell appears, you change its ________.
12) To help us create a list, spreadsheets give us an array of ________ that we fill in to set up our
list.