Deck 33: Multiple Sheet Workbook Management: Hands On Exercise Videos

Question 1

When linking to an external workbook,the workbook name is surrounded by single quotation marks.

Answer 1

False

Question 2

In the figure shown above,________.

A)A1 is a dependent cell and B1 is a precedent cell of D1
B)A1 is precedent cell and B1 is a dependent cell of D1
C)A1 and B1 are dependent cells of D1
D)A1 and B1 are precedent cells of D1

Answer 2

D

Question 3

A(n)________ window makes it possible to monitor cells not immediately visible on the screen.

A)Watch
B)Data
C)Observation
D)Inspection

Answer 3

A

Question 4

To examine multiple worksheets in the same workbook at the same time,you use New Window and Arrange All located on the ________ tab.

A)PAGE LAYOUT
B)VIEW
C)INSERT
D)DESIGN

Question 5

When worksheets are grouped,[Group] is displayed in the titles bar immediately after the file name.

Question 6

A hyperlink to a worksheet always references cell A1 of that worksheet.

Question 7

When creating a data validation rule,you can specify both input message and an alert.

Question 8

You would use ________ to monitor data input and display an appropriate message if a user enters erroneous data.

A)a data filter
B)conditional formatting
C)data validation
D)error checking

Question 9

Which of the following references is written incorrectly?

A)=[e09h2Indianapolis_LastFirst.xlsx]Yearly Totals!$F$3
B)="October Sales"!E3+"November Sales"!E3+"December Sales"!E3
C)="[e09h2Bloomington_LastFirst.xlsx]Yearly Totals"!$F$3
D)=SUM("Qtr1:Qtr4"!E3)

Question 10

When using Trace Precedents and Trace Dependents,tracer arrows display showing the relationship between cells and formulas.

Question 11

When referencing a worksheet in another workbook,the workbook name is enclosed in ________.

A)parentheses ( )
B)brackets [ ]
C)braces { }
D)double quotation marks " "

Question 12

In a 3-D reference,worksheets references are separated from their cell references by a(n)________.

A)single quotation mark (')
B)double quotation mark (")
C)exclamation mark (!)
D)period (. )

Question 13

To ungroup worksheets,right-click any one of the grouped worksheets' tabs and click Ungroup Sheets.

Question 14

To group adjacent worksheets,you:

A)click the first worksheet tab,press and hold Ctrl,and click the last worksheet tab.
B)click the first worksheet tab,press and hold Shift,and click the last worksheet tab.
C)click the first worksheet tab and double-click the last worksheet tab.
D)click the first worksheet tab and right-click the last worksheet tab.

Question 15

A formula that references itself is called a(n)________ reference.

A)absolute
B)reliant
C)circular
D)dependent

Question 16

When Excel detects an error in a formula:

A)the cell containing the formula is surrounded in a green border.
B)a green triangle is displayed in the top-left corner of the cell containing the formula.
C)the cell containing the formula is displayed with a light green fill.
D)the text in the cell containing the formula is displayed in bold green.