Excel Proficiency Worksheet - Academia Essay Writers

Excel Proficiency Worksheet

Excel Proficiency Worksheet

Excel Proficiency Worksheet


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



Slide 1 of 1

  • open in full 24px minattachment_1attachment_1open in full 24px minExcel 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

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!