Deck 10: Troubleshooting Workbooks and Automating Excel Applications

Question 1

Most of Excel's error-checking rules are disabled by default.

Answer 1

False

Question 2

You click the Circle Invalid Data command on the Data Validation menu to find and mark cells containing data that does not meet validation criteria.

Answer 2

True

Question 3

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

Answer 3

True

Question 4

Cell formula printouts also serve as a backup for workbooks.

Question 5

You can create an Excel macro by using the macro recorder to record your keystrokes and mouse actions as you perform them.

Question 6

By default, every cell in a worksheet is unlocked.

Question 7

EPS is calculated by dividing the number of shares outstanding by net income.

Question 8

Excel assumes that any text in a formula is either a command word, such as a function name, or a reference to a cell, such as a named range.

Question 9

A virus can harm your computer by changing your program settings, for example, or deleting files on your hard disk.

Question 10

The Data Validation Rule called Text length restricts formulas to a specified length.

Question 11

To achieve a gross profit, an item's COGS should always be less than the sales price.

Question 12

Hiding a row or column affects the data and any formulas that reference a hidden cell.

Question 13

For optimal password security, Microsoft recommends that you always assign a password to open and view a file.

Question 14

Displaying an input message when a user clicks a cell is a helpful way to let the user know what type of data to enter in the cell.

Question 15

The formula auditing tool called Evaluate Formula displays the different parts of a nested formula, evaluated in the order the formula is written.

Question 16

A trusted location is usually any computer that is used only by one person.

Question 17

When you trace dependent cells, you trace the components of a formula that references other cells.

Question 18

Documentation can be descriptions of the system, checklists, flowcharts, and other hard-copy documents, as well as notations built into the system itself.

Question 19

If you double-click the cell containing a formula with an error, Excel displays color-coded borders around related cells.

Question 20

The data validation tool restricts data being entered and data already stored in the worksheet.

Question 21

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

Question 22

To prevent users from storing inaccurate data in a worksheet, you can include a(n) ____.

A) error alert message
B) worksheet protection message
C) file protection message
D) error detection warning

Question 23

When #DIV/0! appears in a cell, you know that a formula is trying to divide by the value 10, which cannot be done. _________________________

Question 24

A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________

Question 25

If you do not want others to view data in a worksheet but you want to retain the information, you can freeze a row or a column. _________________________

Question 26

False positives are items that are incorrect but are not flagged as such. _________________________

Question 27

To help minimize the errors users make as they enter data into worksheets, Excel provides a ____ tool.

A) data validation
B) data
C) data message
D) data-entry

Question 28

A(n) ____ rule can specify a range of acceptable values, such as those between 1 and 100 or those in a particular list of values.

A) validation
B) error
C) data
D) input

Question 29

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

A) input
B) error
C) data
D) data table

Question 30

The formula auditing tool called Internal References allows you to step through a set of cells that directly or indirectly refer to themselves. _________________________

Question 31

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

Question 32

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

Question 33

An error alarm is a message box that displays a message of varying severity. _________________________

Question 34

You access the data validation tool by clicking the DATA tab on the ribbon, and then clicking Data Validation in the ____ group to open the Data Validation dialog box.

A) Data Tools
B) Data
C) View
D) Formulas

Question 35

You should protect your entire workbook file with a(n) passkey for optimal security. _________________________

Question 36

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

Question 37

Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________

Question 38

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

Question 39

A(n) dependent cell uses the value in the active cell in its formula. _________________________

Question 40

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) output message that identifies the kind of data the user should enter. _________________________

Question 41

Which of the following is NOT one of the three available error alert styles for a cell?

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

Question 42

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

A) a second password
B) the same password
C) no password
D) a Microsoft-assigned password

Question 43

To allow users to edit some cells while preventing them from changing others, you ____ the cells you want users to access and then protect the worksheet.

A) unlock
B) lock
C) protect
D) unprotect

Question 44

Protect and uprotect a workbook using the ____ dialog box.

A) Protect Structure and Windows
B) Data Validation
C) Protect Sheet
D) Format Cells

Question 45

To reinforce the ____ rule, you can set up an error alert message for a cell.

A) validation
B) step-through
C) data
D) input

Question 46

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

A) you have specified
B) Excel enters as a default
C) new users enter
D) none of the above

Question 47

Which of the following is NOT one of the three tabs in the Data Validation dialog box?

A) Settings
B) Input Message
C) Error Alert
D) Audit

Question 48

To prevent data errors, you can ____ a workbook, which lets you control the changes users can make to it.

A) protect
B) save
C) guard
D) secure

Question 49

You can protect a workbook by ____.

A) locking cells so that users cannot change their contents
B) hiding cells so that users cannot see them
C) preventing a worksheet from being deleted from a workbook
D) all of the above

Question 50

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

A) worksheet protection
B) workbook protection
C) file protection
D) data table protection

Question 51

The data validation rule called ____ value is the default setting for cells.

A) Any
B) Whole number
C) Decimal
D) List

Question 52

Using only a validation rule without ____ can frustrate users of the worksheet.

A) an input message
B) an error alert message
C) either a or b
D) neither a nor b

Question 53

You can use ____ even for cells that allow any data values to be entered in them.

A) input messages
B) data messages
C) help messages
D) cell messages

Question 54

When you protect a workbook, you can secure the ____.

A) workbook structure
B) workbook windows
C) both a and b
D) neither a nor b

Question 55

If you protect a worksheet, users cannot change ____.

A) any data
B) any formulas
C) both a and b
D) neither a nor b

Question 56

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

A) workbook
B) worksheet
C) data table
D) user data

Question 57

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.

A) Data Validation
B) Formulas
C) Data
D) View

Question 58

By default, input messages appear as comments ____ when the cell is selected.

A) next to the cell
B) under the cell
C) on top of the cell
D) within the cell

Question 59

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

A) error alert
B) alarm
C) caution
D) stop and look

Question 60

When a workbook's structure is protected, users cannot ____ worksheets.

A) insert
B) delete
C) rename
D) all of the above

Question 61

____ tracer arrows point to another cell that provides data for the active cell.

A) Blue
B) Yellow
C) Green
D) Orange

Question 62

It is best to include a workbook's filename, worksheet name, and date on cell formula printouts that are used for documentation. The worksheet's ____ is a handy location for this kind of information.

A) header or footer
B) filename
C) range name
D) first column

Question 63

A #VALUE! error in a worksheet cell indicates ____.

A) the wrong argument type or operand
B) an incorrect formula
C) a circular argument
D) the cell needs to be widened

Question 64

The following types of documentation are helpful in an Excel application: ____.

A) step-by-step instructions for entering data and performing calculations
B) notes or comments that define terms, explain calculations, and describe assumptions
C) notes or comments that identify the source of data, such as another workbook, a database, or a Web page
D) all of the above

Question 65

The ____ on the blue tracer arrow indicate that certain cells are precedent cells for other cells.

A) solid circles
B) open circles
C) solid triangles
D) open triangles

Question 66

You can immediately fix the #### error by ____.

A) widening the column
B) increasing the height of a row
C) changing the formula
D) running spellcheck

Question 67

To unprotect a workbook, on the REVIEW tab on the ribbon, click the Protect Workbook button in the ____ group, and then deselect the necessary check boxes.

A) Changes
B) Format
C) What-if
D) Data

Question 68

____ tracer arrows indicate that a precedent cell contains an error.

A) Blue
B) Red
C) Green
D) Orange

Question 69

The formula auditing tool called ____ toggles between displaying formulas or results of formulas in the worksheet.

A) Show Formulas
B) View Formulas
C) Trace Dependents
D) Watch Window

Question 70

The error message #NAME? indicates ____.

A) unrecognized text in a formula
B) not enough column space for text
C) a name is required
D) an unrecognized name in a cell

Question 71

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

A) documentation
B) detailed
C) data table
D) protected

Question 72

When text is included inside quotation marks, it is treated as a ____.

A) text string
B) formula
C) value
D) function

Question 73

Backups of important Excel files should be stored or maintained _____.

A) on the computer's desktop
B) anywhere on the computer's hard disk
C) on a server that is backed up regularly
D) only as a hard copy

Question 74

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

A) structure
B) behavior
C) both a and b
D) neither a nor b

Question 75

If a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display the ____ button.

A) Error Alert
B) Error Help
C) Error Wizard
D) Error Warning

Question 76

When printing worksheet formulas, especially for the purposes of documentation, it is very helpful to set the print options to ____.

A) print the row and column headings
B) portrait orientation
C) both a and b
D) neither a nor b

Question 77

You can press the ____ keyboard combination to display the formula in the cell.

A) Ctrl+`
B) Ctrl+F8
C) Ctrl+Tab
D) Ctrl+&

Question 78

An Error Alert button appears on tracer arrows and ____.

A) names the type of error
B) lets you access the Excel Help tool
C) lets you edit the formula in the Formula Bar
D) all of the above

Question 79

Common formula errors include ____.

A) using mixed cell references in a formula
B) multiplying a cell's value by 0
C) using a defined name in a table
D) problems with order of precedence

Question 80

To read a comment, you point to a cell with ____ to display its comment.

A) an indicator
B) an error message
C) a border
D) shading