1 AC# 2 A11 3 A22 4 A6 5 A20 6 B6 7 C5 8 D4 9 D1 PATIENT NAME Eva Wong Pat Luise King Kong John Joe Tom Cruise Raj Kumar Jones Ki Wong Li Balance APPT DATE LAB TEST $15.00 2/26/2022 BLOOD $25.00 3/25/2022 EKG $35.00 4/5/2022 MRI $45.00 2/2/2020 URINE $55.00 6/1/2022 CBC $65.00 8/8/2022 XRAY CHEST $75.00 10/10/2022 BLOOD $85.00 2/3/2022 EKG RESULTS POSITIVE NEGATIVE POSITIVE NEGATIVE POSITIVE NEGATIVE POSITIVE NEGATIVE 10 Q2. AC# LAB TEST 11 Q1. 12 AC# 13 Balance 14 15 Q3. 16 AC# 17 RESULTS 18 Q4. AC# APPT DATE Q4. Q2. 12 ACH AC# 13 Balance LAB TEST 14 15 Q3 16 ACH ACH 17 RESULTS 18 APPT DATE 19 NOTE: 20 USE =VLOOKUP FUNCTION IN CELL B13, F13, B17 AND F17. 21 MAKE SURE CHANGE B13 CELL TO CURRENCY FORMAT AND F17 CELL TO DATE FORMAT 22 23 24 25 26 27 28 29 30