Home » Help disreguard the first one

Help disreguard the first one

Details:

In this project, you will complete a partially filled out expense report for a company’s sales force and then save it. To view these instructions while you work in Excel, you can print this page of instructions or move back and forth between this page and Excel by clicking each application’s button on the Windows taskbar.

  1. Click on the following link: Expense Report; save it on your computer in your usual work folder, and then open it in Excel. This partially completed workbook contains an incomplete expense report that needs formatting changes, boxes filled in with appropriate information, and formulas created for correct calculations.
  2. First, click on the small box that is to the left of column A and above row 1. This will highlight the entire spreadsheet.
  3. Next, position your cursor between columns A and B so that your cursor looks like a plus sign with arrows on the left and right. Double-click here to make the columns fit around the existing data. To finish, click anywhere in the worksheet once to remove the highlight from the entire page.
  4. Create a border around the data entry portion of this spreadsheet. This is done by selecting cells A8–M12. Put a border around the outside of this area only.
  5. Fill in all blank boxes with appropriate data within the A8–M12 data range. For text or date information, provide appropriate text or date entries. Reasonable numbers can be entered. For example, lunch should not cost $678; that is unreasonable.
  6. Format all of the dollar figure numbers as 2-decimal U.S. currency. Example: $45.00.
  7. In cell I4, type the words, “Allowance Per Mile.” In cell L4, type the number 0.40. Format this number as currency. Select cells I4–K4, and use the Merge and Center button to format this.
  8. In the Daily Totals column, calculate the cost for each day. To do this, type this formula: =Sum(C8:H8,J8:M8). Copy this formula down to the other appropriate rows below.
  9. Next, calculate to totals for each category. In row 14, under the Brkfast column, add all of the numbers above it using a Sum formula, then copy it across under each column.
  10. In cell J8, calculate the cost allowance per mile under the Mileage $ column for each date. You need to multiply the mileage by the mileage allowance. Be sure to use an absolute reference when referring to the mileage allowance because it is not in the table and only occurs once at the top of the sheet.
  11. Copy this formula down to each of the 4 columns directly below cell J8.
  12. Make all headings bold.
  13. Create a report title by typing the words “Expense Report” in cells E2. Select cells E2–J2, and use the Merge and Center button to center the title across the report. Change its font size to 14. Also, use the Merge and Center button to place the words “Transportation” above “Air” and “Ground” and “Meals” above “Brkfast,” Lunch,” and “Dinner.” Do not forget to format these words to match the other headings.
  14. Format the dates into the full month name, day, and year format.
  15. Finally, repeat steps 2 and 3 so that the spreadsheet has all of the data showing in it.
  16. Save your completed report as your “First initial Last name Expense Report 1″. Example: J Doe Expense Report 1.
  17. Submit the assignment.

Please submit your assignment.

Grading Rubric: Click here for the grading rubric for this assignment.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Unit Materials

Unit 4 Course Materials







Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more