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

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 2

A

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

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 5

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 6

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 7

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 8

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

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 11

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 12

Which of the following formulas contains an absolute cell reference?

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

Question 13

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 14

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

Which of the following is not a valid format symbol?

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

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 comparison operator means "not equal to"?

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

Question 19

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 20

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 21

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 22

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 23

The arguments in an IF function are ____.

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

Question 24

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 25

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

Question 26

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

Question 27

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

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

Question 30

Which of the following are formatting symbols?

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

Question 31

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

Question 32

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

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

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

Question 34

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

Question 35

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 36

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 37

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

Question 38

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

Question 39

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 40

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 41

You can select nonadjacent ranges using the SHIFT key.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

Question 56

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 57

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

Question 58

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

Question 59

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

Question 60

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 61

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
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

Question 62

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
Error messages begin with the _____ symbol.​

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

Question 63

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 64

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

Question 65

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 66

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
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 67

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

A)increase the width of column H
B)provide a correct argument or operand
C)run the calculation again to find the available value
D)replace the incorrect formula in cell H14 with one that does not divide by zero

Question 68

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
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 69

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
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 70

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet?

A)Copy and paste all his Sales data formulas with relative references
B)Add an IF function formula to his Sales data worksheet
C)Add the NOW function formula to his Sales data worksheet
D)Copy and paste all his Sales data formulas with absolute references

Question 71

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
You can replace a formula with its function so it remains constant.​__________

Question 72

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
_____ text often provides a strong visual appeal.​ ​

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

Question 73

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
_____ 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 74

Case 3-1
​
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
_____ refers to cells not wide enough to display the entire entry.​

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

Question 75

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