Solving data problems
in Excel 365 with
verified solutions
1.Analyzes components of a formula to ensure they
function correctly
2.Identifies issues within a formula and explains
how to rectify them - answer 1.Evaluate Formula
2.Error Checking
Identify two options that describe the purpose of
the Watch Window tool in Excel 365. - answer -
Enables you to monitor formulas when working
across workbooks
-Allows you to keep an eye on cells as you update
other parts of a worksheet
You can use formula auditing tools to identify the
source of problems in Excel 365. Which tool helps
you identify which cells are affected by the value
of a selected cell in a worksheet? - answer Trace
Dependents
in Excel 365 with
verified solutions
1.Analyzes components of a formula to ensure they
function correctly
2.Identifies issues within a formula and explains
how to rectify them - answer 1.Evaluate Formula
2.Error Checking
Identify two options that describe the purpose of
the Watch Window tool in Excel 365. - answer -
Enables you to monitor formulas when working
across workbooks
-Allows you to keep an eye on cells as you update
other parts of a worksheet
You can use formula auditing tools to identify the
source of problems in Excel 365. Which tool helps
you identify which cells are affected by the value
of a selected cell in a worksheet? - answer Trace
Dependents