Fluency with Information Technology, 6e (Snyder)
Chapter 14 Advanced Spreadsheets for Planning: “What If” Thinking Helps
14.1 True/False Questions
1) Flexibility is an important characteristic of a spreadsheet.
2) Summary information should be placed at the top of a spreadsheet.
3) Fonts should be clear in a spreadsheet, and possibly differentiated for headings and data.
4) Use the File menu to insert comments in Excel.
5) In a spreadsheet, conditional formatting allows you to specify a format for cells that meet
certain criteria.
6) Excel provides automatic currency conversion with no need to write special formulas.
7) In a spreadsheet, names can only be applied to cell references, not individual cells.
8) “What if” analysis is a spreadsheet tool that temporarily recomputes entries based on
alternative cell values.
9) Filtering is a process (especially in spreadsheets) for selecting items based on one or more
criteria.
1) The first guideline of setting up effective spreadsheets is to:
A) make them visually interesting
B) focus on form
C) avoid explanations that clutter the spreadsheet
D) explain all processes
2) Place descriptive information:
A) on the top and left
B) on the top and right
C) on the bottom and left
D) on the bottom and right
3) The Advanced Filter feature includes a:
A) List range
B) Criteria range
C) Copy to option
D) All of the above
4) What symbol is used to denote absolute cell references?
A) equal sign (=)
B) dollar sign ($)
C) percent sign (%)
D) tilde (~)
5) The IF function specifies a(n):
A) action on true outcome
B) condition
C) action on false outcome
D) all of the above
6) To reduce the chance of messing up range specifications, and minimize the likelihood that
errors will creep in when columns and rows are added later:
A) manually inspect all formulas on the spreadsheet
B) do not hide columns in the spreadsheet
C) always use absolute cell references in all formulas
D) apply names in the spreadsheet
7) The function that returns the specified number of characters from the start of a text string is:
A) LETTER()
B) INDEX()
C) LEFT()
D) IF()
8) A word or a phrase assigned to a cell or range of cells is called its:
A) value
B) name
C) literal
D) range id
9) The Scenario Manager window is accessed via the:
A) Tools menu
B) File menu
C) Edit menu
D) Formulas menu
10) What method is used to access subsets of information?
A) logging
B) conditional formatting
C) sorting
D) filtering
1) ________ formatting controls the display of the contents in spreadsheet cells based on the
values stored in the cell.
2) ________ formulas can make the entire computation of a cell contingent on the outcome of a
condition.
3) A(n) ________ is a named alternative to a spreadsheet based on different inputs.
4) Use ________ to select only certain rows from a list.
5) The Advanced Filtering facility allows multiple ________.