Deck 9: Multiple-Sheet Workbook Management

Question 1

How do you group all worksheets?

A)Click a tab and press Ctrl+A.
B)Click Group on the Insert tab.
C)Right click each worksheet tab and select Group.
D)Right click a worksheet tab and select Select All Sheets.

Answer 1

D

Question 2

Which is not an option for arranging windows with the Arrange All command?

A)Tiled
B)Horizontal
C)Side by Side
D)Cascade

Answer 2

C

Question 3

The Fill Across Worksheets command is ________.

A)only usable on an empty workbook
B)an option on the Fill button on the Home Tab
C)applicable to formats but not contents
D)an option on the Group button on the Data Tab

Answer 3

B

Question 4

Which of the following formulas contains an accurate 3-D reference?

A)=B4+1st Quarter:'B3
B)=Sales-Expenses
C)=B4+'1st Quarter'!B3
D)=[Sales]-[Expenses]

Question 5

The worksheet name in a 3-D reference is enclosed in ________.

A)double quotes ("sheetname")
B)single quotes ('sheetname')
C)asterisks (*sheetname*)
D)back slashes (\sheetname\)

Question 6

A hyperlink in an Excel worksheet can do all of the following, except ________.

A)open a different workbook.
B)switch to another worksheet.
C)open a webpage.
D)launch Word.

Question 7

If you move or delete an endpoint worksheet in a 3-D reference ________.

A)you must update the reference
B)Excel opens a dialog box to correct the changed reference
C)nothing changes
D)Excel adjusts the 3-D references to reflect the change

Question 8

How do you determine if a worksheet is grouped?

A)The tabs of all grouped worksheets are yellow.
B)A padlock icon appears on the title bar.
C)An icon of stacked paper displays on each tab.
D)[Group] displays in the title bar

Question 9

What is a 3-D reference?

A)A data cube function
B)A reference to multiple cells
C)A circular reference to the cell
D)A cell reference to another worksheet

Question 10

Which is not a method of removing a split?

A)Click Remove Split on the View tab.
B)Double click on a split bar.
C)Click and drag the horizontal split bar off the top of the window.
D)Click and drag the vertical split bar off the left of the window.

Question 11

In the Edit Links dialog box, If a workbook referenced by a hyperlink is lost or moved, ________ will display.

A)Error: Link Broken
B)#ERROR
C)Error: Manually find link?
D)Error: Source not found

Question 12

________ is the process of dividing a worksheet window into two or four resizable panes so you can view separate parts of a worksheet at the same time.

A)Synchronous Scrolling
B)Splitting
C)View Side by Side
D)Tiling

Question 13

To edit or remove a hyperlink ________.

A)left-click the hyperlink and then select Edit Hyperlink
B)double-click the hyperlink and then select Edit Hyperlink
C)select the hyperlink and then press delete
D)right-click the hyperlink and then select Edit Hyperlink

Question 14

Which of the following actions will open another window of the current workbook?

A)Click the Formulas tab, and then click New Window in the Manage group.
B)Click the View tab, and then click New Window in the Manage group.
C)Click the View tab, and then click New Window in the Window group.
D)Click the Data tab, and then click New Window in the Manage group.

Question 15

By default, a visited text hyperlink in an Excel worksheet is ________.

A)purple and underlined
B)red and bold
C)green and underlined
D)blue and underlined

Question 16

If all worksheets are grouped, how do you ungroup them?

A)Click any tab.
B)Click Ungroup on the data tab.
C)Right click a sheet tab and select Ungroup Sheets.
D)Select any range of cells.

Question 17

Applying a format to a range of cells in a grouped worksheet will ________.

A)apply the format only to the visible range of cells
B)produce a warning that the worksheets are grouped
C)do nothing
D)apply the same formatting to all worksheets in the group

Question 18

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1, what happens in Sheet 2?

A)No change happens.
B)Sheet 2 B3 has the same formula.
C)A warning appears, warning you not to make changes in grouped sheets.
D)Formatting will change on Sheet 2, but not formulas.

Question 19

Which is true about hiding a worksheet?

A)It is unrecoverable.
B)It removes it from view, making the visible number of tabs more manageable.
C)It disables formulas referencing that worksheet.
D)Hide worksheets in Options on the Home Tab.

Question 20

Which of the following is an example of Pascal Case notation.

A)pascalCaseNotation
B)PascalCaseNotation
C)pascal_case_notation
D)Pascal Case Notation

Question 21

What auditing tool is designed to monitor changes in a cell in a separate window?

A)Watch Window
B)Trace Precedents
C)Insert Function dialog box
D)Validation Rules

Question 22

________ are the rules that dictate the type of data that can be entered in a cell.

A)Input message
B)Validation criteria
C)Error alert
D)Defined item

Question 23

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

A)Trace Precedents
B)Trace Dependents
C)Show Formulas
D)Evaluate Formula

Question 24

The formula =B2*B7 is located in cell C7.Which cell is the dependent cell?

A)B2
B)C7
C)B3
D)B7

Question 25

Which of the following functions does not contain a syntax error?

A)=AVERAGE(A1:A9)
B)=avg(A1:A9)
C)=AVERAG(A1,A9)
D)=AVERAGE(A1;A9)

Question 26

Which character or characters separate the cell reference from the sheet name in an external reference?

A)!
B)[]
C)''
D):/

Question 27

Which of the following is not an Error Style for data validation?

A)Stop
B)Critical
C)Warning
D)Information

Question 28

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

A)#NAME?
B)#NULL!
C)#NUM
D)#REF

Question 29

All of the following could produce a #NAME? error except ________.

A)Misspelled word
B)Invalid Range Name
C)Invalid arguments in a function
D)Invalid Function Name

Question 30

A method to validate copy and pasted data is ________.

A)Post input validation check
B)Circle Invalid Data
C)Error tracing
D)Validity Tool

Question 31

What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?

A)Copy and paste
B)External cell references
C)3-D Formulas
D)Splitting

Question 32

Which character or characters notes the file path in an external reference?

A)[]
B)''
C)!
D):/

Question 33

Which is true about the following external cell reference? 'G:\Branches[Minneapolis.xlsx]Qtr 1'!A1

A)It is in the same folder as the destination file.
B)It is in the same workbook as the destination file
C)It is in a different folder than the destination file.
D)It will not work because of the spaces in the worksheet name.

Question 34

What does a green triangle in the upper left corner of a cell mean?

A)Precedent to another cell
B)Source cell lost
C)Potential syntax error
D)Potential logic error

Question 35

What happens to an open destination file if the source file is edited while both are open?

A)The source file receives an error.
B)The destination asks if you would like to accept updates to the source file.
C)The destination file updates
D)Antivirus software blocks the changes.

Question 36

Right clicking a sheet tab and selecting Select All Sheets will ________ all worksheets in the workbook.

Question 37

What is the feature that warns users from entering invalid data?

A)Watch Window
B)Formula Auditing
C)Data Validation
D)Tracing Precedents

Question 38

If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.

A)Evaluate Formula
B)Trace Dependents
C)Trace Precedents
D)IFERROR

Question 39

What do blue arrows mean when tracing precedents?

A)Cells with errors
B)Cells with validation rules
C)Cells with no errors
D)Cells with Watch Windows

Question 40

You developed a sales quotation workbook that you will share with your sales staff to help them quote prices.It shows #DIV/0 in some cells where there are empty quantities in a column.Which function would handle the error and replace it with another value.

A)ERRRORRETURN
B)IFERROR
C)ERRORHANDLER
D)ERRORTRACK

Question 41

'[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.

Question 42

To setup Split Windows, Synchronous Scrolling or Arrange open workbooks, go to the Window Group in the ________ tab.

Question 43

The ________ function checks a cell to determine if the cell contains an error.

Question 44

A(n)________ is a reference within a formula or function to a different worksheet.

Question 45

A(n)________ reference occurs when a formula uses the cell which contains the formula.

Question 46

________ is the dependent cell with this formula in A10:
=Sum(A2:A8)

Question 47

The user can define an optional ________ that appears when the mouse pointer hovers over a hyperlink.

Question 48

A(n)________ is where you go when you click a hyperlink.

Question 49

In a 3-D Reference, the ________ name is enclosed in single quotes and followed by an exclamation point.

Question 50

By default, automatic updates are ________ to protect the destination file from virus infection

Question 51

When worksheets are grouped, [Group} appears in the ________.

Question 52

________ locks 2 windows together and enables you to view them line by line as you scroll through them.

Question 53

________ is not supported in grouped worksheets, but you can apply it to one and Fill it across other worksheets.

Question 54

If you're presenting a large workbook with many worksheets, you may want to ________ some of the worksheets to provide a more streamlined appearance.

Question 55

The return for =12/0 will be a(n)________ error.

Question 56

When using the tracer arrows, cell with errors have ________ arrows.

Question 57

By default, ________ text appears underlined in blue in an Excel Worksheet

Question 58

A(n)________ window has two or four panes displaying the same worksheet.

Question 59

________ cells are referenced by a formula in another cell.

Question 60

The ________ is the file which holds a pointer to outside data in a source file.

Question 61

You can apply conditional formatting on grouped worksheets.

Question 62

A source file is a file containing links to receive data from the destination files.

Question 63

View Side by Side locks two worksheets to scroll together.

Question 64

A Split Window has three panes by default

Question 65

Objects such as charts cannot contain hyperlinks.

Question 66

A(n)________ is best suited to monitor the changes in a cell as input values change.

Question 67

=SUM('1st Quarter:4th Quarter'!B4:B12)is a function using a 3-D reference.

Question 68

A(n)________ error alert accepts invalid data but provides information to the user.

Question 69

Hyperlinks can be used to build a table of contents in an Excel workbook with many worksheets.

Question 70

You can drag a split bar off the window to remove it.

Question 71

An icon of stacked sheets displays on the tabs of grouped worksheets

Question 72

You can apply uniform page layouts to grouped worksheets.

Question 73

Validation ________ are the rules that dictate the type of data that can be entered.

Question 74

A destination file is a file that contains original data that you need in another file.

Question 75

3-D references must be updated manually when you adjust the reference point.

Question 76

E:\Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a source file in different directory than the destination file.

Question 77

Camel Case notation capitalizes the first letter of all words except the first and removes spaces

Question 78

The #NAME? error means that at least one argument is missing in the function.

Question 79

Hyperlinks must link to websites.

Question 80

A(n)________ accepts invalid data but warns the user that the data are invalid.