Multiple Choice
A student is using a spreadsheet to calculate her monthly surplus/deficit as well as annual income. 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) Range names should be used.
D) Absolute references should be used.
E) No problems exist on this spreadsheet.
Correct Answer:

Verified
Correct Answer:
Verified
Q41: In the example shown below, cell B3
Q42: The auditing tools can be used to
Q43: A manager prepared a spreadsheet to calculate
Q44: Which of the following actions will toggle
Q45: Data (for example, prices or costs) should
Q47: When testing a spreadsheet model by entering
Q48: Which of the following tips can be
Q49: A spreadsheet modeler is creating a spreadsheet
Q50: In the example shown below, cells B7
Q51: In the spreadsheet shown below, changing the