SOLUTION: Spartan College of Aeronautics and Technology The Old Piece Rate System Questions

Grader Project # 2 – MS Excel

Purpose: To demonstrate proficiency in the basic use of Microsoft’s Excel spreadsheet software programDescription: 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 FORMULA that is the AUTOSUM of cells B3, B4, B5, B6, and B7 added together. Do NOT just write in $124.21! (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 FORMULA that is the product of cell B8 multiplied by cell B9. Do NOT just write in $7.45! (10 points)Cell A11: TOTAL in bold, 10-point Arial font, bold, LEFT Aligned. (1 point)Cell B11: A FORMULA that is the sum of cell B8 added to cell B10. Do NOT just write in $131.66! (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 FORMULA that is the product of cell B11 multiplied by cell B12. Do NOT just write in $13.17! (10 points)Cell A14: GND. TTL. in bold, 10-point Arial font, bold, LEFT Aligned. (1 point)Cell B14: A FORMULA that is the difference of cell B13 subtracted from cell B11. Do NOT just write in $131.66!(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)

Order a unique copy of this paper
(550 words)

Approximate price: $22

Our Basic features
  • Free title page and bibliography
  • Plagiarism-free guarantee
  • Unlimited revisions
  • Money-back guarantee
  • 24/7 support
Our Options
  • Writer’s samples
  • Expert Proofreading
  • Overnight delivery
  • Part-by-part delivery
  • Copies of used sources
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

AcademicWritingCompany guarantees

Our customer is the center of what we do and thus we offer 100% original essays..
By ordering our essays, you are guaranteed the best quality through our qualified experts.All your information and everything that you do on our website is kept completely confidential.

Money-back guarantee

Academicwritingcompany.com always strives to give you the best of its services. As a custom essay writing service, we are 100% sure of our services. That is why we ensure that our guarantee of money-back stands, always

Read more

Zero-plagiarism tolerance guarantee

The paper that you order at academicwritingcompany.com is 100% original. We ensure that regardless of the position you are, be it with urgent deadlines or hard essays, we give you a paper that is free of plagiarism. We even check our orders with the most advanced anti-plagiarism software in the industry.

Read more

Free-revision guarantee

The Academicwritingcompany.com thrives on excellence and thus we help ensure the Customer’s total satisfaction with the completed Order.To do so, we provide a Free Revision policy as a courtesy service. To receive free revision the Academic writing Company requires that the you provide the request within Fifteen (14) days since the completion date and within a period of thirty (30) days for dissertations and research papers.

Read more

Privacy and Security policy

With Academicwritingcompan.com, your privacy is the most important aspect. First, the academic writing company will never resell your personal information, which include credit cards, to any third party. Not even your lecturer on institution will know that you bought an essay from our academic writing company.

Read more

Adherence to requirements guarantee

The academic writing company writers know that following essay instructions is the most important part of academic writing. The expert writers will, therefore, work extra hard to ensure that they cooperate with all the requirements without fail. We also count on you to help us provide a better academic paper.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2020 at 10:52 AM
Total price:
$26
The price is based on these factors:
Customer Academic level
Number of pages required
Urgency of paper