Question 1

What is a 3-D reference?

Accepted Answer

A) A data cube function 
B) A reference to multiple cells 
C) A circular reference to the cell 
D) A cell reference to another worksheet 
A) A data cube function 
B) A reference to multiple cells 
C) A circular reference to the cell 
D) A cell reference to another worksheet D

Question 2

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 D

Question 3

A(n)________ accepts invalid data but warns the user that the data are invalid.

Accepted Answer

Warning

Question 4

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

How do you determine if a worksheet is grouped?

Accepted Answer

A) The tabs of all grouped worksheets are yellow. 
B) A padlock icon appears on the title bar. 
C) An icon of stacked paper displays on each tab. 
D) [Group] displays in the title bar 
A) The tabs of all grouped worksheets are yellow. 
B) A padlock icon appears on the title bar. 
C) An icon of stacked paper displays on each tab. 
D) [Group] displays in the title bar

Question 7

To set up a Watch Window, Click Watch Window on the Data tab.

Accepted Answer

A) True 
 B)False

Question 8

A run-time error occurs because a formula or function does not follow the rules of construction.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

Excel determines the messages returned when a data validation error occurs.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

The Answer of Determines if an error is present and is...

Question 13

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 14

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1, what happens in Sheet 2?

Accepted Answer

A) No change happens. 
B) Sheet 2 B3 has the same formula. 
C) A warning appears, warning you not to make changes in grouped sheets. 
D) Formatting will change on Sheet 2, but not formulas. 
A) No change happens. 
B) Sheet 2 B3 has the same formula. 
C) A warning appears, warning you not to make changes in grouped sheets. 
D) Formatting will change on Sheet 2, but not formulas.

Question 15

A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) =AVERAGE(A1:A9) 
B) =avg(A1:A9) 
C) =AVERAG(A1,A9) 
D) =AVERAGE(A1;A9) 
A) =AVERAGE(A1:A9) 
B) =avg(A1:A9) 
C) =AVERAG(A1,A9) 
D) =AVERAGE(A1;A9)

Question 18

=SUM('1st Quarter:4th Quarter'!B4:B12)is a function using a 3-D reference.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The formula =B2*B7 is located in cell C7.Which cell is the dependent cell?

Accepted Answer

A) B2 
B) C7 
C) B3 
D) B7 
A) B2 
B) C7 
C) B3 
D) B7

What is a 3-D reference?

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

A(n)________ accepts invalid data but warns the user that the data are invalid.

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

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

How do you determine if a worksheet is grouped?

To set up a Watch Window, Click Watch Window on the Data tab.

A run-time error occurs because a formula or function does not follow the rules of construction.

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

Excel determines the messages returned when a data validation error occurs.

To edit or remove a hyperlink ________.

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

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1, what happens in Sheet 2?

A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.

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

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

=SUM('1st Quarter:4th Quarter'!B4:B12)is a function using a 3-D reference.

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

The formula =B2*B7 is located in cell C7.Which cell is the dependent cell?

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

What is a 3-D reference?

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

A(n)________ accepts invalid data but warns the user that the data are invalid.

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

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

How do you determine if a worksheet is grouped?

To set up a Watch Window, Click Watch Window on the Data tab.

A run-time error occurs because a formula or function does not follow the rules of construction.

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

Excel determines the messages returned when a data validation error occurs.

To edit or remove a hyperlink ________.

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

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1, what happens in Sheet 2?

A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.

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

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

=SUM('1st Quarter:4th Quarter'!B4:B12)is a function using a 3-D reference.

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

The formula =B2*B7 is located in cell C7.Which cell is the dependent cell?

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