Week 4 Assessment

A nurse manager tracks patient fall incidents across 12 months. She wants cells to automatically turn red when the fall count exceeds 5 in any month, so dangerous trends are immediately visible. Which Excel feature should she use?

A pharmacy inventory spreadsheet calculates the reorder cost by multiplying each drug's quantity (column D) by the unit price stored in cell E1. The formula in D2 is =D2*E1. When copied down to D3, D4, etc., the E1 reference must NOT change. How should E1 be written to lock it?

A health information technician has a spreadsheet of 2,000 patient records. She needs to determine how many records have a value in the "Date of Birth" column (column F). Empty cells should not be counted. Which function should she use?

A clinical dietitian tracks patient BMI values in column D. She wants a formula that displays "Obese" if the BMI in D5 is 30 or greater, and "Not Obese" otherwise. Which formula is correct?

A hospital purchasing agent has a spreadsheet of 500 supply orders. She needs to view only orders from Vendor "AlphaSupply" that are over $1,000 and marked "Pending." What is the most efficient approach?

A clinic manager embeds an Excel chart into a Word report. Later, the underlying Excel data changes, but the chart in Word still shows the old numbers. What does this behavior indicate about the object?

A pediatric clinic tracks infant weights in Excel. The data entry clerk sometimes types negative numbers or values over 216 (the maximum recorded infant weight in ounces). The supervisor wants Excel to reject any entry outside the range 0–216. Which feature should be applied?

A medical office needs to send personalized appointment reminder letters to 200 patients. The patient names, addresses, and appointment dates are stored in an Excel spreadsheet. The letter template is in Word. What is the best way to generate all 200 letters?

A health information technician exports patient data from the EHR as a .csv file and opens it in Excel. She notices that cell formatting, formulas, and the second worksheet tab from the original workbook are all missing. Why?

A medical billing specialist has a spreadsheet with patient charges in column E (rows 2 through 43). She needs two summary values: the total of all charges and the average charge per patient. Which pair of formulas correctly calculates both?