Meone

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 changed, 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 put in, or the number 0 is valid. For example, lunch should not cost $678; that is unreasonable.

6. Format all of the dollar figure numbers as 2-digit U.S. currency.

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.