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

Question 1

Figure 3-4 In the accompanying figure, you know that the Pie chart was rotated because Excel initially positions the chart so that one of the dividing lines between two slices is a straight line pointing to 6:00 o clock.

Answer 1

False

Question 2

Figure 3-3 In the accompanying figure, the only cells that you should change when performing what-if analysis are those in the what-if portion of the worksheet.

Answer 2

True

Question 3

Figure 3-4 In the accompanying figure, the month of June is emphasized by a technique called imploding.

Answer 3

False

Question 4

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the source area.

Question 5

Figure 3-1 In the accompanying figure, drag the Text hand in the Orientation area to the 45 point and to display 45 in the Degrees box.

Question 6

Figure 3-2 A split double arrow mouse pointer, as shown in the accompanying figure, can be used to widen a column.

Question 7

Methods for moving cells are drag and drop and cut and paste.

Question 8

Figure 3-3 In the accompanying figure, to achieve the format for the dollar values, the Currency category was selected in the Format Cells dialog box.

Question 9

If the contents of cells copied using the fill handle are 430 and 410, then the next three values of an extended series are: 400, 390, 370.

Question 10

Figure 3-3 In the accompanying figure, the months were rotated by selecting the text and dragging the mouse pointer up and to the right.

Question 11

With some fill operations, you may not want to copy the formats of the source cell or range to the destination cell or range. If this is the case, click the Auto Fill Options button after the range fills and then select the option you desire on the Auto Fill Options menu.

Question 12

Figure 3-3 In the accompanying figure, the worksheet in the Window is split at the orange double lines.

Question 13

Figure 3-2 In the accompanying figure, the width of column A changes if you double-click the split double arrow mouse pointer

Question 14

Figure 3-3 In the accompanying figure, the values that have dollar signs in column H are Currency style with fixed dollar signs.

Question 15

The Decrease Indent button decreases the indent by five spaces each time you click it.

Question 16

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

Question 17

If you accidentally delete valuable data, immediately click the Undo button on the Quick Access Toolbar.

Question 18

Figure 3-1 In the accompanying figure, if you prefer, you can type the number of degrees in the Orientation box instead of dragging the Text hand.

Question 19

An alternative to increasing the column widths or row heights is to enlarge the characters in the cell to fit the current width of the column.

Question 20

The what-if assumptions should not clutter the worksheet, but they should be placed in an easily located portion of the worksheet.

Question 21

With a good 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 22

Excel displays #REF! in a cell to indicate the cell is a cross reference.

Question 23

You can replace a formula with its function so it remains constant.

Question 24

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 25

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

Question 26

Hiding the ____ will allow a larger portion of the worksheet to be visible.

A)Ribbon
B)Quick Access Toolbar
C)worksheet's tab
D)additional worksheets

Question 27

In addition to creating a series of values, dragging the fill handle instructs Excel to ____ the format of a cell to a range.

A)copy
B)move
C)delete
D)cut

Question 28

The NOW function is a date and time function.

Question 29

With large worksheets that extend beyond the size of a window, it is best to enter titles in the ____.

A)upper-right corner
B)left-center row
C)upper-center
D)upper-left corner

Question 30

When a number is entered with a format symbol, Excel immediately displays it with the assigned format.

Question 31

If a window is split into four panes, you can drag the center of the four panes in any direction to change the size of the panes.

Question 32

When a window is split into panes, scroll bars are available for top and bottom, and left and right panes.

Question 33

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 34

Splitting the Excel window into two panes allows you to view all four corners of the worksheet easily.

Question 35

Click Microsoft Office in the ____ list to display the Microsoft Office list.

A)All Applications
B)Excel
C)Start
D)All Programs

Question 36

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

Question 37

Figure 3-1 In the accompanying figure, if you enter 90 in the Degrees box in the Orientation area, the text will appear ____.

A)horizontal and read from left to right in the row
B)horizontal and read from top to bottom in the column
C)vertically and read from top to bottom in the cell
D)vertically and read from bottom to top in the cell

Question 38

Figure 3-1 In the accompanying figure, the Alignment tab allows you to position data by ____.

A)indenting, rotating
B)aligning at the top, bottom, or center
C)centering, left-aligning, or right-aligning
D)all of the above

Question 39

The paste operation is one of many operations affected by an absolute cell reference.

Question 40

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

A)Range Finder
B)the Ribbon
C)the requirements document
D)the Edit menu

Question 41

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the ____ area.

A)source
B)cell
C)range
D)target

Question 42

Which comparison operator means "not equal to"?

A)
B)>
C)
D)

Question 43

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 44

Which of the following is not a valid format symbol?

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

Question 45

Figure 3-2 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 46

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

A)increment, decrement
B)decrement, increment
C)copy, cut
D)cut, copy

Question 47

Which of the following is not an Auto Fill option?

A)Copy Cells
B)Fill Cells
C)Fill Series
D)Fill Formatting Only

Question 48

The ____ button on the Ribbon or the ____ command on the shortcut menu removes cells (including the data and format)from the worksheet.

A)Remove
B)Delete
C)Erase
D)Cut

Question 49

The color bar at the bottom of the Fill Color and Font Color buttons on the Home tab on the Ribbon changes to the ____ color.

A)initially selected
B)most recently selected
C)adjacent cell
D)adjacent row or column

Question 50

Copying, deleting, inserting, and moving ranges of cells have the potential to ____.

A)improve consistency of the cells
B)improve consistency of the worksheet
C)render a worksheet useless
D)improve consistency of the workbook

Question 51

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

A)2
B)4
C)3
D)5

Question 52

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 53

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

A)Ribbon
B)Clipboard
C)Folder
D)File

Question 54

Error messages always begin with what symbol?

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

Question 55

Figure 3-2 In the accompanying figure, if you drag the pointer to the right, a ScreenTip indicates the ____.

A)name of the column
B)heading of the column
C)width of the column
D)height of the row

Question 56

Excel converts all the formulas from ____.

A)lowercase to uppercase
B)uppercase to lowercase
C)absolute to constant
D)constant to absolute

Question 57

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 58

Excel allows you to ____, so that Excel displays the titles on the screen, no matter how far down or to the right as you scroll.

A)center the titles
B)fix the titles
C)stabilize the titles
D)freeze the titles

Question 59

An alternative to increasing the column widths or row heights is to ____ to fit the current width of the column.

A)remove the adjacent column
B)enlarge the characters in the cell
C)shrink the characters in the cell
D)add an adjacent column

Question 60

A formula using the ____ cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.

A)variable
B)absolute
C)relative
D)constant

Question 61

Excel displays the message #REF! in a cell to indicate a cell reference____________________.

Question 62

When you ____ a worksheet, Excel is able to display more columns and rows.

A)shrink
B)minimize
C)expand
D)maximize

Question 63

A versatile method of copying a source area is to use the Copy button and Paste button on the Home tab on the ____________________.

Question 64

Unless you first select a range of cells or an object before starting the spell checker, Excel checks the selected ____.

A)text
B)formula
C)worksheet
D)range

Question 65

When you change a value on which a chart is dependent, Excel ____.

A)does not do anything until you save the change
B)immediately redraws the chart based on the new value
C)gives an error message
D)prompts you to save the change

Question 66

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

Question 67

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

A)exploded Pie chart
B)segmented Pie chart
C)Bar chart
D)2-D chart

Question 68

The ____________________ is a special place in the computer's memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document.

Question 69

Before creating a worksheet, you should have a good understanding of the ____________________ document.

Question 70

Excel rotates the chart 10 degrees in a ____ direction each time you click the Increase X Rotation button.

A)forward tilt
B)backward tilt
C)counterclockwise
D)clockwise

Question 71

The ____________________ Indent button decreases the indent by three spaces each time you click it.

Question 72

If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

A)verification seeking
B)the IF function
C)goal seeking
D)what-if analysis

Question 73

The dollar sign ($), comma (,), and percent sign (%)are called ____________________ symbols.

Question 74

The Formula Auditing group on the Formulas tab on the Ribbon also can be helpful when verifying ____________________.

Question 75

To format the legend on the chart, use the ____.

A)Formulas tab
B)Review tab
C)Legend gallery
D)Legend style

Question 76

You can magnify or shrink the appearance of a worksheet or chart by using the ____ button on the View tab on the Ribbon.

A)Maximize
B)Zoom
C)Focus
D)View Up/Down

Question 77

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

Question 78

The ____ is ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.

A)Undo button
B)Redo button
C)Copy button
D)Cut button

Question 79

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.

A)verification seeking
B)the IF function
C)goal seeking
D)what-if analysis

Question 80

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