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

Question 1

Pressing the _____ key(s)removes the marquee from the source area.

A)TAB
B)CTRL+X
C)CTRL+V
D)ESC

Answer 1

D

Question 2

_____ text often provides a strong visual appeal.

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

Answer 2

D

Question 3

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

A)(Home tab | Editing group)
B)(Home tab | Number group)
C)(Home tab | Cells group)
D)(Home tab | Inserting group)

Answer 3

C

Question 4

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 5

When you first enter text, its angle is _____ degrees, and it reads from left to right in a cell, as shown in the accompanying figure.

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

Question 6

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 7

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 8

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 9

To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells _____.

A)button
B)check box
C)option button
D)Dialog Box Launcher

Question 10

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 11

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

A)Range Finder
B)the Ribbon
C)the requirements document
D)Backstage view

Question 12

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 13

An alternative to clicking the Paste button is to press the _____ key.

A)ENTER
B)ALT
C)CTRL
D)SHIFT

Question 14

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 15

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 16

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 17

Cell references in a formula are called _____.

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

Question 18

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

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

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 21

_____ 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 22

Which of the following is not a valid format symbol?

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

Question 23

You can press the _____ keys to open the Format Cells dialog box.

A)CTRL+1
B)CTRL+2
C)CTRL+3
D)CTRL+4

Question 24

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 25

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 26

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 27

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 28

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 29

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 30

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 31

Which of the following is the path to the Goal Seek button?

A)(Insert tab | Goal Seek group)
B)(Home tab | Data Tools group)
C)(Data tab | Data Tools group)
D)(Analyses tab | Goal Seeking group)

Question 32

Error messages begin with the _____ symbol.

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

Question 33

A(n)_____ is a separate sheet in a workbook that contains only a chart.

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

Question 34

_____ 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 35

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 36

Which comparison operator means "not equal to"?

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

Question 37

The path to the Format Painter button is _____.

A)(Home tab | Number group)
B)(Home tab | Clipboard group)
C)(Home tab | Painting group)
D)(Home tab | Font group)

Question 38

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

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

Question 39

Which of the following formulas contains an absolute cell reference?

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

Question 40

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 41

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

Question 42

If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.

Question 43

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

Question 44

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

Question 45

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

Question 46

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 47

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

Question 48

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 49

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

Question 50

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

Question 51

The less than or equal to .

Question 52

Modified Multiple Choice When you first enter text, its angle is zero degrees (0), and it reads from left to right in a cell.Text in a cell can be rotated counterclockwise by entering a number between _____ and _____ in the Alignment sheet in the Format Cells dialog box.

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

Question 53

The path to the Logical button is (Formulas tab | Function Library group).

Question 54

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 55

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

Question 56

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 57

Modified Multiple Choice Which of the following are formatting symbols?

A)Dollar sign ($)
B)Comma (,)
C)Pound sign (#)
D)Percent sign (%)

Question 58

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

Question 59

The NETWORKDAYS function checks a formula for correctness.

Question 60

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 61

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 62

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

Question 63

Many Ribbon commands, galleries, and shortcut keys function as toggles or switches.

Question 64

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

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 replace a formula with its function so it remains constant.

Question 68

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

Question 69

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

Question 70

You can select nonadjacent ranges using the SHIFT key.

Question 71

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

Question 72

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

Question 73

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

Question 74

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 75

You can click the Logical button (Formulas tab | Function Library group)and click IFERROR to insert the IF function.

Question 76

Panes created using the vertical split bar scroll together horizontally .

Question 77

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

Question 78

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

Question 79

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

Question 80

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