Excel Assignment

You are an intern trying to keep track of who attended which leadership session, and what amounts you need to collect yet for everyone.  Because you are new, you are trying impress your boss, so you want to put together an easy to read report that you can present later.  Download Lesson_5_Excel.xlsx  Download Lesson_5_Excel.xlsxand make the following changes:

1) Put an X to mark the appropriate cells to show that everyone in Sales and HR attended Part 2

2) Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3

3) Format Column J to be 'Currency' with 2 decimal places.  Be sure it includes the $ automatically.

Excel Assignment

Excel Assignment is rated 4.8/5 based on 99 customer reviews.

Are you in need of homework help?
Place your order and get 100% original work.

4) Each individual must pay $25 for each session they attended.  Using a formula, fill Column J with the total owed for sessions attended, subtracting anything already paid.

5) Sort the entire file (except the headers) A-Z by Last name 

6) Add a filter to all Columns

7) Bold 'Total Paid'

8) Add conditional formatting to the First Name cell for anyone in Accounting that did not attend Part 2, so that the name is Red if they did not attend and Green if they did

9) Change the last name 'Crocker' to your professor's last name


Get Homework Help Now



Related Posts

Why Choose Us
  1. Confidentiality and Privacy
  2. 100% Original Work
  3. 24/7 Customer Support
  4. Unlimited Free Revisions
  5. Experienced Writers
  6. Real-time Communication
  7. Affordable Prices
  8. Deadline Guaranteed
We accept all payment option, no PayPal account is required studybay