$1.$ Prepare a line and bar chart in MS Word for the data given in the following table. The Prepare a line and bar chart in MS Word for the data given in the following table. The data represent the monthly sales $($in millions$)$ of various super markets located in Ohio State. $(40$ points$)$

$\backslash$table$[[,$Walmart,Meijer,Kroger,Aldi,Target,Kohl's,Lowe's,Sam's Club$],[$month$1,23\mathrm{.}63,46\mathrm{.}61,48\mathrm{.}5,64\mathrm{.}59,34\mathrm{.}41,55\mathrm{.}23,63\mathrm{.}21,43\mathrm{.}25],[$month$2,47\mathrm{.}03,26\mathrm{.}99,65\mathrm{.}39,36\mathrm{.}42,20\mathrm{.}29,18\mathrm{.}61,15\mathrm{.}47,52\mathrm{.}11],[$month$3,87\mathrm{.}31,88\mathrm{.}43,16\mathrm{.}61,52\mathrm{.}34,39\mathrm{.}04,35\mathrm{.}44,66\mathrm{.}16,41\mathrm{.}62],[$month$4,26\mathrm{.}37,48\mathrm{.}95,13\mathrm{.}39,60\mathrm{.}36,37\mathrm{.}38,86\mathrm{.}66,87\mathrm{.}76,66\mathrm{.}09],[$month$5,36\mathrm{.}66,38\mathrm{.}15,44\mathrm{.}47,33\mathrm{.}97,10\mathrm{.}84,50\mathrm{.}2,18\mathrm{.}86,62\mathrm{.}89],[$month$6,53\mathrm{.}16,56\mathrm{.}23,61\mathrm{.}35,68\mathrm{.}97,95\mathrm{.}9,24\mathrm{.}55,54\mathrm{.}59,35\mathrm{.}68]]$

Prepare Pie charts for the following:

a$)$ Prepare a Pie chart for the data representing Kroger company monthly sales. $(15$ points$)$

b$)$ Prepare a Pie chart for the data representing month$4$ sales of various companies. $(15$ points$)$

For questions $1$ and $2,$ to get full credit, vou need to prepare charts with axes title, chart title, legends and data table within the chart. Prepare Pie charts for the following:

a$)$ Prepare a Pie chart for the data representing Kroger company monthly sales.

$(15$ points$)$

b$)$ Prepare a Pie chart for the data representing month $4$ sales of various

companies. $(15$ points$)$

For questions $1$ and $2,$ to get full credit, vou need to prepare charts with axes title, chart

title, legends and data table within the chart.

Prepare your weekly school schedule. The table must have at least $5$ rows and $7$ columns.

Each cell must have a relevant text. For example, if you have no class during an hour,

you have to write the text in that cell as break. Fill solid blue color for the break $($free

time$)$ hours. Fill solid green color for math classes. $(30$ points$)$

data represent the monthly sales $($in millions$)$ of various super markets located in Ohio

State. $(40$ points$)$

Walmart Meijer Kroger Aldi Target Kohl$$s Lowe$$s Sam$$s Club

month$123\mathrm{.}6346\mathrm{.}6148\mathrm{.}564\mathrm{.}5934\mathrm{.}4155\mathrm{.}2363\mathrm{.}2143\mathrm{.}25$

month$247\mathrm{.}0326\mathrm{.}9965\mathrm{.}3936\mathrm{.}4220\mathrm{.}2918\mathrm{.}6115\mathrm{.}4752\mathrm{.}11$

month$387\mathrm{.}3188\mathrm{.}4316\mathrm{.}6152\mathrm{.}3439\mathrm{.}0435\mathrm{.}4466\mathrm{.}1641\mathrm{.}62$

month$426\mathrm{.}3748\mathrm{.}9513\mathrm{.}3960\mathrm{.}3637\mathrm{.}3886\mathrm{.}6687\mathrm{.}7666\mathrm{.}09$

month$536\mathrm{.}6638\mathrm{.}1544\mathrm{.}4733\mathrm{.}9710\mathrm{.}8450\mathrm{.}218\mathrm{.}8662\mathrm{.}89$

month$653\mathrm{.}1656\mathrm{.}2361\mathrm{.}3568\mathrm{.}9795\mathrm{.}924\mathrm{.}5554\mathrm{.}5935\mathrm{.}68$

$2.$ Prepare Pie charts for the following:

a$)$ Prepare a Pie chart for the data representing Kroger company monthly sales.

$(15$ points$)$

b$)$ Prepare a Pie chart for the data representing month$4$ sales of various

companies. $(15$ points$)$

For questions $1$ and $2,$ to get full credit, you need to prepare charts with axes title, chart

title, legends and data table within the chart.

$3.$ Prepare your weekly school schedule. The table must have at least $5$ rows and $7$ columns.

Each cell must have a relevant text. For example, if you have no class during an hour,

you have to write the text in that cell as break. Fill solid blue color for the break $($free

time$)$ hours. Fill solid green color for math classes. $(30$ points