hi, i need this assignment done
Exam Instructions Excel Proficiency Assignment Use the instructions below to complete the assignment. Use of Excel for Organizing Change the name of the "Dataset" worksheet to “Excel Proficiency Exam” Insert a new column between Column A and Column B Split the single column A data into two separate columns Add a new heading name to these columns, "Last Name" and "First Name" Format Column C, D, E, and G for currency Format Column F for percentages Use of Formulas in Excel Create a formula in Column E to Add Columns C and D Label Column G “Taxes Paid” Create a formula in Column G to Multiply Column E and F Label Column H “Net Pay” Create a formula in column H to subtract G from E Insert a new column between Column E and Column F Label the new column F "Average Daily Wage Rate" Create a formula in the new column F to divide "Total Weekly Wages" by 7 Merge cells K1 and L1 and name the cell "Employee Averages" In column K, under the heading, copy the heading titles from C1:I1 to K2:K8. Use a formula to link the cells. Create a formula in column L that calculates the averages for each matching category in K2:K8 Use of Complex Formulas in Excel In cell K25, create a heading titled, "Thunder Occurrences" In cell K26, create a formula that counts the number times "Thunder" occurs in the columns containing "Names" Use of Excel to Create Graphs Using data in the average table, create a pie chart that compares the amount of average weekday wages to the average weekend wages Change the chart title to, "Weekday & Weekend Wage Comparison" Position the chart so that it is placed between K10-L23 Use of Excel for Aesthetics Change the font for your entire workbook to 12pt Arial Widen or shrink all columns to the exact size of the words in the heading Wrap text in headings with three or more words so that are no more than 3 words per line Center the entire data set Sort the entire data set according to last name Add all borders to the entire data set along with the Employee Averages and Thunder Occurrences data set Add a thick outside border to the first row of headings including the Employee Averages and Thunder Occurrences headings Italicize and bold the text in the headings along with the Employee Averages and Thunder Occurrences headings Add a Light Gray Background to all headings including Employee Averages and Thunder Occurrences Insert an image of any GCU logo under the number of "Thunder Occurrences" DataSet Weekday WagesWeekend WagesTotal Weekly WagesTax Bracket Doe,John5004000.20 Lauterborn,Teresa3254500.25 Williams,Anna80014000.22 Smith,Jane80014000.30 Escobar,Tianna4757310.33 Miranda,Isabelle4097890.31 Thunder,Devin8508750.15 Boscot,Kyra6803000.15 Thunder,Kyra6803000.14 Riley,Albert5004000.13 Fink,Thunder77510000.12 Garza,Tracey4005000.18 Newert,Devin8508750.19 Walker,Isabelle7406780.26 Wells,Jane7154490.25 Belanger,Anna1008000.23 Rhodes,Kara3223860.25 Anderson,Steven2737380.30 Doe,Campbell77510000.10 Escobar,James5484040.26 Adrian,Jacob2499470.34 Martinez,Megan3269820.22 Miranda,Brandon5325890.34 Smith,Kelly2889630.25 Williams,Ashley1008000.35 Fisher,Kathryn7755550.28 Barnes,Sean3204620.29 Harper,Joshua7718920.34 Avery,Chelsey5477330.30 Pews,Kimberly5877370.31 Lutz,Latrisha4005000.20 Johnson,Bridget3869630.25 Ellerman,Elizabeth6099780.35 Slater,Jeffrey5928220.28 Stover,Charlene5384040.29 Kaiser,Melinda2045770.25 St Louis,Peter3886870.25 Molina,Christine5239300.25 Harris,Robert2535950.21 Craven,Mary Kate4954060.20 Young,Nicole6275130.33 Barraza,Warner4868930.34 Taylor,Jonathan7146020.25 Young,Samuel7584390.26 Weiser,Ashley3254500.20 Powell,Tamara3649990.15 Davis,Michelle6958280.31 Salinas,Thunder4609420.22