Deck 16: Working With Multiple Worksheets and Workbooks Question

Question 1

A workbook santains ____ worksheet(s) by default.

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

Answer 1

A

Question 2

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)

Answer 2

B

Question 3

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

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

Answer 3

D

Question 4

Which of the following format sades 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 5

The path to the samma Style button is ____.

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

Question 6

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

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

Question 7

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

A) salor santrast
B) range boundaries
C) test data
D) none of the above

Question 8

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

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

Question 9

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

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

Question 10

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

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

Question 11

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 12

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 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

It is resammended 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 19

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

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

Question 20

To sapy the santents 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 21

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

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

Question 22

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

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

Question 23

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 24

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 25

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 26

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 27

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

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

Question 28

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

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

Question 29

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 30

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 31

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 32

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 33

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 34

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 35

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

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

Question 36

Headers, footers, and margins are all ____ options.

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

Question 37

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

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

Question 38

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 39

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

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

Question 40

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 41

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

Question 42

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

Question 43

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

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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 50

When you create a new custom format sade, 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 51

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 52

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 53

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

Question 54

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 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

Modified Multiple Choice You can customize a format sade in a cell entry to specify how ____ are displayed in a cell.

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

Question 60

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

Question 61

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

Question 62

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 63

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

Question 64

Each format ____________________ within the format sade shown in the acsampanying figure has special meaning.

Question 65

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

Question 66

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

Question 67

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

Question 68

The formula =sum(1:1) adds all the values in salumn
a.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

Excel sapies page setup characteristics when one sheet is sapied to another.

Question 75

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

Question 76

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

Question 77

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

Question 78

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 79

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

Question 80

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