One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.
A) values
B) formulas
C) both a and b
D) neither a nor b

Question

Quizplus · Accepted Answer

By printing the worksheet in a format that shows both the values and the formulas, it becomes easier to identify errors in the formula, such as incorrect cell references, misaligned arithmetic operations, or incorrect functions. Comparing the values with the formulas side by side can highlight inconsistencies and typos that might not be immediately visible on-screen. This can save time and effort in troubleshooting and identifying precisely where the formula error exists.

One Way to Determine Where an Error Might Exist in a Formula