Question 1

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 2

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 3

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

Accepted Answer

Input messages are typically used to give instructions to the user regarding valid data formats or values that are acceptable for input. These messages can help prevent errors and improve the accuracy of the system.

Question 4

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 5

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

Accepted Answer

A Watch Window is a dialog box which displays the value of a variable or expression as it changes during the execution of a program or macro, not the intermediary steps of a function.

Question 6

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 7

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

Accepted Answer

A Warning error style alerts the user that the entered data may not be valid, but it does not prevent them from entering it. It is up to the user to decide whether to ignore the warning and submit the data.

Question 8

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

Accepted Answer

The answer of A logic error happens mostly because a...

Question 9

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

Accepted Answer

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

Question 10

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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

The Answer of Occurs when you use the wrong cell is...

Question 13

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

Accepted Answer

The Answer of Cell reference in the same worksheet. and is...

Question 14

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 15

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

Accepted Answer

The Answer of Use this to minimize the number of is...

Question 16

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

Accepted Answer

The Answer of Default formatting for a followed hyperlink and is...

Question 17

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

Accepted Answer

The Answer of The values and formulas typed in cells. is...

Question 18

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

Accepted Answer

The Answer of Specifications on what type of data is is...

Quiz 9: Multiple-Sheet Workbook Management

Formula auditing replaces known errors with alternate values.

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.

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

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

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

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

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

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: