# 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:

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

- Cells A1 and B1: Centered and merged
**(3 points)** - Cells A1 and B1: Black text (Arial font, 18 size, bold, gray background
**(1 point)** - Cell A2: ITEM in
**bold**, 10-point Arial font, bold, LEFT Aligned.**(2 points)** - Cell B2: AMOUNT in bold, 10-point Arial font, bold, RIGHT Aligned.
**(2 points)** - Cell A3: Hammer in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B3: How much the hammer costs – 5.57 – with cell formatted as Currency (US Dollars), Arial font, 10 size.
**(2 points)** - Cell A4: Nails in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B4: How much the nails cost – 2.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size.
**(2 points)** - Cell A5: Wood in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B5: How much the wood costs – 37.64 – with cell formatted as Currency (US Dollars), Arial font, 10 size.
**(2 points)** - Cell A6: Paint in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B6: How much the paint costs – 29.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size.
**(2 points)** - Cell A7: Labor in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B7: How much the labor costs – 50.00 – with cell formatted as Currency (US Dollars), Arial font, 10 size.
**(2 points)** - Cell A8: SUBTOTAL in
**bold**, 10-point Arial font, bold, LEFT Aligned.**(2 points)** - Cell B8: A
that is the AUTOSUM of cells B3, B4, B5, B6, and B7 added together. Do NOT just write in $124.21!**FORMULA****(10 points)** - Cell A9: Tax Rate in regular non-bold, 10-point Arial font, LEFT Aligned
**(2 points)** - Cell B9: 6% written simply as a number followed by the % sign
**(2 points)** - Cell A10: Taxes in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(2 points)** - Cell B10: A
that is the product of cell B8 multiplied by cell B9. Do NOT just write in $7.45!**FORMULA****(10 points)** - Cell A11: TOTAL in bold, 10-point Arial font, bold, LEFT Aligned.
**(1 point)** - Cell B11: A
that is the sum of cell B8 added to cell B10. Do NOT just write in $131.66!**FORMULA****(10 points)** - Cell A12: Discount % in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B12: 10% written simply as a number followed by the % sign
**(1 point)** - Cell A13: Discount in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B13: A
that is the product of cell B11 multiplied by cell B12. Do NOT just write in $13.17!**FORMULA****(10 points)** - Cell A14: GND. TTL. in
**bold**, 10-point Arial font, bold, LEFT Aligned.**(1 point)** - Cell B14: A
that is the difference of cell B13 subtracted from cell B11. Do NOT just write in $131.66!**FORMULA****(10 points)** - Cell A15: Neighbors in regular non-bold, 10-point Arial font, bold, LEFT Aligned
**(1 point)** - Cell B15: A simple number – 3 – not written as a percentage and not written as currency.
**(1 point)** - Cell A16: PER PERSON in
**bold**, 10-point Arial font, bold, LEFT Aligned. Shaded with a gray background.**(2 points)** - Cell A17: A FORMULA that is the quotient of cell B14 divided by Cell B15. Shaded with a gray background.
**(10 points)**