Solved

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


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:

verifed

Verified

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

Related Questions