Multiple Choice
A manager prepared a spreadsheet to calculate employee wages. After pressing Ctrl+~, the formula view (shown below) appeared. What issues should be addressed on this spreadsheet?
A) Data should be entered only once.
B) Simple formulas should be used rather than complex Excel functions.
C) Absolute references should be used.
D) Data should be entered only once and simple formulas should be used rather than complex Excel functions only.
E) Data should be entered only once, simple formulas should be used rather than complex Excel functions and absolute references should be used.
Correct Answer:

Verified
Correct Answer:
Verified
Q38: Before staring work on a spreadsheet, Julie
Q39: When building a model, it is often
Q40: A spreadsheet modeler is creating a spreadsheet
Q41: In the example shown below, cell B3
Q42: The auditing tools can be used to
Q44: Which of the following actions will toggle
Q45: Data (for example, prices or costs) should
Q46: A student is using a spreadsheet to
Q47: When testing a spreadsheet model by entering
Q48: Which of the following tips can be