Part II: Directions for the Excel worksheets $-2$ points each Follow these instructions for the $6$ worksheets in this file. Save the file with your name on your computer and then upload into MyITLab, add and submit for grading. Chapter $1$ and $2$: Formatting, Formulas and Functions Go to Worksheet #$1.1)$ In cells B$10$ B$13$ enter a Vlookup function to display the correct description of the product. $2)$ In cells D$10-$D$13$ enter a VLookup function to display the unit price of the product. $3)$ In cells E$10-$E$13$ enter a regular formula that calculates the dollar order amount. Go to Worksheet #$2.4)$ In cells F$7$ F$36$ use a IF function to display the word Order if the quantity in stock is less than the order threshold $($cell B$4),$ and the word OK otherwise. Use an appropriate cell reference so that when you copy the formula is will be correct. $5)$ In cell I$7$ use the function to determine the minimum quantity in stock. $6)$ In cell I$8$ use the correct function to determine the maximum quantity in stock. $7)$ In cell I$9,$ use the correct function to determine the average retail price of a confection. $8)$ In cell I$10,$ use the corect function to determine the # of items. $9)$ Merge and Center the text in A$2$ from A$2$:F$2$ Go to Worksheet #$3.10)$ In cell B$14,$ enter PMT function to determine the monthly payment. $11)$ Apply accounting format for the monthly payment amount in B$14$ Chapter $4$ Tables Go to Worksheet #$4.12)$ Create a table from the data in the Chapter $4$ Tables worksheet tab. $13)$ Create a column called Amount Owed in Column G$.14)$ Create a formula in the Amount Owed Column $($column G$)$ to determine the amount owed for each student after the scholarship amount is applied. $15)$ Sort by multiple levels: First by Instrument, A to Z$,$ then add level Last Name, A to Z$,$ then Amount Owed, largest to smallest. $16)$ Filter the instrument column showing records for Flute, Clarinet and Trombone only. $17)$ Add a total row that displays the sum for Scholarship Amount column, count for Last name column and the average for the Amount Owed column. $18)$ Apply Blue Data Bars Conditional Formatting to the Amount Owed column. Chapter $5$ Subtotals Go to Worksheet #$519)$ Sort the data by City from A to Z$,$ then by Selling Agent from A to Z$,$ then by Listing date from oldest to newest. $20)$ Use the Subtotal feature to calculate the average selling price, asking price and days on market by city. $21)$ Apply an automatic outline to the columns. Chapter $5$ Pivot Tables Go to Worksheet #$622)$ Create a Pivot Table for the data $23)$ Display the Category field, then the Title field in the rows area. $24)$ Display Retail Sales and Combined Sales fields in the values area. $25)$ Display Release Date in Filters area, then filter to show release dates for $2010,2011,$ and $2012$ only.