A hospital infection control nurse needs to present how the facility's healthcare-associated infections break down by type (surgical site, catheter-related bloodstream, urinary tract, pneumonia, and C. difficile) to illustrate each category's share of the total infection count at a safety committee meeting. Which chart type is MOST appropriate?
A pharmacy technician maintains a prescription log in Excel where column D contains the medication status (Active, Discontinued, On Hold, or Expired). The supervising pharmacist asks for the total number of prescriptions currently marked "Discontinued." Which formula correctly accomplishes this?
A rehabilitation center director builds a combination chart displaying the number of physical therapy sessions completed each quarter as columns on the primary axis and the average patient satisfaction score as a line on the secondary axis. What is the PRIMARY advantage of using a combination chart instead of two separate charts?
A home health agency supervisor examines a line chart showing monthly patient fall incidents over the past year. The data reveals a steady rate of 8-10 falls per month from January through September, a sudden drop to 2 falls in October, then a sharp rise to 18 falls in November and 20 in December. Which interpretation is BEST supported?
A dental clinic's practice management database uses a unique Claim_ID for every insurance claim submitted in the Claims table. Which statement BEST describes the function of a primary key like Claim_ID?
An urgent care physician is treating a patient who is visiting from another state and cannot recall the names of her current medications. The physician needs to pull the patient's active medication list from her home-state provider's EHR system in real time. Which form of Health Information Exchange (HIE) enables this scenario?
A behavioral health clinic's IT manager sets up the electronic records system so that the billing department can view diagnosis codes and procedure dates but CANNOT open therapy session notes or psychologist assessments. Which HIPAA-related concept does this configuration implement?
A laboratory technician has formatted a specimen tracking spreadsheet as an Excel Table with columns for Specimen_ID, Patient_Name, Test_Ordered, and Result. When the technician enters a new specimen record directly beneath the last row of the table, what happens automatically?
A nursing scheduler has a list of Nurse_IDs in column A and needs to pull each nurse's certification level from a master staffing table called NurseRoster. Which XLOOKUP formula correctly retrieves the certification level for the Nurse_ID in cell A2, displaying "No Match" if the ID is not found?
A hospital revenue cycle manager creates a PivotTable from 22,000 billing records. The CFO wants to see total reimbursements by payer (rows) and service line (columns), with the option to filter the entire report to show only a specific fiscal quarter. Where should the manager place the Fiscal_Quarter field?
A healthcare administrator needs to compare the top 15 diagnosis codes by frequency. The diagnosis code names are long (e.g., "Acute Upper Respiratory Infection, Unspecified"). Which chart type best accommodates long category labels?
In a healthcare database, the Patients table has a primary key of Patient_ID. The Visits table contains a Patient_ID column that references the Patients table. What is the Patient_ID column in the Visits table called, and what type of relationship does it create?
A clinic billing manager has a spreadsheet of 2,000 patient charges sorted by department. She wants to see a subtotal of charges for each department without creating a PivotTable. What must she do BEFORE using the Subtotal feature?
A healthcare data analyst is deciding between VLOOKUP and XLOOKUP to retrieve patient information. Which is a key advantage of XLOOKUP over VLOOKUP?
TRUE or FALSE: In a healthcare organization, the Laboratory Information System (LIS) receives test orders from the EHR, processes the lab work, and sends results back to the EHR for the provider to review.