A pharmacy technician clicks on a cell containing a complex dosage calculation and notices the cell only shows the final number. She needs to see the full formula to verify it references the correct drug concentration cells. Which area of the Excel interface allows her to view the complete formula stored in the selected cell?
A health information technician is building a hospital readmission report. She enters 0.08 in a cell to represent the 8% readmission rate for the cardiology unit. Which number format should she apply so the cell displays "8%" instead of "0.08"?
A clinical lab manager maintains a spreadsheet of daily hemoglobin test results. She wants any value below 12.0 g/dL to automatically appear with a yellow background so technicians can quickly identify patients who may be anemic. Which Excel feature accomplishes this?
A dental office receptionist tracks patient co-pays in a spreadsheet. Column B lists each procedure's total charge, and cell E1 contains the fixed co-pay percentage (0.20). The formula in C2 is =B2*E1. When she copies it down to C3, it becomes =B3*E2, returning zero because E2 is empty. How should the receptionist fix the original formula so it copies correctly for all rows?
A physical therapy coordinator maintains a spreadsheet listing 80 patients scheduled for weekly sessions. Column D records the number of minutes each patient exercised; cells for patients who have not yet attended are left blank. The coordinator needs to know how many patients have completed at least one session. Which function returns the correct count?
A medical coder needs an Excel formula that displays "Obese" when a patient's BMI in cell D5 is 30 or higher, and "Not Obese" otherwise. Which formula uses the correct IF function syntax?
A hospital infection control specialist has a spreadsheet with 1,200 incident reports spanning all departments and the full calendar year. She needs to isolate only the surgical-site infections in the Orthopedics unit that occurred during Q3 (July–September). What is the MOST efficient approach?
A hospital quality assurance director embeds an Excel staffing-hours table into a PowerPoint slide deck for a board presentation. The next day, the HR department corrects several overtime figures in the original Excel workbook. What will the director see in the PowerPoint slide deck?
A pediatric nurse is building a vaccination log in Excel. The "Patient Age (months)" column should only accept whole numbers between 0 and 216 to prevent impossible entries from being recorded. Which Excel feature should the nurse apply to enforce this rule at the point of data entry?
A home health agency needs to mail personalized care plan summaries to the families of 200 patients. Each letter must include the patient's name, assigned nurse, visit schedule, and emergency contact number, all of which are stored in an Excel workbook. What is the most efficient way to produce these individualized letters?
A medical office assistant needs to enter the days of the week (Monday through Friday) across cells B1 to F1 for a weekly appointment schedule. What is the fastest way to do this in Excel?
A healthcare data analyst has a spreadsheet with 500 patient records. The column headers (Patient ID, Name, Date, Vitals, etc.) in row 1 scroll off-screen when viewing data in lower rows. What Excel feature keeps the headers visible while scrolling?
A lab technician exports patient test results from Excel to CSV format for upload to the clinic's database system. Which limitation of CSV files should the technician be aware of?
A healthcare billing specialist enters the formula =10+5*2 into an Excel cell. What value does Excel display?
TRUE or FALSE: When you link an Excel chart to a Word document using Paste Special > Paste Link, the chart in Word automatically updates whenever the original Excel data changes.