Documenting and Auditing

Question 1

Complete the steps that can be used to trace errors in a worksheet.

Revolt · Accepted Answer

Click the tab.: Formulas; In the Formula Auditing group, click the down arrow on the button.: Error Checking; Choose .: Trace Error

Question 2

Data Review✔ Error Checking Tracing

Revolt · Accepted Answer

✔ Error Checking

Question 3

Analyze DataCorrect Text✔ Trace Error

Revolt · Accepted Answer

✔ Trace Error

Question 4

Complete the steps that can be used to trace errors in a worksheet.

Revolt · Accepted Answer

✔ Formulas; Click the tab.: Formulas; In the Formula Auditing group, click the down arrow on the button.: Error Checking; Choose .: Trace Error

Question 5

What does a red triangle in the corner of a cell indicate?

Revolt · Accepted Answer

There is a comment on the cell.

Question 6

Which tab should you click if you want to access the Show All Comments option in a worksheet?

Revolt · Accepted Answer

Review

Question 7

What are the steps for password-protecting a worksheet?

Revolt · Accepted Answer

Click the Review tab, then click Protect Sheet. Type the password, then re-enter the password.

Question 8

What are two options available for highlighting changes in the Highlight Changes dialog box?

Revolt · Accepted Answer

within a specific time period or by a specific user

Question 9

After clicking the File tab and then Info, what are the last steps for marking a workbook as final?

Revolt · Accepted Answer

Click Protect Workbook, then click Mark as Final.

Documenting and Auditing Answers