Deck 9: Multiple-Sheet Workbook Management

Question 1

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.

Answer 1

B

Question 2

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.

Answer 2

B

Question 3

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

Answer 3

D

Question 4

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 5

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 6

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

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

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

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 9

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 10

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

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

Question 11

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

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 13

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

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 16

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.

Question 17

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 18

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 19

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

Question 20

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 21

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

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

Question 22

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 23

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 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 character or characters notes the file path in an external reference?

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

Question 26

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 27

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 28

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 29

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 30

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

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

Question 31

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

Question 32

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

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 34

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 35

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 36

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

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

Question 37

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 38

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 39

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 40

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 41

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

Question 42

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

Question 43

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

________ cells are referenced by a formula in another cell.

Question 60

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

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

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

Objects such as charts cannot contain hyperlinks.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

A Split Window has three panes by default

Question 76

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

Question 77

Hyperlinks must link to websites.

Question 78

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

Question 79

View Side by Side locks two worksheets to scroll together.

Question 80

You can apply uniform page layouts to grouped worksheets.