Question: 270 Type the information below in a suitable spreadsheet. MONTHS SALE REP January Karen Brown Roy Black February March Dave Green April Paul Blake May

270 Type the information below in a suitable spreadsheet. MONTHS SALE REP January Karen Brown Roy Black February March Dave Green April Paul Blake May June Marlene Walker Damion Hunter Simone Porter July August Marie Gordon September Norma Whyte October Thaunelle Anderson November Latoya Jackson December Zoya Taylor ID# PRODUCT SALES 4 PRODUCTS 2100 Cutlery Set 2456 Toasters 2139 Video 2105 Stereos 2990 Stereos 2876 Video 2008 Toasters 2971 Cutlery Set 2333 Toasters 2550 Video 2345 Cutlery Set 2080 Stereos QUANTITY COST PER UNIT 255 102 45 32 18 85 159 124 80 201 64 410 855 10500 15600 15600 8. Insert a blank row below the column headings 9. Save the spreadsheet as exercise 2 10500 855 410 855 10500 410 15600 INSTRUCTIONS 1. The heading PRODUCT SALES should be font size 27, Bold, Font & Font Color of your choice and Center across columns 2. The Headings for each columns should be font size 12. Bold and Font calaurred Insert a formula to Calculate the Total Cost Format all Monetary Values as currency with 2 decimal place 5. SORT the spreadsheet in ASCENDING ORDER by column D 6. Add border to the entire spreadsheet 7. Add a auto format of your choice to the spreadsheet TOTAL COST
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
