Advanced Excel & Databases Quiz | CI1000: Computer Basics for Healthcare Professionals | 50.0 Points | 10 Questions × 5 pts each
Topics: Charts, Data Visualization, EHR, HIPAA, VLOOKUP & PivotTables
A pharmacy manager has a spreadsheet with 3,000 medication records. Column D contains the status of each medication: "Active," "Discontinued," or "Recalled." She needs a quick count of how many medications have been discontinued. Which formula should she use?
A hospital quality director wants one chart that shows monthly patient satisfaction scores as a line and monthly complaint counts as bars. What is the primary advantage of using a combination chart for this?
It looks more visually appealing than two separate charts.
It allows three or more data series.
It allows comparison of two different data types (scores and counts) on a shared time axis with separate scales.
It automatically calculates trend lines.
A health information management intern is reviewing a hospital's patient database and notices that two different patients—Maria Garcia (DOB 03/15/1985) and Maria Garcia (DOB 11/22/1990)—were accidentally merged into a single record under MRN 10045678. Lab results, medications, and allergy information from both patients are now combined. Which database integrity principle was violated, and what is the MOST serious patient safety risk?
Referential integrity was violated; the main risk is billing errors due to duplicate insurance claims.
Entity integrity was violated; the main risk is that medications or allergies from one patient could be incorrectly applied to the other, causing a potentially dangerous adverse event.
Domain integrity was violated; the main risk is that the date of birth field contains an incorrect format.
User-defined integrity was violated; the main risk is that appointment scheduling conflicts will occur.
True or False: In a query-based Health Information Exchange (HIE), patient data is automatically pushed from one healthcare organization to another without a specific request.
A hospital HIPAA officer is designing access controls for the new EHR system. She wants to ensure that a billing clerk can see insurance information but not clinical notes, while a nurse can see clinical notes but not billing details. Which access control model follows the HIPAA "minimum necessary" principle?
A charge nurse has a patient assignment sheet in one workbook and a separate "NurseRoster" table in another workbook that maps Nurse_ID to certification level. She needs a formula in cell B2 that looks up the Nurse_ID in A2 against the NurseRoster table and returns the matching Cert_Level, or "No Match" if the ID is not found. Which formula is correct?
A hospital database administrator discovers that when she deletes a physician's record from the Providers table, all 2,400 patient appointment records linked to that physician through a foreign key are automatically deleted too. The appointments data is permanently lost. What design flaw caused this problem, and what should have been configured instead?
The primary key was set incorrectly; the Providers table should use auto-increment instead of the NPI number.
The foreign key relationship lacked a cascading delete restriction; the relationship should have been configured to SET NULL or RESTRICT on delete, preserving the appointment records.
The database used too many tables; all data should have been stored in a single flat table to prevent cascading issues.
The administrator should have backed up the data first; the cascading delete behavior is correct and expected.
A rural clinic's laboratory processes blood samples and manually re-enters results into the EHR by printing the LIS report and typing values into each patient's chart. Last month, a transcription error caused a patient's potassium level to read 3.5 mEq/L (normal) instead of the actual result of 8.5 mEq/L (critically high), delaying emergency treatment. Which system integration failure is the ROOT CAUSE of this error?
The EHR software has a bug that corrupts lab values during data entry.
The clinic lacks a bidirectional interface between the LIS and EHR, forcing manual re-entry that introduces transcription errors.
The laboratory technician did not follow proper quality control procedures during the blood test.
The patient's record was not properly authenticated with two-factor verification before the result was entered.
A health administrator uses VLOOKUP to find a patient ID in a table. The formula returns #N/A. What is the MOST likely cause?
Which Excel chart type is BEST for showing the trend of patient wait times over 12 consecutive months?