Question 1

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

Accepted Answer

3-D reference

Question 2

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

Accepted Answer

destination

Question 3

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

Accepted Answer

View

Question 4

Match between columns
                        Premises: Formats
Grouped
Contents
Ungroup
Fill Across Worksheet

Accepted Answer

The Answer of The values and formulas typed in cells. is...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

You can apply uniform page layouts to grouped worksheets.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Watch Window
3-D Reference
IFERROR
Circular Reference
Data validation

Accepted Answer

The Answer of Specifications on what type of data is is...

Question 8

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

Accepted Answer

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

Question 9

Match between columns
                        Premises: B3
'[International Falls.xlsx]Qtr 3 Sales'!A1
[mineapolis.xlsx]Qtr3!A1
'[St Paul.xlsx]Qtr3'!A1
'C:\Data[Minneapolis.xlsx]Sheet1'!A1

Accepted Answer

The Answer of Cell reference in the same worksheet. and is...

Question 10

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

Accepted Answer

Synchronou

Question 11

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

Accepted Answer

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

Question 12

Hyperlinks must link to websites.

Accepted Answer

A) True 
 B)False

Question 13

To edit or remove a hyperlink ________.

Accepted Answer

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

Objects such as charts cannot contain hyperlinks.

Accepted Answer

A) True 
 B)False

Question 15

The Fill Across Worksheets command is ________.

Accepted Answer

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

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

Accepted Answer

#DIV/0,div

Question 17

A Warning error style prevents the user from entering invalid data.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

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

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

You can apply uniform page layouts to grouped worksheets.

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

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

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

Hyperlinks must link to websites.

To edit or remove a hyperlink ________.

Objects such as charts cannot contain hyperlinks.

The Fill Across Worksheets command is ________.

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

A Warning error style prevents the user from entering invalid data.

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

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

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 9: Multiple-Sheet Workbook Management

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

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

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

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

You can apply uniform page layouts to grouped worksheets.

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

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

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

Hyperlinks must link to websites.

To edit or remove a hyperlink ________.

Objects such as charts cannot contain hyperlinks.

The Fill Across Worksheets command is ________.

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

A Warning error style prevents the user from entering invalid data.

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

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

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters