Complete a partially filled out expense report

Assignment Help Basic Computer Science
Reference no: EM13886146

Assignment Description

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 as "(your last name_your first name)_U4 Expense Report 1.xlsx," 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)" (without the quotes). Copy this formula down to the other appropriate rows below.

9. Next, calculate the totals for each category. In row 14, under the Brkfast column, add all of the numbers above it using a Sum formula, and 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.

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.

15. Format the dates into the full month name, day, and year format.

16. Finally, repeat steps 2 and 3 so that the spreadsheet has all of the data showing in it.

17. Save your completed report as "(your last name_your first name)_U4 Expense Report 2.xlsx" (e.g., Doe_John_U4 Expense Report 2.xlsx).

18. Submit the assignment.

Attachment:- Report.xlsx

Reference no: EM13886146

Explaining vulnerability in novice programmer-s code

You have found vulnerability in novice programmer's code and have recommended sweeping changes in your organization to address issues.

Track of current inventory and re-orders automatically

Assignment 3 This assignment is marked out of 15. The marks will be scaled to be worth 15% for the assignment. The learning objectives are here. The due date is 26th October

Computer network power point slide

LLMD Co. has 5 locations across the country, with each location housing a division of the company. Each division houses several hundred users, totaling approximately 1,000 u

Derive a method to correct x to reflect an arbitrary time

MATLAB's fft command computes the DFT of a vector x assuming that the first sample occurs at time n = 0. Given that X = fft(x) has already been computed, derive a method to

Use the heuristic evaluation method

For this coursework you must provide an Expert Appraisal of the Just Eat's takeway interface (web or mobile app) ( in a web browser or phone of your ch

Which search engine do you believe provided

Which search engine do you believe provided you the best results? Support your position by explaining why you believe the particular search engine to be better based upon yo

Create a demo object and try its pickup test method

The taxi-company-outline project defines a Demo class to create a pair of Passenger Source and TaxiCompany objects. Create a Demo object and try its pickup Test method. Why

Wikis are web-based tools that make it easy

Wikis are Web-based tools that make it easy for users to add, remove, and change online content. Employees at companies such as Intel, Motorola, IBM, and Sony use them for


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd