Microsoft Excel & APA Quiz | CI1000: Computer Basics for Healthcare Professionals | 55.0 Points | 11 Questions × 5 pts each
Topics: Excel Foundations, Formulas, Functions & APA Citation
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?
True or False: The cell reference $E$1 means that when you copy the formula to other cells, the reference to cell E1 will change based on its new position.
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 clinic office manager has a 500-row supply order spreadsheet and needs to find specific records. Which of the following can be accomplished using Excel's AutoFilter feature? (Select ALL that apply)
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?
The chart is linked and should update automatically.
The Word file is corrupted.
Excel and Word are incompatible versions.
The chart was embedded (not linked), so it contains an independent copy that does not update when the source changes.
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 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?
A billing specialist enters the formula =SUM(B2:B15) in Excel. What does the colon (:) signify in this range reference?
An APA title page for a healthcare report must include which of the following elements?