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

Question 1

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

Answer 1

C

Question 2

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 2

B

Question 3

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

Answer 3

A

Question 4

Cell references in a formula are called ____.

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

Question 5

Which of the following formulas contains an absolute cell reference?

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

Question 6

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 7

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

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

Question 8

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 9

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 10

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) Copy Cells

Question 11

In the context of copying 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 12

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 13

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 14

Which of the following is not a valid format symbol?

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

Question 15

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 16

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 17

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 18

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 19

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

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

Question 20

Which comparison operator means "not equal to"?

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

Question 21

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

Question 22

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

Question 23

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 24

Which of the following are formatting symbols?

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

Question 25

The arguments in an IF function are ____.

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

Question 26

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 27

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

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

Question 28

Text in a cell can be rotated counterclockwise 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 29

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

The Linked Pictures option in the Paste Options gallery copies 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 31

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

Question 32

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 33

The <= comparison operator means less than or equal to.

Question 34

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

Question 35

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

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

Question 36

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 37

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

Question 38

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 39

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

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

Panes created using the vertical split bar scroll together horizontally.________________________

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Question 54

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

Question 55

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Question 56

You can select nonadjacent ranges using the SHIFT key.

Question 57

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

Question 58

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Question 59

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

Question 60

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

Question 61

Which of the following patterns extends the fill series to 525,475,425?​

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

Question 62

A sensitivity analysis is another name for a(n)____________________ analysis.

Question 63

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 64

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Question 65

Error messages begin with the _____ symbol.​

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

Question 66

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

Question 67

_____ text often provides a strong visual appeal.​ ​

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

Question 68

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

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

Question 69

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

Question 70

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

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

Question 71

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

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