RetailPro

COMPLETE A TRAVEL EXPENSE WORKSHEET

• GETTING STARTED
• Open the file SC_EX19_EOM1-2_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as SC_EX19_EOM1-2_FirstLastName_2.xlsx by changing the "1" to a "2".
  • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file SC_EX19_EOM1-2_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
  • If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
• PROJECT STEPS

1. Martin Hernandez is an operations coordinator for RetailPro, a sales and marketing company that works with retail businesses throughout the southwestern United States. Martin travels frequently to consult with clients and make sure they are arranging stores and featuring products in the most profitable way. He has created a worksheet to track his travel expenses and asks for your help in completing it. Go to the Travel Expenses worksheet. Merge the cells in the range B2:I2. In cell B13, enter 5/3/2021 as the date.
2. Apply the Accent3 cell style to the range B10:I10.
3. In cell C16, use Retail conference in Houston as the complete entry for the cell. In cell D11, enter 65 as the number of Miles Driven.
4. In cell E11, enter a formula without a function that multiplies the number of miles driven (cell D11) by the current mileage rate (0.55). Use the Fill Handle to fill the range E12:E16 with the formula in cell E11.
5. Apply the Accounting number format to the range E11:I16.
6. In cell E17, enter a formula using the SUM function to sum the Mileage Expense (the range E11:E16). Fill the range F17:I17 with the formula in cell E17.
7. In cell B21, change the font to Franklin Gothic Book (Body). Copy the value in cell C5 and paste it in cell D21.
8. Change the style of the pie chart in the range B23:E36 to Style 8.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.