Question 1

View Side by Side locks two worksheets to scroll together.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

________ is not supported in grouped worksheets,but you can apply it to one and Fill it across other worksheets.

Accepted Answer

Conditiona

Question 8

A hyperlink in an Excel worksheet can do all of the following,except ________.

Accepted Answer

A) open a different workbook. 
B) switch to another worksheet. 
C) open a webpage. 
D) launch Word. 
A) open a different workbook. 
B) switch to another worksheet. 
C) open a webpage. 
D) launch Word.

Question 9

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

Accepted Answer

The Answer of Stop:Warning and Information and Rules that dictate is...

Question 10

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

Question 11

________ are the rules that dictate the type of data that can be entered in a cell.

Accepted Answer

A) Input message 
B) Validation criteria 
C) Error alert 
D) Defined item 
A) Input message 
B) Validation criteria 
C) Error alert 
D) Defined item

Question 12

Match between columns
                        Premises: #NAME?
#VALUE
#NUM
#REF
#DIV/0

Accepted Answer

The Answer of A cell was deleted or contents were is...

Question 13

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

Accepted Answer

A) Trace Precedents 
B) Trace Dependents 
C) Show Formulas 
D) Evaluate Formula 
A) Trace Precedents 
B) Trace Dependents 
C) Show Formulas 
D) Evaluate Formula

Question 14

A(n)________ reference occurs when a formula uses the cell which contains the formula.

Accepted Answer

The answer of A(n)________ reference occurs when a formula uses...

Question 15

Which of the following is an example of Pascal Case notation.

Accepted Answer

A) pascalCaseNotation 
B) PascalCaseNotation 
C) pascal_case_notation 
D) Pascal Case Notation 
A) pascalCaseNotation 
B) PascalCaseNotation 
C) pascal_case_notation 
D) Pascal Case Notation

Question 16

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 17

Which of the following is not an Error Style for data validation?

Accepted Answer

A) Stop 
B) Critical 
C) Warning 
D) Information 
A) Stop 
B) Critical 
C) Warning 
D) Information

Question 18

Which is not a method of removing a split?

Accepted Answer

A) Click Remove Split on the View tab. 
B) Double click on a split bar. 
C) Click and drag the horizontal split bar off the top of the window. 
D) Click and drag the vertical split bar off the left of the window. 
A) Click Remove Split on the View tab. 
B) Double click on a split bar. 
C) Click and drag the horizontal split bar off the top of the window. 
D) Click and drag the vertical split bar off the left of the window.

Question 19

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 20

An icon of stacked sheets displays on the tabs of grouped worksheets

Accepted Answer

A) True 
 B)False

View Side by Side locks two worksheets to scroll together.

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

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

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

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

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

________ is not supported in grouped worksheets,but you can apply it to one and Fill it across other worksheets.

A hyperlink in an Excel worksheet can do all of the following,except ________.

What is a 3-D reference?

________ are the rules that dictate the type of data that can be entered in a cell.

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

A(n)________ reference occurs when a formula uses the cell which contains the formula.

Which of the following is an example of Pascal Case notation.

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

Which of the following is not an Error Style for data validation?

Which is not a method of removing a split?

A method to validate copy and pasted data is ________.

An icon of stacked sheets displays on the tabs of grouped worksheets

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

View Side by Side locks two worksheets to scroll together.

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

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

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

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

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

________ is not supported in grouped worksheets,but you can apply it to one and Fill it across other worksheets.

A hyperlink in an Excel worksheet can do all of the following,except ________.

What is a 3-D reference?

________ are the rules that dictate the type of data that can be entered in a cell.

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

A(n)________ reference occurs when a formula uses the cell which contains the formula.

Which of the following is an example of Pascal Case notation.

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

Which of the following is not an Error Style for data validation?

Which is not a method of removing a split?

A method to validate copy and pasted data is ________.

An icon of stacked sheets displays on the tabs of grouped worksheets

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