Deck 14: Advanced Spreadsheets for Planning

Question 1

Flexibility is an important characteristic of a spreadsheet .

Answer 1

True

Question 2

Summary information should be placed at the top of a spreadsheet .

Answer 2

False

Question 3

Fonts should be clear in a spreadsheet and possibly differentiated for headings and data .

Answer 3

True

Question 4

Use the File menu to insert comments into a spreadsheet .

Question 5

In a spreadsheet conditional formatting allows you to specify a particular format for cells that meet certain criteria .

Question 6

In a spreadsheet names can only be applied to cell references, not individual cells .

Question 7

A "what if"analysis is a spreadsheet tool that temporarily recomputes entries based on alternative cell values .

Question 8

Filtering is a process whereby certain items are selected based on one or more criteria .

Question 9

If you use multiple criteria in a filter, all criteria must always be present for a cell to meet the specifications .

Question 10

Computer scientists say it is better to refer to cells by their explicit column/row position than by a symbolic name .

Question 11

The first thing to focus on when setting up an effective spreadsheet is

A) how visually interesting it is
B) an explanation of each process
C) the scenarios
D) form

Question 12

Descriptive information should be placed

A) on the top and right
B) on the bottom and right
C) on the top and left
D) on the bottom and left

Question 13

The two basic principles for setting up effective spreadsheets are

A) Explain Everything and Use Filtering
B) Focus on Form and Explain Everything
C) Create Scenarios and Name All Cell Ranges
D) Focus on Form and Name All Cell Ranges

Question 14

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) always use absolute cell references in all formulas
B) never hide columns in the spreadsheet
C) apply names in the spreadsheet
D) manually inspect all formulas in the spreadsheet

Question 15

A word or phrase assigned to a cell or range of cells is its

A) name
B) symbol ID
C) value
D) literal

Question 16

The Scenario Manager window is accessed by the

A) Edit menu
B) Tools menu
C) File menu
D) Formulas menu

Question 17

What method is used to access subsets of information?

A) sorting
B) conditional formatting
C) logging
D) filtering

Question 18

The function that returns the specified number of characters from the start of a text string is

A) INDEX()
B) IF()
C) LETTER()
D) LEFT()

Question 19

A named alternative to a spreadsheet using different inputs is a

A) conditional format
B) conditional formula
C) scenario
D) None of these

Question 20

When using Advanced Filtering on a column that contains, for example, the cost of lodgings at various places and you select the criteria shown, what will your results be?Cost is greater than 500 Or is less than 100

A) The results will contain only the cells with values over 500 and the cells with values under 100 .
B) No entries will be in the results because a value cannot be both greater than 500 and less than 100 at the same time .
C) All entries will be in the results because every cell meets at least one of the criteria .
D) Nothing will happen; this is an unacceptable filter .

Question 21

When using Advanced Filtering on a column that contains, for example, the cost of lodgings at various places and you select the criteria shown, what will your results be?Cost is greater than 500 And is less than 100

A) No entries will be in the results because a value cannot be both greater than 500 and less than 100 at the same time .
B) The results will contain all the cells with values over 500 and the cells with values under 100 .
C) All entries will be in the results because every cell meets at least one of the criteria .
D) Nothing will happen; this is an unacceptable filter .

Question 22

Select all that apply . The Advanced Filter feature includes a

A) list range
B) criteria range
C) create chart option
D) copy option

Question 23

Select all that apply . The IF function specifies

A) the condition
B) the action to take when condition is false
C) the action to take when condition is true
D) the action to take when condition cannot be determined

Question 24

To control how contents display in spreadsheet cells based on the values stored in the cells, you can use ________ formatting .

Question 25

To make the entire computation of a cell contingent on the outcome of a condition, you can use ________ formulas .

Question 26

A named alternative to a spreadsheet that is based on varying the inputs is a(n) ________ .

Question 27

To select only certain rows from a list, you use ________ .

Question 28

The advanced filtering technique allows you to filter using multiple ________ .

Question 29

The advanced filtering technique that allows you to select two criteria where both must be present, you choose the ________ option .

Question 30

The advanced filtering technique that allows you to select two criteria where either one or both can be present, you choose the ________ option .

Question 31

In a spreadsheet, a ________ is a word or phrase assigned to a cell or range of cells .

Question 32

The Scenario Manager offers a ________ which will show, assuming the scenario came to pass, the value that represents, in effect, the bottom line (that is, the value you are most interested in) .

Question 33

Filtering applies only to spreadsheets that have column ________ .