Question: do it in excel pls B D E F 1 BUSTAMANTE CLINICAL LABORATORY INC. LAS PINAS 2 3 4 Monthly Report 5 6 MEDTECH Particular

do it in excel pls B D E F 1 BUSTAMANTE CLINICALLABORATORY INC. LAS PINAS 2 3 4 Monthly Report 5 6 MEDTECHdo it in excel pls

B D E F 1 BUSTAMANTE CLINICAL LABORATORY INC. LAS PINAS 2 3 4 Monthly Report 5 6 MEDTECH Particular Price per Total Number of Patient Commission Rate 7 Piece Amount 8 9 10 11 1000 300 200 450 400 250 0.5 0.5 0.5 0.12 0.15 12 13 513 608 972 2555 608 513 608 972 2555 14 15 Jim Ross Bustamante Urinalysis Complete Blood Count Sodium and Potassium Tonized Calcium Fasting Blood Sugar Jaime Bustamante Urinalysis Complete Blood Count Sodium and Potassium Tonized Calcium Fasting Blood Sugar Jim Vincent Bustamante Urinalysis Complete Blood Count Sodium and Potassium Tonized Calcium Fasting Blood Sugar 16 200 300 400 500 0.5 0.5 0.5 0.12 0.15 17 18 608 19 1200 20 100 21 150 513 608 972 2555 608 0.5 0.5 0.5 0.12 0.15 22 200 500 23 24 ====== ======= 25 26 Overall Total: Minimum Value Maximum Value Total No. of Entries 27 28 29 39 40 41 42 3. Fomat of Data entries of the following columns with the given number format and alignment(6pts) Column Number format Dedmal Place Alignment A Left B Left C Number/comma 0 right D currency 2 right E percentage 0 center F currency 2 right 43 44 45 46 47 48 49 4. Compute Total amount=Number of patient * Price per unit (2pts) 5. Find the value of the following overall total, minimum & maximum value, Total no. of entries. (Place the value on the blank) (3pts) 6. Resign column width id necessary and add enhancement to make it presentable.(2pts) 7. Overall output presentation. (correct format, computation and enhancement). Add enhancement to make it more presentable. (10pts) 50 51 52

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!