Ray is a MSN student working on a spreadsheet for class. He keeps getting error messages when entering his data and trying to make formulas work. He turns to his roommate, Jacques, in frustration. Ray knows spreadsheets have a variety of uses in nursing and have been adopted in the delivery of nursing care, so he needs to master them. Jacques proceeds to help Ray with the issue, educating him about spreadsheets in the process.
a. What are the common quantitative errors associated with spreadsheets that Jacques should mention to Ray?
b. What cause and methods should Jacques mention Ray could use to manage these errors?
