Complete the following 1. Open the Module b Bikes.x.sx workbook and sav_ + fil: as . Mod5Bikes(y , mast na n-)..IS. 2. the 5 4: woman... inser. a new column. B. in B1 name .he header as 'baluelanager". Ard the sales manayers nam . to the wate n column lising VLOOfter to leterminu w.. ch sales manager send a particular product. . ornat cach column ut wate as the appropriate wate t, pes and format ng the. a, . cals to the User of this sheet Create a Vate Model noover pi . t the includes he two worksheets of data Name the shvets in the uata mode, appropriate! . cs.ablish the rule. onsnip that ex's.s be.ween th_ two wor.sheets. To complete the olewing requirements, you will need to create an, calculated :_! or measure . . will need to compete me anal s's.nside the . dave model. Ali prive calouie ions are to be rounded up to two decimal places and formatted as curren 5. Create a new sheet to the right of Managers named manager Performance. Create a Plot Table from your dave mod I chat shows annual sales manager performance per product. this pi.o. table ne-us to compare the total sales b. sales managers or each , ear. 6. Create a new shee. to the right of Manager Performance called limainc. Create a Pivot lable from . our data modei chat shows all sales amounts by sales manager over time. Use a jmuline to vispia, sales for 21-7 and 2w0o Create a new sheet to the right of imeline alled Countries. Create a Pivot , able fromm , our data mode that shows total sales to differen. countries for each Jar. To visualize saves to the countries create a bar chart showing he purchas_s b, countries. Add date labels to he highes. saids amount in each year. , ormat the chart appropriately for ease of understanding the data L . Create a new sheet to the right of Countries called K .. Create a Pivot table from your da.a modei the: shows profitability or each sales manager. I o do this, , ou will need to create a KP that assesses profil b, manager (Pronit is uni. Price Cost, . Set your first milestone to 500,0UV Set your second to 4,000 00w. Pick a visualizeion hat sunis the data. Use this Kri in . our Pivot Table to wisplay a symbol for wach manager's profit 9. Save , our file and submit to the dropDOA