Excel Proficiency Worksheet

Excel Proficiency Worksheet

Excel Proficiency Worksheet

ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS 

View the attached Excel sheet, “Excel Proficiency Assignment,” and follow the instructions provided to complete the assignment.

AttachmentsBIT-200-RS-Excel-Proficiency-Assignm

1attachments

Slide 1 of 1

• attachment_1attachment_1Excel 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 cell 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 “N Use of Excel to Create Graphs Using data in the average table, create a pie chart that compares the amount of average weekday 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 s Add a thick outside border to the first row of headings including the Employee Averages and Thunder Occ Italicize and bold the text in the headings along with the Employee Averages and Thunder Occurrences he 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” Doe,John Lauterborn,Teresa Williams,Anna Smith,Jane Escobar,Tianna Miranda,Isabelle Thunder,Devin Boscot,Kyra Thunder,Kyra Riley,Albert Fink,Thunder Garza,Tracey Newert,Devin Walker,Isabelle Wells,Jane Belanger,Anna Rhodes,Kara Anderson,Steven Doe,Campbell Escobar,James Adrian,Jacob Martinez,Megan Miranda,Brandon Smith,Kelly Williams,Ashley Fisher,Kathryn Barnes,Sean Harper,Joshua Avery,Chelsey Pews,Kimberly Lutz,Latrisha Johnson,Bridget Ellerman,Elizabeth Slater,Jeffrey Stover,Charlene Kaiser,Melinda St Louis,Peter Molina,Christine Harris,Robert Craven,Mary Kate Young,Nicole Barraza,Warner Taylor,Jonathan Young,Samuel Weiser,Ashley Powell,Tamara Weekday Wages Weekend Wages Total Weekly TaxWages Bracket 500 400 0.20 325 450 0.25 800 1400 0.22 800 1400 0.30 475 731 0.33 409 789 0.31 850 875 0.15 680 300 0.15 680 300 0.14 500 400 0.13 775 1000 0.12 400 500 0.18 850 875 0.19 740 678 0.26 715 449 0.25 100 800 0.23 322 386 0.25 273 738 0.30 775 1000 0.10 548 404 0.26 249 947 0.34 326 982 0.22 532 589 0.34 288 963 0.25 100 800 0.35 775 555 0.28 320 462 0.29 771 892 0.34 547 733 0.30 587 737 0.31 400 500 0.20 386 963 0.25 609 978 0.35 592 822 0.28 538 404 0.29 204 577 0.25 388 687 0.25 523 930 0.25 253 595 0.21 495 406 0.20 627 513 0.33 486 893 0.34 714 602 0.25 758 439 0.26 325 450 0.20 364 999 0.15 Davis,Michelle Salinas,Thunder 695 460 828 942 0.31 0.22