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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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 Student Is Using a Spreadsheet to Calculate Her Monthly