Page 428 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Related Exercises:
1 You are reviewing a complex financial model and want to trace precedents to understand how a particular
calculation is derived. Perform the following tasks:

• Identify a cell containing a formula that you want to audit.
• Use the “Trace Precedents” feature in Excel to visually trace the cells that contribute to the formula’s
calculation.

• Document the path of precedents to understand the formula’s logic.
2 You are troubleshooting errors in a large dataset and suspect that circular references may be causing incorrect
calculations. Perform the following tasks:

• Use the “Error Checking” feature in Excel to check for circular references within the worksheet.
• If circular references are found, analyze the affected cells to identify and resolve the circular dependency.
3 You are verifying the accuracy of a financial report and want to identify any external references to cells in other
workbooks. Perform the following tasks:

• Use the “Workbook Audit” feature in Excel to audit external references to cells in other workbooks.
• Review the list of external references and ensure that they are accurately referencing the intended data
sources.

4 You are collaborating on a spreadsheet with multiple colleagues and want to track changes made by each
user. Perform the following tasks:
• Enable the “Track Changes” feature in Excel to track changes made to the workbook by different users.

• Review the change history to identify who made specific changes and when they were made.

413
CITS : IT & ITES - Computer Software Application - Exercise 69 CITS : IT & ITES - Computer Software Application - Exercise 69