Deck 10: Excel_Module_3

Question 1

Cell references in a formula are called ____.

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

Answer 1

A

Question 2

Which of the following formulas contains an absolute cell reference?

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

Answer 2

C

Question 3

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 3

B

Question 4

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 5

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 6

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 7

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 8

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 9

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 10

Which comparison operator means "not equal to"?

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

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

Which of the following is not a valid format symbol?

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

Question 20

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 21

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

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

Question 22

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

Question 23

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

Question 24

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 25

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 26

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

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

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

Question 29

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 30

The arguments in an IF function are ____.

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

Question 31

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 32

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 33

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 34

Which of the following are formatting symbols?

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

Question 35

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

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

Question 39

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 40

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

Question 41

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 42

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

Question 43

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 44

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

Question 45

You can select nonadjacent ranges using the SHIFT key.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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 60

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 61

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 62

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

Question 63

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.