Shelly Cashman Excel 2019 | Module 1: End of Module Project 2 скачать в хорошем качестве

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

Please contact us if you need this project or any other project in any subject to be completed. Whatsapp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 #shellycashmanexcel2019 #module1endofmoduleproject2 2 #RetailPro Shelly Cashman Excel 2019 | Module 1: End of Module Project 2 RetailPro COMPLETE A TRAVEL EXPENSE WORKSHEET 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.