Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

filtering

Question 4

What method is used to access subsets of information?

Accepted Answer

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

Question 5

The two basic principles for setting up effective spreadsheets are

Accepted Answer

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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) .

Accepted Answer

The answer of The Scenario Manager offers a ________ which...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

Descriptive information should be placed

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of The advanced filtering technique allows you to...

Question 15

The Scenario Manager window is accessed by the

Accepted Answer

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

Question 16

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

Accepted Answer

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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 19

Use the File menu to insert comments into a spreadsheet .

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of A named alternative to a spreadsheet that...

Exam 14: Advanced Spreadsheets for Planning

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

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

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

What method is used to access subsets of information?

The two basic principles for setting up effective spreadsheets are

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

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) .

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

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

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

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

Descriptive information should be placed

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

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

The Scenario Manager window is accessed by the

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

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

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

Use the File menu to insert comments into a spreadsheet .

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