IT IS COMPUTER EXCEL QUESTION PLEASE ALSO WRITE FORMULAS
1st Image question, 2nd Database, 3rd Reference
STEP 1 From your email, open the excel sheet that was emailed to you from me. STEP 2 Save to your desktop and Rename the sheet as follows: ####### COMP45 13M FINAL [####### MEANS STUDENT NUMBER] (10) STEP 3. From REFERENCE sheet copy B2:B22 and paste into DATABASE SHEET E2:E22 AND From REFERENCE sheet copy C2:C22 and paste into DATABASE SHEET 12:122 (20) STEP 4. Perform the calculations in Col. F (10) STEP 5. Label the following columns J K L M N as follows J - SALES BASED ON CUSTOMER ORDERS ($) K- OVER/UNDER PRODUCTION (ITEM) L-PRODUCTION EFFICIENCE BASED ON PLANNED PRODUCTION (%) M - CURRENT INVENTORY (PROD+ON HAND-ORDERS)(ITEM) N-VALUE OF CURRENT INVENTORY ($) (50) STEP 6. Perform the calculations in Columns J K L M N (150) STEP 7. Perform Conditional Formatting in Col N (a) Inventory less than $10,000 - YELLOW fill (b) Between $100,001 and $199,999 GREEN fill and BOLD RED fonts (40) STEP 8. Cells A1 : N23 to have all borders (10) STEP 9. Label A23 BUSINESS GRAND TOTAL (10) STEP 10. Calculate ALL RELEVANT totals in row 23. Cells with no totals to be filled in BLACK (40) STEP 11. Answer the 2 questions found in Rows 25, 26 of the DATABASE SPREADSHEET, your answer to appear in the boxes provided. (40) STEP 12. Create a 3D CLUSTERED CHART for the information located in B1:D22 on the DATABASE SHEET. Display the chart in B28:M42 (40) STEP 13. Hide rows 4 to 20 (20) STEP 14. Your completed exam should now be a single view (database, answers and chart) (20) A1 fc PRODUCT CODE j K L M N 0 A B C D E F G . ON HAND PRODUCTION VALUE OF INVENTORY PLANNED END OF COST PER INVENTORY AT BEFORE CUSTOMER SELLING PRODUCT PRODUCT PRODUCTION PRODUCTION EACH ITEM END OF PRODUCTION ORDERS PRICE PER 1 CODE NAME (ITEM) (ITEM) ($) PRODUCTION ($) (ITEM) (ITEM) ITEM ($) 2 9952687 DROP CLOTHS 6000 5500 3000 1200 3 889542 BRUSHES 15000 15000 5000 3625 4 551247 CANS 12000 11000 2100 1125 5 66358 STEP LADDERS 1650 1650 3325 23 6 25874 ROLLERS 5200 5000 5478 546 7 2223568 APPLICATORS 1450 3000 9952 85 8 6658912 CLEANERS 61650 51245 3254 987 9 9952642 PAILS 1800 1750 11245 412 10 889497 PENS 9000 9000 2356 512 11 551202 TAPES 7550 8925 8521 652 12 66313 LEVEL 1200 1455 6654 3258 13 25829 PENCILS 3500 3250 9548 9214 14 2223523 MASKS 8900 8000 77452 225 15 6658867 COVERALL 12036 9000 2154 387 16 9952597 GLOVES 1686 2500 2256 935 17 889452 CAPS 5236 12000 9951 936 18 551157 SHIELDS 1486 6000 325 6321 19 66268 HANDLES 61686 2500 65873 524 20 25784 TRAYS 1836 18600 952 1125 21 2223478 HOLDERS 9036 5500 321 4125 22 6658822 SANDPAPERS 7586 15000 45621 8822 DATABASE REFERENCE + B $ 0.79 $ 4.99 $ 1.23 $ 8.07 $ 4.50 $ 29.00 $ 0.97 $ 6.50 $ 1.56 $ 9.80 $ 2.35 $ 14.95 $ 6.25 $ 40.00 $ 4.52 $28.99 $ 8.75 $ 56.00 $ 2.32 $ 15.66 $ 6.23 $ 40.25 $ 5.52 $ 35.95 $ 2.89 $ 19.25 $ 2.33 $ 15.75 $ 3.25 $ 21.55 $ 1.65 $12.00 $ 4.23 $ 27.95 $ 2.81 $ 18.00 $ 1.98 $ 13.00 $ 2.56 $ 16.55 $ 6.54 $ 42.50
