Share
Explore BrainMass

Expense Report Claims

1-Retrieve the Expense Report and save it on your computer as Expense Report 1. This partially completed workbook contains the column headings and several expense items.

2-Enter a SUM function in cells C12:N12 which totals the figures in rows 8 through 11. The formula for doing that is "=SUM(C8:C11)" and enter that in C12 and copy it in columns D through N.

3-In cell M4, put the label "Allowance." In cell M5, type ".32", which is the amount paid per mile. In cell M8, put the formula that multiplies the mileage in cell L8 by the mileage allowance. Remember to use an absolute reference for cell M5. Copy the formula to cells M9:M11.

4-In cell N8, sum the range C8:K8 and M8, omitting column L, which is not an expense. Copy the formula to cells N9:N11
Hint: One way is to use the SUM function for the contiguous range and add in the noncontiguous. Another way is to enter the range as two separate arguments.
5-Select the column headings in row 6 and bold them.

6-Create a report title by typing "Expense Report" in cell A2. Select cells A2:N2 and use the Merge and Center button. Change the font size to 14 point.
7-Use the Merge and Center button to place "Transportation" above "Air" and "Ground." Do not forget to format these headings to match the others.
8-Use the Merge and Center button to place "Meals" above "Brkfast", "Lunch" and "Dinner." Do not forget to format these headings to match the others.

9-Select the dates in cells A8:A11 and change the format to day-month.

10-Adjust the column widths.
11-Create a custom footer with "Created by <your name>" at the right side.
12-Change the orientation of the page to landscape and make it Fit on One page

Attachments

Solution Preview

Please see attached spreadsheet.

To update the custom footer, you will need to go to the ...

Solution Summary

The solution examines expense report claims and how to compute them in Excel.

$2.19