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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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 Manager Prepared a Spreadsheet to Calculate Employee Wages