Shelly Cashman Excel 365 | Module 1: End of Module Project 2 Transpika Solutions

GETTING STARTED

1. Save the file SC_EX365_EOM1-2_FirstLastName_1.xlsx as SC_EX365_EOM1-2_FirstLastName_2.xlsx

a. Edit the file name by changing “1” to “2”.

b. If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.

2. With the file SC_EX365_EOM1-2_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.

a. If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS

1. Amirah Martin is a software trainer for Transpika Solutions, a bus routing software company that works with school transportation offices throughout the United States. Amirah travels frequently to train clients on how to use Transpika's software. She has created a worksheet to track her travel expenses and asks for your help in completing it. Go to the Travel Expenses worksheet. Merge the cells in the range A1:G1.

2. In cell A14, enter 6/3/2028 as the date. [Mac Hint: The date will be in the 6/3/28 format.]

3. Apply the Accent 2 cell style to the range A9:G9.

4. In cell B10, use Conway CSD as the complete entry for the cell. In cell C10, enter 87 as the number of Miles Driven.

5. In cell D10, enter a formula without a function that multiplies the number of miles driven (cell C10) by the current mileage rate (0.55). Use the Fill Handle to fill the range D11:D16 with the formula in cell D10.

6. Apply the Accounting number format to the range D10:G16.

7. In cell D17, enter a formula using the SUM function to sum the Mileage Expense (the range D10:D16). Fill the range E17:G17 with the formula in cell D17.

8. In cell B21, change the font to Arial Black. Copy the value in cell B4 and paste it in cell C21.

9. Change the style of the pie chart in the range A23:D36 to Style 4.

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 website to submit your completed project.

Final Figure 1: Travel Expenses