Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A warning error style may prompt the user that their input may not be correct, but it does not prevent them from entering invalid data. It is usually used to inform the user about a potential issue or mistake.

Question 3

Formula auditing replaces known errors with alternate values.

Accepted Answer

Formula auditing helps to identify and trace errors in formulas, but it does not replace them with alternate values. It is up to the user to correct the errors manually.

Question 4

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

Accepted Answer

A run-time error occurs during the execution of a program, due to problems like division by zero, accessing invalid array indexes, or running out of memory, not because of syntax errors in formulas or functions.

Question 5

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

Accepted Answer

A Watch Window displays the values of specified variables or expressions during the execution of a program, but not the intermediary steps of a function.

Question 6

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

Accepted Answer

A logic error occurs when a formula or statement contains an error in its logic, such as using an incorrect value or reference.

Question 7

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

Accepted Answer

To set up a Watch Window in Excel, you need to click on the "Formulas" tab, not the "Data" tab, and then select "Watch Window".

Question 8

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

Accepted Answer

Input messages are used to provide instructions to the user about data validation. They typically provide information on the expected format or type of data, as well as any restrictions or requirements on how the data can be entered. They help to ensure that data is entered correctly and consistently, improving the accuracy and usefulness of the data.

Question 9

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

Accepted Answer

Excel allows users to customize the messages that appear when a data validation error occurs, rather than determining them automatically.

Question 10

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 11

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

Accepted Answer

The Answer of Invalid numerical value in a function or is...

Question 12

Match between columns
                        Premises: Formula auditing
Logic error
Circular reference
Syntax error
Run-time error

Accepted Answer

The Answer of Occurs when a formula or function violates is...

Question 13

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 14

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

Accepted Answer

The Answer of Referencing worksheet names As part of a is...

Question 15

Match between columns
                        Premises: Side by Side
Synchronous Scrolling
Tiled
Split Window
Hide

Accepted Answer

The Answer of Two worksheets beside each other and they is...

Question 16

Match between columns
                        Premises: Objects
Underlined blue text
Hyperlink
ScreenTip
Underlined purple text

Accepted Answer

The Answer of Text balloon which displays when you hover is...

Question 17

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

Accepted Answer

The Answer of Returning to working with only one worksheet. is...

Question 18

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

Quiz 9: Multiple-Sheet Workbook Management

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

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

Formula auditing replaces known errors with alternate values.

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

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

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

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

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

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

Match each of the following concepts to its best description

Match each of the following errors to the problems which causes it:

Match each of the following concepts to its best description:

Match each of the following references to its best description:

Match each of the following concepts to its best description:

Match each of the following concepts to its best description:

Match each of the following terms to its best description relating to hyperlinks:

Match each of the following terms to its best description of its purpose:

Match each of the following concepts to its best description: