Question 1

You can apply conditional formatting on grouped worksheets.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of When worksheets are grouped,[Group} appears in the...

Question 5

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

Accepted Answer

The answer of By default,automatic updates are ________ to protect...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following actions will open another window of the current workbook?

Accepted Answer

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

Input messages are instructions to the user about data validation instructions.

Accepted Answer

A) True 
 B)False

Question 9

If all worksheets are grouped,how do you ungroup them?

Accepted Answer

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

What does a green triangle in the upper left corner of a cell mean?

Accepted Answer

A) Precedent to another cell 
B) Source cell lost 
C) Potential syntax error 
D) Potential logic error 
A) Precedent to another cell 
B) Source cell lost 
C) Potential syntax error 
D) Potential logic error

Question 11

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 12

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

Accepted Answer

The answer of A(n)________ is best suited to monitor the...

Question 13

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 14

What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?

Accepted Answer

A) Copy and paste 
B) External cell references 
C) 3-D Formulas 
D) Splitting 
A) Copy and paste 
B) External cell references 
C) 3-D Formulas 
D) Splitting

Question 15

Match between columns
                        Premises: Camel Case Notation
3-D reference
Pascal Case Notation
!
'

Accepted Answer

The Answer of worksheetName and Referencing worksheet names As part is...

Question 16

How do you group all worksheets?

Accepted Answer

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

Formula auditing replaces known errors with alternate values.

Accepted Answer

A) True 
 B)False

Question 18

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

Accepted Answer

A) #NAME? 
B) #NULL! 
C) #NUM 
D) #REF 
A) #NAME? 
B) #NULL! 
C) #NUM 
D) #REF

You can apply conditional formatting on grouped worksheets.

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

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

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

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

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

Which of the following actions will open another window of the current workbook?

Input messages are instructions to the user about data validation instructions.

If all worksheets are grouped,how do you ungroup them?

What does a green triangle in the upper left corner of a cell mean?

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

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

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

What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?

How do you group all worksheets?

Formula auditing replaces known errors with alternate values.

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

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

You can apply conditional formatting on grouped worksheets.

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

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

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

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

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

Which of the following actions will open another window of the current workbook?

Input messages are instructions to the user about data validation instructions.

If all worksheets are grouped,how do you ungroup them?

What does a green triangle in the upper left corner of a cell mean?

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

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

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

What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?

How do you group all worksheets?

Formula auditing replaces known errors with alternate values.

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

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