Shelly Cashman Excel 2019 | Module 1: End of Module Project 2 RetailPro COMPLETE A TRAVEL EXPENSE WORKSHEET GETTING STARTED ? Open the file SC_EX19_EOM1-2_ FirstLastName _1

Subject:MS ExcelPrice:19.99 Bought12

Share With

Shelly Cashman Excel 2019 | Module 1: End of Module Project 2

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.

Shelly Cashman Excel 2019 | Module 1: End of Module Project 2

 

Shelly Cashman Excel 2019 | Module 1: End of Module Project 2

Final Figure 1: Travel Expenses Worksheet