Question: Tasks: Please provide steps for each question. Check and correct any spelling errors Label and rearrange the month columns so that they are incorrect order
Tasks: Please provide steps for each question.
Check and correct any spelling errors
Label and rearrange the month columns so that they are incorrect order
Format all numbers so that they are consistent with this format: 13,000
Sort the June column from highest to smallest, taking care to make sure that all the data is sorted as well.
Format the data in the August column into a red text and blue backgroundTotal the data for the first three months for each row in the named column
Total all the data for each month in the correct column
Subtract the total for December from July, place the answer in cell M:16
Show grand total for each person
Highlight any data that you think looks out of place or that you have further queries on.
Conclude any missing information

20 June July October September August November December first 3 months total Grand total 16.5% of grand total Kyle 20k 15k 1.5k 300 567 1500 1900 George 13000 13000 1500 2400 5894 4000 600074 Harry 5k 12k 6 8451 1204 5600 56k Judy 1200 9k 1900 9630 2478 5800 6930 Matthew 5600 9000 1475 nine thousand 1500 47k 6000 Claire 1200 4520 5689 1740 1900 1300 4650 Luisa 3000 1005 56.4k 1k 1475 1 thousand seven hundred 7800 TOTAL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
