need help solving this please show with steps

1. Cakes R Us is a bakery in Arlington. The Bakery worksheet shows a summary of the year 2020 with the revenue for each month and the number of sales people each month. a. Create a column graph of the revenue and label it completely. b. Investigate gridlines. c. Add a data table, what is the purpose? d. Make the bars cakes! 2. Create a chart that shows both the revenue and the staffing levels. a. What are the actual measurements on the line? 3. The Annual Reviews worksheet shows the annual reviews for the five bakers and Cakes R Us. a. Create a graph that shows all of the information. b. Who is performing well? Who not so well? 4. Gantt charts are something we using very often as Industrial Engineers. You will have access to Microsoft Project which is very, very good at drawing Gantt charts and doing other scheduling management. But its not commonly owned by companies and its very sophisticated and can often times be overkill, Excel to the rescue! The Tasks worksheet contains the tasks required to cater a wedding reception, the relative times the tasks can be started and the duration of the

File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Calibri v 11 AutoSum ~AP = ab Wrap Text O TT General AY Fill Paste Insert Delete Format == = A Merge & Center $ % -28 Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Sensitivity Clear Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity H21 X fic . B D E F G H 1 J K L M N o Q R S T U V - Nm mono F 000 aan na ang Month Salespeople Revenue January 25 2735900 February 21 2210271 March 28 3004596 April 22 2825548 May 28 3576132 June 25 3128575 July August 24 2665368 September 28 2833012 October 23 2424844 November 24 2549544 December 30 3150120 Tasks + O Bakery Annual Reviews Accessibility: Good to go Ready E 100% File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share AutoSum Calibri X LO 11 ~AP O TIX a Wrap Text General AY F III llo III III Fill Paste BI U Insert Delete Format == -- Sensitivity A. Merge & Center $ %) 0.0 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity AE24 X fir A B D E F G H 1 J K L M N o P Q R S T U V 1 2 3 4 Collegial Punctual Hard working 1 2 Completes task on time 3 7 9 4 Bill Margerie Aaron Kyle Norma 5 6 9.5 8 8.5 10 9 1 2 1.5 9 2 2.5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Tasks + Bakery Annual Reviews Accessibility: Good to go Ready E 100% File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share AutoSum Calibri v 11 ~ A X a Wrap Text v General SI TIX 47 FO NIN Qox Hillo Fill Paste Insert Delete Format B IU = = A ++ Sensitivity Merge & Center $ - % -20 Analyze Data Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select V Clear Clipboard Font Alignment N Number Cells Editing Analysis Sensitivity F19 X fc B D F H 1 J L M N o 0 R s T U V 1 Start Duration 0 4 3 Plan with customer Obtain supplies Make decorations Bake all items Close order and collect 5 Ova 6 8 10 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Tasks + Bakery Annual Reviews Accessibility: Good to go Ready 100% File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Calibri v 11 AutoSum ~AP = ab Wrap Text O TT General AY Fill Paste Insert Delete Format == = A Merge & Center $ % -28 Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Sensitivity Clear Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity H21 X fic . B D E F G H 1 J K L M N o Q R S T U V - Nm mono F 000 aan na ang Month Salespeople Revenue January 25 2735900 February 21 2210271 March 28 3004596 April 22 2825548 May 28 3576132 June 25 3128575 July August 24 2665368 September 28 2833012 October 23 2424844 November 24 2549544 December 30 3150120 Tasks + O Bakery Annual Reviews Accessibility: Good to go Ready E 100% File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share AutoSum Calibri X LO 11 ~AP O TIX a Wrap Text General AY F III llo III III Fill Paste BI U Insert Delete Format == -- Sensitivity A. Merge & Center $ %) 0.0 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity AE24 X fir A B D E F G H 1 J K L M N o P Q R S T U V 1 2 3 4 Collegial Punctual Hard working 1 2 Completes task on time 3 7 9 4 Bill Margerie Aaron Kyle Norma 5 6 9.5 8 8.5 10 9 1 2 1.5 9 2 2.5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Tasks + Bakery Annual Reviews Accessibility: Good to go Ready E 100% File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share AutoSum Calibri v 11 ~ A X a Wrap Text v General SI TIX 47 FO NIN Qox Hillo Fill Paste Insert Delete Format B IU = = A ++ Sensitivity Merge & Center $ - % -20 Analyze Data Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select V Clear Clipboard Font Alignment N Number Cells Editing Analysis Sensitivity F19 X fc B D F H 1 J L M N o 0 R s T U V 1 Start Duration 0 4 3 Plan with customer Obtain supplies Make decorations Bake all items Close order and collect 5 Ova 6 8 10 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Tasks + Bakery Annual Reviews Accessibility: Good to go Ready 100%