A Manager Prepared a Spreadsheet to Calculate Employee Wages

question 43

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.