separator for the thousands Insert currency symbol in Ksh. Use an appropriate function to award the sales representatives managing the branches using the scale given below (4 Marks) 80,000 and above: GOLD 65,000 to 79,999 : SILVER 50,000 to 64,999 :BRONZE Below 50000: NO PRICE Use an appropriate function to establish the number of those awarded GOLD (2 Marks) Use a formula to calculate the monthly total sales for all the six months and re-save. (2 Marks) Prepare an appropriately labeled bar graph to show the Monthly TotalSales for the six months. Save the graph as a new sheet called RECORDS” (5 “MONTHLY Marks) . Print PROJ1, PROJ2, MONTHLY RECORDS and formulas in PROJ2, on one page each (5 Marks) END.
separator for the thousands Insert currency symbol in Ksh. Use an appropriate function to award the sales representatives managing the branches using the scale given below (4 Marks) 80,000 and above: GOLD 65,000 to 79,999 : SILVER 50,000 to 64,999 :BRONZE Below 50000: NO PRICE Use an appropriate function to establish the number of those awarded GOLD (2 Marks) Use a formula to calculate the monthly total sales for all the six months and re-save. (2 Marks) Prepare an appropriately labeled bar graph to show the Monthly TotalSales for the six months. Save the graph as a new sheet called “MONTHLY RECORDS” (5 Marks) . Print PROJ1, PROJ2, MONTHLY RECORDS and formulas in PROJ2, on one page each (5 Marks) END.
Comp%20pp2%20016.docx