Deck 14: Working With Large Worksheets, Charting, and What-If Analysis Question

Question 1

Cell references in a formula are called ____.

A) assumptions
B) samments
C) numbers
D) santent

Answer 1

A

Question 2

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

Answer 2

B

Question 3

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

Answer 3

B

Question 4

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 5

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

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

Question 6

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

A) Fill Months
B) Fill Without Formatting
C) Fill Formatting Only
D) sapy Cells

Question 7

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

A) logical
B) sanstant
C) sansistent
D) calculated

Question 8

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

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

Question 9

____ text often provides a strong visual appeal.

A) Launched
B) Tiny
C) Logical
D) Rotated

Question 10

Which of the following is the path to the Insert Cells arrow?

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

Question 11

The sapy button sapies the santents and format of the source area to the Office ____, a temporary storage area in the samputer's memory.

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

Question 12

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

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

Question 13

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

A) Position
B) Orientation
C) Slope
D) Incline

Question 14

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

Question 15

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

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

Question 16

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

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

Question 17

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

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

Question 18

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

A) Alignment
B) Left and Right
C) Center
D) Position

Question 19

After shrinking entries to fit in cells, sansider using the ____ slider on the status bar to make the entries more readable.

A) View
B) Preview
C) Display
D) Zoom

Question 20

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

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

Question 21

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 22

Charts can either be embedded in a worksheet or placed in a separate ____.

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

Question 23

Which samparison operator means "not equal to"?

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

Question 24

Which of the following is not a valid format symbol?

A) semi-salon (;)
B) percent sign (%)
C) dollar sign ($)
D) samma (,)

Question 25

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 26

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 27

____ 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 28

Error messages begin with the ____ symbol.

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

Question 29

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

A) Click or tap
B) Press or long-press
C) Double-click or double-tap
D) Triple-click or tap

Question 30

Which of the following formulas santains an absolute cell reference?

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

Question 31

You should use a ____ chart to sampare values side by side, broken down by category.

A) salumn
B) Bar
C) Line
D) Clustered salumn

Question 32

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 33

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 34

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

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

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

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

A) section
B) sparkline
C) special
D) sparkle

Question 37

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

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

Question 38

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 39

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

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

Question 40

In a clustered salumn chart, the names of each salumn are part of the ____ series.

A) category
B) data
C) label
D) legend

Question 41

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

Question 42

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

Question 43

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 44

The less than or equal to .

Question 45

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

Question 46

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 47

The NETWORKDAYS function checks a formula for sarrectness.

Question 48

Modified Multiple Choice Which of the following are formatting symbols?

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

Question 49

When Excel cannot calculate a formula, it displays an error message in a cell.

Question 50

Excel allows you to rotate text in a cell saunterclockwise by entering a number between -1 degrees and -90 degrees.

Question 51

The Linked Pictures option in the Paste Options gallery sapies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Question 52

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

Question 53

Modified Multiple Choice Text in a cell can be rotated saunterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

A) 15
B) 90
C) 145
D) 180

Question 54

A cell reference with only one dollar sign before either the salumn or the row is called an absolute reference.

Question 55

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 56

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

Question 57

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

Question 58

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

Question 59

Modified Multiple Choice If the santents of a cell sapied 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 60

The insarrect use of sapying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

Question 61

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

Question 62

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

Question 63

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

Question 64

With bar charts, you can drag the bar in the chart in one direction or another to change the sarresponding value in the worksheet.

Question 65

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

Question 66

You can select nonadjacent ranges using the SHIFT key.

Question 67

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

Question 68

Excel includes four types of sparkline charts: line, salumn, win/loss, and stock.

Question 69

The ____________________ option on the Auto Fill Options menu fills the destination area with santents using the format of the source area and does not create a series.

Question 70

Panes created using the vertical split bar scroll together horizontally .

Question 71

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

Question 72

Many ribbon sammands, galleries, and shortcut keys function as toggles or switches.

Question 73

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

Question 74

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

Question 75

The underline format underlines the entire cell, not just the characters in the cell.

Question 76

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no santent is sapied unless the fill is a series.

Question 77

The ____________________ option on the Auto Fill Options menu fills the destination area with the santents but without the formatting of the source area.

Question 78

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

Question 79

The range of entries that identifies the major groups for a clustered salumn chart are called the category names.

Question 80

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