Open Response Excel Steps

Anonymous
timer Asked: Dec 19th, 2018
account_balance_wallet $30

Question Description

The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please describe each of these steps and also the formula auditing tools: Trace Precedents, Trace Dependents, Trace Error and Evaluate Formula.

Describe in as simple terminology as possible no need for proper grammar just simple open response form for an answer. maybe a 100 word response nothing crazy just steps.

Tutor Answer

Juniper
School: Cornell University

Hello buddy, kindly find your paper attached below. Let me know what you think. Thank you

Running Head: FORMULA AUDITING TOOLS IN EXCEL

Formula auditing tools in excel
Name
Institution

1

FORMULA AUDITING TOOLS IN EXCEL

2

Formula auditing tools in excel

Formula auditing tools are tools that are used to display the relationship between
formulas and cells. Before using the formula auditing tools, there are three important steps to
follow. The first step is to fix the obvious errors which include the following six common errors;
the #### error which means lack of enough space to display the value and corrected by
increasing the cell. The #NAME? error that is due to the use of non-existing function and can be
corrected by using the correct spelling. The #DIV/0! Error is caused by the division of a number
by zero which is impossible and the #NULL! Error is due to syntax error of the formula. The
#REF! error is caused by the use of an invalid reference cell and the #VALUE! error is due to the
use of cells with different data types. The second step is the use of the error alert button which
will display the error message when the user enters the data against the validation. Error alert
button is created by use of the data validation in the data menu so that it informs the user there is
an error by displaying the button and peeping sound. The last step is to examine the formula to
ensure all the necessary parts are available. These parts include functions which are predefined
formulas, correct references that point to the intended individual cell or range of cells, constants
numbers or text values entered and correct operators used.

The available formula auditing tools include: Trace Precedents which are used to display
arrows that indicate which cells are used to calculate the values; Trace Dependents which are
used to display arrows that indicate which cells are dependent on the selected cells; Trace Error
which is used to check the common errors that occur in the formulas; and Evaluate Formula
which is used to debug the formula by individually evaluating each part of the formula.

Hello buddy, kindly find your paper attached below. Let me know what you think. Thank you

Running head: HOME INSPECTION BUSINESS

Home Inspection Business
Student’s Name
Institutional Affiliation
Date

1

HOME INSPECTION BUSINESS

2

Target Market Location
The target location for our home ...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors