Grader Project # 2 – MS Excel

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.


Order a Similar Paper Order a Different Paper

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)

Writerbay.net

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.


Order a Similar Paper Order a Different Paper