grader-project-2-ms-excel

Purpose: To demonstrate proficiency in the basic use of Microsoft’s Excel spreadsheet software program

Description: The student will create a small spreadsheet in the style of a job estimate for a bird-house being built in a neighborhood park by three neighbors. The estimate is being submitted to the three neighbors by a worker who is bidding on the project.

When you are done, your project should look like the image below:
IMD100 - Excel Project

Requirements and Grading: Students must follow the instructions below, with each step counting for the percentage of the project’s grade as indicated below:

  1. Cells A1 and B1: Centered and merged (3 points)
  2. Cells A1 and B1: Black text (Arial font, 18 size, bold, gray background (1 point)
  3. Cell A2: ITEM in bold, 10-point Arial font, bold, LEFT Aligned. (2 points)
  4. Cell B2: AMOUNT in bold, 10-point Arial font, bold, RIGHT Aligned. (2 points)
  5. Cell A3: Hammer in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  6. Cell B3: How much the hammer costs – 5.57 – with cell formatted as Currency (US Dollars), Arial font, 10 size. (2 points)
  7. Cell A4: Nails in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  8. Cell B4: How much the nails cost – 2.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size. (2 points)
  9. Cell A5: Wood in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  10. Cell B5: How much the wood costs – 37.64 – with cell formatted as Currency (US Dollars), Arial font, 10 size. (2 points)
  11. Cell A6: Paint in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  12. Cell B6: How much the paint costs – 29.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size. (2 points)
  13. Cell A7: Labor in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  14. Cell B7: How much the labor costs – 50.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size. (2 points)
  15. Cell A8: SUBTOTAL in bold, 10-point Arial font, bold, LEFT Aligned. (2 points)
  16. Cell B8: A FORMULA that is the AUTOSUM of cells B3, B4, B5, B6, and B7 added together. Do NOT just write in $124.21! (10 points)
  17. Cell A9: Tax Rate in regular non-bold, 10-point Arial font, LEFT Aligned (2 points)
  18. Cell B9: 6% written simply as a number followed by the % sign (2 points)
  19. Cell A10: Taxes in regular non-bold, 10-point Arial font, bold, LEFT Aligned (2 points)
  20. Cell B10: A FORMULA that is the product of cell B8 multiplied by cell B9. Do NOT just write in $7.45! (10 points)
  21. Cell A11: TOTAL in bold, 10-point Arial font, bold, LEFT Aligned. (1 point)
  22. Cell B11: A FORMULA that is the sum of cell B8 added to cell B10. Do NOT just write in $131.66! (10 points)
  23. Cell A12: Discount % in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  24. Cell B12: 10% written simply as a number followed by the % sign (1 point)
  25. Cell A13: Discount in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  26. Cell B13: A FORMULA that is the product of cell B11 multiplied by cell B12. Do NOT just write in $13.17! (10 points)
  27. Cell A14: GND. TTL. in bold, 10-point Arial font, bold, LEFT Aligned. (1 point)
  28. Cell B14: A FORMULA that is the difference of cell B13 subtracted from cell B11. Do NOT just write in $131.66!(10 points)
  29. Cell A15: Neighbors in regular non-bold, 10-point Arial font, bold, LEFT Aligned (1 point)
  30. Cell B15: A simple number – 3 – not written as a percentage and not written as currency. (1 point)
  31. Cell A16: PER PERSON in bold, 10-point Arial font, bold, LEFT Aligned. Shaded with a gray background. (2 points)
  32. Cell A17: A FORMULA that is the quotient of cell B14 divided by Cell B15. Shaded with a gray background. (10 points)
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.