Deck 6: Excell: Working With Multiple Worksheets and Workbooks

Question 1

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 1

C

Question 2

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

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

Answer 2

B

Question 3

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

Answer 3

C

Question 4

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 5

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 6

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

A) #,##0.00;[Blue](#,##0.00)
B) 0.00%[Blue];(0.00%)
C) 0.00%;[Blue](0.00%)
D) $*#,##0_;[Blue]($*#,##0_)

Question 7

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 8

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 9

A workbook contains ____ worksheet(s) by default.

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

Question 10

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)

Question 11

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 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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 17

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

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

Question 18

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

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

Question 19

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 20

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)

Question 21

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

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

Question 22

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 23

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 24

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 25

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

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

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

Question 28

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 29

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

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

Question 30

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

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

Question 31

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 32

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

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

Question 33

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 34

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

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

Question 35

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 36

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 37

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 38

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 39

Headers, footers, and margins are all ____ options.

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

Question 40

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 41

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 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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 50

Modified Multiple Choice Which of the following are true about the ROUND function?

A) If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer.
B) If the number of digits argument is not included, then the number is rounded to 10 times the current value.

Question 51

Modified Multiple Choice 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 52

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

Question 53

Modified Multiple Choice 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 54

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

Question 55

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

Question 56

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 57

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 58

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 59

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 60

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 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

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 added, a footer appears at the bottom of every printed worksheet page.

Question 73

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 74

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

Question 75

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 76

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

Question 77

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

Question 78

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

Question 79

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 80

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