Deck 6: Financial Functions, Data Tables, and Amortization Schedules

Question 1

The path to the Comma Style button is ____.

A) (HOME tab | Number group)
B) (HOME tab | Alignment group)
C) (HOME tab | Font group)
D) (HOME tab | Cells group)

Answer 1

A

Question 2

Which of the following format symbols displays text along with numbers entered in a cell?

A) _ (underscore)
B) 0 (zero)
C) " " (quotation marks)
D) # (number sign)

Answer 2

C

Question 3

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

A) (FORMULAS tab | Fill group)
B) (HOME tab | Editing group)
C) (INSERT tab | Editing group)
D) (DATA tab | Fill group)

Answer 3

B

Question 4

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

A) date
B) growth
C) auto fill
D) linear

Question 5

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

A) Accounting
B) Custom
C) General
D) Number

Question 6

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

A) Standard
B) Number
C) Currency
D) Normal

Question 7

Which of the following format codes insures that Excel will display a decimal point in the number?

A) . (period)
B) % (percent)
C) ( )
D) $*

Question 8

The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

A) summarization
B) consolidation
C) encapsulation
D) recapitulation

Question 9

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

A) ALT+SHIFT+ASTERISK (*)
B) CTRL+SHIFT+ASTERISK (*)
C) TAB+SHIFT+ASTERISK (*)
D) SHIFT+HOME+ASTERISK (*)

Question 10

____ format codes allow you to specify how a cell entry assigned a format will appear.

A) Individual
B) Specific
C) Custom
D) Duplicate

Question 11

You should create good ____ to ensure your workbooks are free of errors.

A) color contrast
B) range boundaries
C) test data
D) none of the above

Question 12

The path to the Sum button is ____.

A) (Insert tab | Editing group)
B) (Home tab | Editing group)
C) (Data tab | Functions group)
D) (Editing tab | Calculations group)

Question 13

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

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

Question 14

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

A) linear
B) growth
C) fill
D) date

Question 15

A workbook contains ____ worksheet(s) by default.

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

Question 16

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

A) auto fill
B) date
C) linear
D) growth

Question 17

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

A) linear
B) date
C) growth
D) fill

Question 18

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

A) (CELLS tab | Home group)
B) (INSERT tab | Cells group)
C) (HOME tab | Cells group)
D) (DATA tab | Insert group)

Question 19

You should hold down the ____ key to select the nonadjacent cells.

A) SHIFT
B) CTRL
C) TAB
D) END

Question 20

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

A) DATE
B) ROUND
C) SUM
D) IF

Question 21

Headers, footers, and margins are all ____ options.

A) validation
B) calculation
C) page setup
D) control

Question 22

When you insert a manual page break, Excel displays a(n) ____ line between pages.

A) solid
B) orange
C) red
D) dotted

Question 23

You can switch to Page Layout view by clicking the Page Layout button ____.

A) on the status bar
B) (HOME tab | Layout group)
C) (VIEW tab | Show group)
D) on the FILE tab

Question 24

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

A) Select Active Sheet
B) Ungroup Sheets
C) Quick Select
D) Disaggregate Sheets

Question 25

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

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

Question 26

Which of the following is the path to the Switch Windows button?

A) (INSERT tab | View group)
B) (VIEW tab | Workbook Views group)
C) (REVIEW tab | Windows group)
D) (VIEW tab | Window group)

Question 27

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

A) F5
B) F6
C) F11
D) F12

Question 28

A(n) ____ reference is a formula that depends on its own value.

A) explicit
B) implicit
C) singular
D) circular

Question 29

The ____ keyboard shortcut copies an image of the source area as a picture.

A) CTRL+R
B) CTRL+U
C) CTRL+I
D) CTRL+K

Question 30

A range that spans two or more worksheets in a workbook is called a ____ range.

A) 1-D
B) 2-D
C) 3-D
D) 4-D

Question 31

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

A) (PAGE LAYOUT tab | Page Setup group)
B) (HOME tab | Page Setup group)
C) (PAGE LAYOUT tab | Sheet Options group)
D) (VIEW tab | Show group)

Question 32

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

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

Question 33

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

A) section
B) page
C) sheet
D) range

Question 34

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ that show the boundaries of what will print on each page.

A) margins
B) selection barriers
C) indices
D) page breaks

Question 35

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

A) positive numbers
B) negative numbers
C) zeros
D) text

Question 36

You can display the ____ tab to specify page setup options.

A) SETUP
B) PRINT
C) PAGE LAYOUT
D) DISPLAY

Question 37

A ____ is a reference to a cell or range of cells in another workbook.

A) code
B) link
C) function
D) formula

Question 38

The code ____ instructs Excel to insert the page number in the header or footer section.

A) <>
B) &[Page]
C) [PageNum]
D) (LoadPageNum)

Question 39

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

A) dynamic
B) relative
C) absolute
D) integrated

Question 40

You can drill all of the following down through a workbook EXCEPT ____.

A) formats
B) numbers
C) formulas
D) groupings

Question 41

If you change the Normal style, Excel applies the new format specifications to all cells, including those assigned other styles.

Question 42

When you use the SUM function, Excel assumes that all contiguous numbers should be summed.

Question 43

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

Question 44

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Question 45

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers.

Question 46

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Question 47

A code is a group of format specifications that are assigned a name.

Question 48

When you consider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Question 49

Which of the following is a method of electronic document distribution?

A) posting on SkyDrive
B) sharing an XPS image of a document
C) blog posting
D) posting on a social networking site

Question 50

You can enter formulas that reference cells on other worksheets in the workbook.

Question 51

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Question 52

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Question 53

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

Question 54

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

A) style
B) workbook name
C) location
D) sheet name

Question 55

As you develop more sophisticated workbooks, it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

Question 56

Which of the following are true about the ROUND function?

A) If the number of digits argument is greater than 0 (zero), then the number is rounded to the specified number of digits to the right of the decimal point.
B) If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer.
C) If the number of digits argument is not included, then the number is rounded to 10 times the current value.
D) If the number of digits argument is less than 0 (zero), then the number is rounded to the specified number of digits to the left of the decimal point.

Question 57

Which of the following fill actions can you perform by dragging the fill handle?

A) Jan, Feb, March, etc.
B) 1, 1, 1, etc.
C) 2, 4, 6, etc.
D) 1, 2, 3, etc.

Question 58

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Question 59

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

Question 60

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Question 61

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

Question 62

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Question 63

Always take the time to select ____________________ data that tests the limits of the formulas.

Question 64

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Question 65

An organization may keep data from various departments or regions in different worksheets in the same workbook. _________________________

Question 66

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

Question 67

The formula =sum(1:1) adds all the values in column A. _________________________

Question 68

When tiling windows vertically the windows appear as wide as possible. _________________________

Question 69

When a series of @@@@@@ signs or symbols appears in a cell that should contain a date, the formatted date does not fit in the width of the cell. _________________________

Question 70

When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.

Question 71

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

Question 72

If multiple sheets are selected and you want to select the active sheet, if you are using a mouse, hold down the CTRL key and then click the sheet tab of the active sheet. _________________________

Question 73

Each format ____________________ within the format code shown in the accompanying figure has special meaning.

Question 74

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

Question 75

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group) to display the Colors gallery.

Question 76

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

Question 77

If multiple sheets are selected and you want to select a sheet that is selected, but not active, tap or click the sheet tab you want to select.

Question 78

Excel copies page setup characteristics when one sheet is copied to another.

Question 79

If added, a footer appears at the bottom of every printed worksheet page.

Question 80

You can use the ENTER key to complete a paste operation.