Solved

A Student Is Using a Spreadsheet to Calculate Her Monthly

Question 46

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 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.


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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions