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.

---

Definitions:

Midterm

A type of examination or assessment typically given halfway through an academic term to measure students' understanding and knowledge in a specific course.

Final Exam

A comprehensive test given at the end of an academic course or term, assessing a student's understanding and knowledge of the covered material.

Mode

The most frequently occurring value in a given set of data.

Central Tendency

A statistical measure that identifies the center of a data set, represented by the mean, median, or mode.