Deck 5: Working With Multiple Worksheets and Workbooks

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

C

Question 3

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

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

Answer 3

B

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

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

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

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

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

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

Question 8

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 9

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 10

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

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

Question 11

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 12

A workbook contains ____ worksheet(s)by default.

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

Question 13

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 14

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 15

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 16

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

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

Question 17

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)

Question 18

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

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

Question 19

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 20

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 21

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 22

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 23

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 24

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

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

Question 25

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

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

Question 26

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 27

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 28

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

A) <

Question 29

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

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

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

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 32

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

Question 33

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 34

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

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

Question 35

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 36

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 37

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 38

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 39

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

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

Question 40

Headers,footers,and margins are all ____ options.

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

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

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

Question 60

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

Question 61

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

Question 62

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

Question 63

A circular reference is a formula that depends on its own value.​

Question 64

​The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.

Question 65

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 66

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 67

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.​

Question 68

By default,Excel places charts in the center of the worksheet.t.​