Deck 5: Excel: What-If Analysis, Charting, and Working With Large Worksheets

Question 1

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

A)Copy Cells
B)Fill Formatting Only
C)Fill Without Formatting
D)none of the above

Answer 1

B

Question 2

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

A)45
B)90
C)0
D)125

Answer 2

C

Question 3

The fill handle allows creation of a series of all of the following EXCEPT ____.

A)month names
B)dates
C)numbers
D)historical sales figures

Answer 3

D

Question 4

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

A)logical
B)constant
C)consistent
D)calculated

Question 5

Which of the following deletes selected cells, but does not shift any other cells to compensate?

A)the DELETE command
B)the Delete Cells command
C)the DELETE button on the Home tab
D)Either A or C

Question 6

With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____.

A)use Excel to create the worksheet
B)design the 3-D Pie chart
C)perform calculations
D)create the 3-D Pie chart

Question 7

Which of the following is an extension of the fill pattern Sunday, Tuesday?

A)Wednesday, Thursday, Saturday
B)Thursday, Saturday, Monday
C)Saturday, Sunday, Monday
D)Monday, Wednesday, Friday

Question 8

You can ensure correctness in your formulas by carefully checking them using ____.

A)Range Finder
B)the ribbon
C)the requirements document
D)the Standard toolbar

Question 9

The Copy button copies the contents and format of the source area to the ____, a reserved place in the computer's memory.

A)ribbon
B)clipboard
C)folder
D)file

Question 10

In the accompanying figure, the split double arrow mouse pointer ____.

A)indicates a hidden column
B)allows text to be entered at that location
C)is the result of moving the mouse pointer to the boundary between column heading A and column heading B
D)indicates the proposed width of column A

Question 11

You should ____ cells to duplicate entries.

A)copy
B)command
C)move
D)either A or C

Question 12

Which of the following is the path to the Increase or Decrease Indent button?

A)(Home tab | Clipboard group)
B)(Home tab | Editing group)
C)(Home tab | Alignment group)
D)(Home tab | Number group)

Question 13

Which of the following is a suggested decision to make when you plan a workbook?

A)determine how to manipulate the worksheets
B)determine the necessary functions and formulas needed
C)determine what to add to the requirements document
D)determine whether to use the Format Painter button

Question 14

If you accidentally delete valuable data, immediately click the ____ button in the Standard toolbar.

A)Restore
B)Reset
C)Redo
D)Undo

Question 15

____ text often provides a strong visual appeal.

A)Underlined
B)Tiny
C)Large
D)Rotated

Question 16

Cell references in a formula are called ____.

A)assumptions
B)values
C)numbers
D)content

Question 17

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

A)Quarter 1
B)Qtr1
C)Qtr2
D)Quarter4

Question 18

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

A)three
B)four
C)two
D)five

Question 19

Using the mouse to move or copy cells is called ____.

A)drop and drag
B)drag and drop
C)drag and copy
D)drag and paste

Question 20

Which of the following patterns extends the fill series to 575, 550, 525?

A)650, 600
B)625, 600
C)560, 580
D)500, 475

Question 21

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

A)#NULL!
B)#DIV/0!
C)#N/A
D)#REF!

Question 22

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

A)Click
B)Press
C)Double-click
D)Triple-click

Question 23

Press ____ to select cell A1.

A)CONTROL-FN-LEFT ARROW
B)OPTION-F1
C)CONTROL-F2
D)COMMAND-FN

Question 24

The Format Painter button appears in the ____.

A)Home tab
B)Standard toolbar
C)Options tab
D)Format tab

Question 25

The range for the reduction or enlargement of the display of a worksheet is from ____.

A)20% to 120%
B)50% to 250%
C)25% to 200%
D)50% to 500%

Question 26

A ____ is a separate sheet in a workbook that contains only a chart.

A)worksheet
B)dialog box
C)chart sheet
D)range

Question 27

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

A)Sparkie
B)Sparkline
C)Special
D)Sparkle

Question 28

Which of the following is not a valid format symbol?

A)semi-colon (;)
B)percent sign (%)
C)dollar sign ($)
D)comma (,)

Question 29

When working with a large worksheet, you can split the window into ____ panes.

A)three or four
B)four or five
C)two or six
D)two or four

Question 30

Error messages begin with the ____ symbol.

A)?
B)=
C)!
D)#

Question 31

A Pie chart with one of more slices offset is called a(n)____.

A)maximized Pie chart
B)exploded Pie chart
C)imploded Pie chart
D)moving Pie chart

Question 32

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

A)Goal
B)Formula
C)Option
D)Function

Question 33

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

A)included
B)other
C)nested
D)duplicate

Question 34

Which of the following is the path to the Zoom button?

A)(View tab | Zoom group)
B)(Home tab | Zoom group)
C)(Insert tab | Zoom group)
D)(Zoom tab | View group)

Question 35

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

A)SYSDATE
B)NOW
C)DATETIME
D)CURRENT

Question 36

Which of the following formulas contains an absolute cell reference?

A)=$B4
B)=B$4
C)=$B$4
D)=B4

Question 37

You should use a ____ chart to show the relationship or proportion of parts to a whole.

A)column
B)bar
C)line
D)pie

Question 38

The ____ function is useful when you want to assign a value to a cell based on a logical test.

A)IF
B)NOW
C)AND
D)OR

Question 39

Which comparison operator means "not equal to"?

A)<=
B)>
C)<
D)

Question 40

____ refers to cells not wide enough to display the entire entry.

A)#####
B)&&&&&
C) $$$$ $
D)+++++

Question 41

The less than or equal to .

Question 42

Modified Multiple Choice Which of the following is a valid rotation (counterclockwise)value for text in a cell in the Alignment sheet in the Format Cells dialog?

A)0
B)1
C)90
D)60

Question 43

Studies have shown that more than 25 percent of all business worksheets have errors.

Question 44

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Question 45

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Question 46

A date stamp shows the date a workbook, report, or other document was created or the period it represents.

Question 47

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

Question 48

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Question 49

Modified Multiple Choice Which of the following are formatting symbols?

A)dollar sign ($)
B)comma (,)
C)pound sign (#)
D)percent sign (%)

Question 50

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Question 51

In the accompanying figure, worksheet titles are frozen above and to the left of cell B13.

Question 52

The error message #NULL! specifies an invalid intersection of two areas.

Question 53

Modified Multiple Choice Following the insertion of a row, the Insert Options button lets you select from which of the following options?

A)Format Same As Above
B)Undo Formatting
C)Format Same As Below
D)Clear Formatting

Question 54

Modified Multiple Choice If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

A)Wednesday
B)Thursday
C)Saturday
D)Monday

Question 55

Modified Multiple Choice The arguments in an IF function are ____.

A)logical_test
B)value_if_true
C)value_if_true_false
D)value_if_false

Question 56

Rotated text also allows you to fit more text into a smaller column width.

Question 57

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).

Question 58

The error message #VALUE! indicates the use of an incorrect argument or operand.

Question 59

The NETWORKDAYS function checks a formula for correctness.

Question 60

In the accompanying figure, the formula in cell B14 contains an absolute reference.

Question 61

Error messages in Excel always begin with a(n)& character.

Question 62

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

Question 63

You can ensure correctness in your ____________________ by carefully checking them using Range Finder.

Question 64

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

Question 65

The range of entries that determines the size of the slices in a Pie chart is called the category names.

Question 66

____________________ are values in cells that can be changed to determine new values for formulas.

Question 67

You can press the CONTROL-ACCENT MARK(`)to display the formulas in a worksheet.

Question 68

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

Question 69

The use of multiple ____________________ charts in the worksheet will provide the user with a visual comparison of the various data items.

Question 70

Exploding worksheet titles is a useful technique for viewing large worksheets that extend beyond the window.

Question 71

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

Question 72

If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

Question 73

A(n)____________________ is a good way to compare visually a small set of numbers.

Question 74

The underline format underlines only the characters in the cell, rather than the entire cell, as is the case when you assign a cell a bottom border.

Question 75

You can select nonadjacent ranges using the SHIFT key.

Question 76

With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.

Question 77

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

Question 78

____________________ charts allow worksheet users quickly to visualize information in a small chart within a cell.

Question 79

The error message #NULL! indicates the use of a name that Excel does not recognize.

Question 80

Panes created using the vertical split bar scroll together horizontally .