Question 1

A Split Window has three panes by default

Accepted Answer

A) True 
 B)False

Question 2

A method to validate copy and pasted data is ________.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The ________ is the file which holds...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

The Answer of External reference in which source workbook is is...

Question 10

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

Accepted Answer

The answer of To setup Split Windows, Synchronous Scrolling or...

Question 11

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

Accepted Answer

Synchronou

Question 12

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

Accepted Answer

The answer of ________ is the dependent cell with this...

Question 13

Match between columns
                        Premises: Input Message
Error Style
Data validation
Error Alert
Validation Criteria

Accepted Answer

The Answer of Message displayed when a user enters invalid is...

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

A Watch Window displays the value, formula, and location of cells in a separate window.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of If you're presenting a large workbook with...

Question 18

You can apply uniform page layouts to grouped worksheets.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

ScreenTip,

A Split Window has three panes by default

A method to validate copy and pasted data is ________.

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

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

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

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

The Fill Across Worksheets command is ________.

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

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

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

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

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

________ 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 Watch Window displays the value, formula, and location of cells in a separate window.

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

You can apply uniform page layouts to grouped worksheets.

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

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 9: Multiple-Sheet Workbook Management

A Split Window has three panes by default

A method to validate copy and pasted data is ________.

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

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

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

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

The Fill Across Worksheets command is ________.

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

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

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

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

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

________ 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 Watch Window displays the value, formula, and location of cells in a separate window.

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

You can apply uniform page layouts to grouped worksheets.

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

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

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters