Question 1

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

Accepted Answer

Blue tracer arrows indicate cells that provide data to the active cell, showing direct precedents in Excel.

Question 2

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.

Accepted Answer

The header or footer of a worksheet is the ideal location to include pertinent information such as the filename, worksheet name, and date. This information can be easily printed on every page of the workbook and helps to ensure that the documentation remains accurate and up-to-date.

Question 3

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

Accepted Answer

The #VALUE! error in Excel typically indicates that there's a problem with the way your formula is typed. This could mean that an argument or operand within the formula is of the wrong type, such as trying to subtract a text value from a number.

Question 4

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

Accepted Answer

All three types of documentation mentioned (step-by-step instructions, notes or comments defining terms and assumptions, and identifying the source of data) are helpful in an Excel application. Providing thorough documentation can help ensure that users understand how to properly use the application and its underlying data, ultimately leading to more accurate results and improved efficiency.

Question 5

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

Accepted Answer

Solid circles on the blue tracer arrow indicate that certain cells are precedent cells for other cells in Excel.

Question 6

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

Accepted Answer

Widening the column is the correct solution for fixing the #### error in spreadsheet programs, which occurs when the cell is not wide enough to display the content.

Question 7

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.

Accepted Answer

The "Changes" group includes options such as allowing users to insert/delete columns or rows and rename worksheets. Deselecting the necessary check boxes in this group will unprotect the workbook. The other options (B, C, and D) relate to specific types of protection and may not necessarily apply to the workbook in question.

Question 8

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

Accepted Answer

Red is commonly used as a color to indicate errors or issues in computer software or programs. Therefore, red tracer arrows would be the best choice to indicate an error in a precedent cell.

Question 9

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

Accepted Answer

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

Question 10

The error message #NAME? indicates ____.

Accepted Answer

The error message #NAME? in Excel and similar spreadsheet software indicates that there is unrecognized text in a formula, usually because Excel doesn't recognize a function name or named range.

Question 11

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.

Accepted Answer

A documentation worksheet is specifically used to store information about the workbook, such as the title, creation date, and creator name. This information is important for organizational purposes and for identifying the purpose and content of the workbook. The other choices do not fit this description.

Question 12

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

Accepted Answer

When text is included inside quotation marks in a cell, it is treated as a text string, which means it is a sequence of characters that is not interpreted as a formula or a function, but rather as plain text. This is useful when you want to enter text that includes special characters or symbols that may be misinterpreted by Excel as a formula or function.

Question 13

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

Accepted Answer

Backups of important Excel files should be stored on a server that is backed up regularly. Storing backups on the computer's desktop or anywhere on the hard disk can put the files at risk if the computer crashes or experiences data loss. Storing backups as a hard copy can also be risky as physical copies can get lost or damaged. Storing backups on a regularly backed-up server ensures that the files are protected even in case of a disaster.

Question 14

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

Accepted Answer

Excel formula auditing tools allow you to review both the structure and behavior of a formula, helping identify and fix issues.

Question 15

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

Accepted Answer

When a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display an Error Alert button. This button enables you to see the reason behind the error and offers suggestions to correct it.

Question 16

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

Accepted Answer

Printing the row and column headings helps in identifying and documenting the location of formulas within a worksheet, making it easier to understand and follow the structure of the document.

Question 17

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

Accepted Answer

Pressing Ctrl+` (grave accent key) keyboard combination will display the formula in the cell.

Question 18

An Error Alert button appears on tracer arrows and ____.

Accepted Answer

The Error Alert button on tracer arrows does all of the above- it names the type of error, lets you access the Excel Help tool, and lets you edit the formula in the Formula Bar.

Question 19

Common formula errors include ____.

Accepted Answer

Problems with order of precedence refer to mistakes in the order of operations in a formula. This can lead to incorrect calculations or results. While the other options can also result in errors in formula, they are not as common or significant as problems with order of precedence.

Question 20

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

Accepted Answer

Indicators are small red triangles in the upper right corner of a cell that contain a comment. Pointing to the indicator displays the comment. B, C, and D are not correct because they do not relate to displaying comments.

Quiz 10: Troubleshooting Workbooks and Automating Excel Applications