Deck 26: Excel : Multiple-Sheet Workbook Management

Question 1

Which of the following is not a way to remove panes from a window that has been split?

A)Double-click the split bar
B)Drag a vertical split bar to the left or right edge of the worksheet window
C)Click Split in the Window group
D)Click Remove Split in the View tab

Answer 1

D

Question 2

To group adjacent worksheets:

A)click Group on the Data tab.
B)click the first worksheet tab,press and hold Shift,and then click the last worksheet tab.
C)click Group on the View tab.
D)right-click a worksheet tab and click Select All Sheets.

Answer 2

B

Question 3

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?

A)[WorkbookName]"WorksheetName"!RangeOfCells
B)[WorkbookName]'WorksheetName'!RangeOfCells
C)WorksheetName!RangeOfCells
D)[WorkbookName]WorksheetName!RangeOfCells

Answer 3

D

Question 4

In Excel,hyperlinks appear as:

A)blue text with a blue underline.
B)red text with a blue underline.
C)black text.
D)blue text with a black underline.

Question 5

To group nonadjacent worksheet tabs:

A)right-click a worksheet tab and click Select All Sheets.
B)click Group on the View tab.
C)click the first worksheet tab,press and hold Shift,and then click the last worksheet tab.
D)click the first worksheet tab,press and hold Ctrl,and then click each additional worksheet tab.

Question 6

Which of the following is the proper format for a 3-D reference?

A)Worksheet Name!RangeOfCells
B)'Worksheet Name'!RangeOfCells
C)"Worksheet Name"!RangeOfCells
D)'Worksheet Name!RangeOfCells'

Question 7

When worksheets are grouped which of the following actions will not occur across all worksheets?

A)Data entry
B)Structural changes
C)Formatting
D)Conditional formatting

Question 8

Which of the following is not an option when arranging windows?

A)Tiled
B)Horizontal
C)Stacked
D)Cascade

Question 9

This should be used when referencing cells on another worksheet.

A)Function
B)Reference
C)Formula
D)3-D reference

Question 10

To ungroup worksheets:

A)click a worksheet tab for a sheet that is not grouped.
B)press Esc.
C)click Ungroup on the Formulas tab.
D)click Ungroup on the Data tab.

Question 11

When worksheets are grouped,which of the following is true?

A)[Group] appears in the title bar
B)The worksheets are locked
C)A lock appears in the title bar
D)The worksheets cannot be edited

Question 12

What is the proper format of an external reference to a workbook or worksheet thats name contains spaces;source and destination files are in the same folder?

A)''[WorkbookName]Worksheet''!Cell
B)Worksheet'!Cell
C)[WorkbookName]Worksheet!Cell
D)'[WorkbookName]Worksheet'!Cell

Question 13

To group all worksheets:

A)right-click a cell and select All.
B)click Group on the Data tab.
C)right-click a worksheet tab and click Select All Sheets.
D)click Group on the View tab.

Question 14

Which of the following is true when synchronize scrolling is enabled?

A)Side by side worksheets will scroll at the same rate
B)Side by side worksheets will scroll at a different rate
C)Side by side worksheets will not scroll
D)Side by side worksheets are locked

Question 15

What is the best method to consolidate three workbooks into another workbook?

A)Copy and paste
B)External cell references
C)3-D formulas
D)Web query

Question 16

Which of the following functions cannot be used as a 3-D formula?

A)SUM
B)PMT
C)AVERAGE
D)MAX

Question 17

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 Window group
C)Click the Data tab,and then click New Window in the Manage group
D)Click the View tab,and then click New Window in the Manage group

Question 18

Which of the following cannot be accessed via a hyperlink in Excel?

A)External workbook
B)Different worksheet
C)Web page
D)Another program

Question 19

To edit or remove a hyperlink:

A)left-click it,and then select Edit Hyperlink to open the Edit Hyperlink dialog box.
B)right-click it,and then click Delete.
C)right-click it and then select Edit Hyperlink to open the Edit Hyperlink dialog box.
D)double-click it and then click Delete.

Question 20

Visited hyperlinks in Excel appear as:

A)blue text.
B)black text.
C)yellow text.
D)purple text.

Question 21

All of the following could produce a #NAME? error with the exception of which one?

A)Misspelled word
B)Invalid range name
C)Invalid arguments in a function
D)Invalid function name

Question 22

What is indicated by red arrows when tracing precedents?

A)Cells that cause errors
B)Cells with validation rules
C)Cells with no errors
D)Cells with comments

Question 23

What auditing tool is best used to monitor the changes in a cell over time?

A)Trace precedents
B)Watch Window
C)Trace dependents
D)Formula bar

Question 24

If the formula =B2*B3 is located in cell C3,which cell is not a precedent?

A)C3
B)B2
C)B3
D)C1

Question 25

What happens when data that is externally linked is edited and both the source and destination file are open?

A)The links will automatically update
B)The links will not update
C)A security prompt appears
D)There will be no change

Question 26

When is the input message displayed in a cell that contains a validation rule?

A)When the user violates a rule
B)When the cell is clicked
C)When the workbook is opened
D)When the cell is double-clicked

Question 27

Which of the following would cause the error #DIV/0! to appear?

A)Misspelled word
B)Formula attempts to divide a value by zero or an empty cell
C)Invalid range name
D)Invalid arguments in the function

Question 28

Which of the following is not a data validation stop style?

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

Question 29

Which of the following would cause the error #VALUE! to appear?

A)Misspelled word
B)Deleted cell reference
C)Incorrect data used in an argument
D)Invalid range name

Question 30

In the formula =B2*B3 is located in cell C3,which cell is the dependent cell?

A)B2
B)B3
C)C3
D)C1

Question 31

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

A)=IF(0>0,"yes"."no")
B)=IF(B5>B5,"yes","no")
C)=IF(B6/0>C6/0,"yes","no")
D)=IF(B6>C6,"Yes","No")

Question 32

What happens if a user violates a validation rule and a stop style is applied?

A)The user will not be able to continue
B)The user will be able to continue
C)The user can choose to ignore the error
D)The user will be able to edit the rule

Question 33

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

A)=avg(B1:B9)
B)=AVERAG(B1:B9)
C)=AVERAGE(B1;B9)
D)=AVERAGE(B1:B9)

Question 34

What happens if you rename the source file of a worksheet that is used in an external reference?

A)The link will automatically update
B)A prompt to manually update the link appears
C)The linked data will appear in red text
D)The workbook will not open

Question 35

What error will cause #NUM! to appear?

A)Invalid arguments in a function
B)Misspelled name
C)Deleted cell reference
D)Invalid range name

Question 36

Which of the following is not a formula auditing tool?

A)Trace Precedents
B)Watch Window
C)Calculation Options
D)Trace Dependents

Question 37

What formula auditing tool can be used to control the data input from the user?

A)IFERROR
B)Data validation
C)Watch Window
D)Trace dependents

Question 38

What is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces;source and destination files are in the same folder.

A)''[WorkbookName]Worksheet''!Cell
B)[WorkbookName]Worksheet!Cell
C)'[WorkbookName]Worksheet'!Cell
D)Worksheet'!Cell

Question 39

Which function is best used to return a value if an error exists in a cell?

A)IF
B)GETERROR
C)IFERROR
D)VALIDATE

Question 40

What is indicated by blue arrows when tracing precedents?

A)Cells with errors
B)Cells with validation rules
C)Cells with no errors
D)Cells with comments

Question 41

The VLOOKUP function can be used to create a 3-D formula.

Question 42

Dependent cells contain formulas independent of other cells.

Question 43

Worksheets can be hidden to help manage available screen space when dealing with large files.

Question 44

Conditional formatting can be applied to a set of grouped worksheets.

Question 45

3-D formulas automatically update when data is added.

Question 46

When worksheets are grouped all structural changes will be copied across worksheets.

Question 47

When arranging windows,tiled is not an option.

Question 48

To remove a hyperlink,right-click it,and then select Link Options.

Question 49

The #NUM! error indicates an invalid argument used in a function.

Question 50

By default,Excel creates absolute cell references in external references.

Question 51

When opening a second window of the current workbook :2 will appear after the title.

Question 52

OctoberSales.xlsx is an example of CamelCase notation.

Question 53

The split bar gives the user the ability to view two different workbooks simultaneously.

Question 54

Images can be used as hyperlinks

Question 55

A 3-D reference is a pointer to a cell in another worksheet.

Question 56

A hyperlink cannot be used to access an e-mail address.

Question 57

Unvisited hyperlinks appear blue with a blue underline.

Question 58

If the destination file is closed when you change data in the source file,the destination file does automatically update to match the source file.

Question 59

The IFERROR function will perform an action if the current value in a cell produces an error.

Question 60

The #DIV/0! error indicates a misspelled word in Excel.

Question 61

________ is the process of dividing a worksheet window into two or four resizable windows.

Question 62

The error ________ will display when an invalid argument is used in a function.

Question 63

When a worksheet is split,any changes made to one pane updates the entire worksheet.

Question 64

When worksheets are grouped ________ appears in the title bar.

Question 65

By default automatic updates of links are ________.

Question 66

If a workbook that is referenced is lost or moved the error ________ will be displayed.

Question 67

NovemberFile.xlsx is an example of ________.

Question 68

By default automatic updates of links are disabled.

Question 69

The error ________ will display when a formula attempts to divide a value by zero or an empty cell.

Question 70

________ is the process of selecting two or more worksheets.

Question 71

''[South Bend.xlsx]Qtr3''!A1 is an example of a (n)________.

Question 72

________ errors occur because a formula or function violates correct construction,such as a misspelled function name or illegal use of an operator.

Question 73

When a stop is chosen as the error style using data validation,the user will not be able to continue.

Question 74

A________ is a pointer to a cell in another worksheet.

Question 75

A ________ is an electronic marker that connects to another location.

Question 76

The Watch Window will update as user defined cells change.

Question 77

________ is/are not supported when worksheets are grouped.

Question 78

If defined by the user,an optional ________ appears when the mouse pointer hovers over a hyperlink.

Question 79

________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.

Question 80

When information is chosen as the error style using data validation,the user will be able to input the incorrect data.