n viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Bradet Instructors Excel 2019 Pd Exp19_Excel_Ch12_ML_Travel_Expense Project Description: You are a financial analyst for VJD Financial, a wealth management company with 10 offices located across the United States Currently your traveling account executives send receipts through inner office mail to document their travel expenses. You want to create a template to standardize the documentation process. To minimize the amount of development time required you will download and edit an existing template from Office.com You will customize the template by editing fields, adding comments, and creating a custom function using VBA Steps to Perform: Step Instructions Points Possible 1 2 0 3 4 4 4 11 5 12 6 0 0 Start Excel Download and open the file named Expt9 Excel Ch12 ML2 HW TravelExpense xlsx Grader has automatically added your last name to the beginning of the filename. Select the range A1J16 and clear all data validation that was included in the worksheet Click cell B7 and type Mileage Rate. Click cel C7 dick Align Lett in the Alignment group, and type 25 Insert a column after column Name the column Miles Use the VBA Editor to create a custom function named Mileage Type the following code to create the custom function Function Mileage (Miles Rate) "Creates custom Mileage function Mileage - Miles Rate Exit the VBA Editor and click cell F11. Type -FERROR(Mileagef, dick cell E11, type, and then click cell C7 Press F4, and type ), 0)Press ENTER to complete the function Click cell E10 and add the comment Enter miles driven Insert a new worksheet named Code Open the VBA Editor, open module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1 Save and dose EXP19_Excel_Ch 12_ML2_HW_TravelExpensexdsx. Exit Excel Submit the file as directed 7 20 8 B 18 9 10 10 25 11 0 Total Points 100 B D F G H Employee Name Employee ID Start on Trip dates End on Purpose Expenses at a glance Total trip days Transportation Expense $0.00 Lodging Expense $0.00 Meal Expense $0.00 TOTAL TRIP EXPENSES $0.00 Meals Transportation to (destination) Lodging $ Date From (origin) Breakfast Lunch Dinner Snacks 13 15 $0.00 12 $0.00 $0.00 $0.00 $0.00 $0.00 Travel expense calculator n viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Bradet Instructors Excel 2019 Pd Exp19_Excel_Ch12_ML_Travel_Expense Project Description: You are a financial analyst for VJD Financial, a wealth management company with 10 offices located across the United States Currently your traveling account executives send receipts through inner office mail to document their travel expenses. You want to create a template to standardize the documentation process. To minimize the amount of development time required you will download and edit an existing template from Office.com You will customize the template by editing fields, adding comments, and creating a custom function using VBA Steps to Perform: Step Instructions Points Possible 1 2 0 3 4 4 4 11 5 12 6 0 0 Start Excel Download and open the file named Expt9 Excel Ch12 ML2 HW TravelExpense xlsx Grader has automatically added your last name to the beginning of the filename. Select the range A1J16 and clear all data validation that was included in the worksheet Click cell B7 and type Mileage Rate. Click cel C7 dick Align Lett in the Alignment group, and type 25 Insert a column after column Name the column Miles Use the VBA Editor to create a custom function named Mileage Type the following code to create the custom function Function Mileage (Miles Rate) "Creates custom Mileage function Mileage - Miles Rate Exit the VBA Editor and click cell F11. Type -FERROR(Mileagef, dick cell E11, type, and then click cell C7 Press F4, and type ), 0)Press ENTER to complete the function Click cell E10 and add the comment Enter miles driven Insert a new worksheet named Code Open the VBA Editor, open module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1 Save and dose EXP19_Excel_Ch 12_ML2_HW_TravelExpensexdsx. Exit Excel Submit the file as directed 7 20 8 B 18 9 10 10 25 11 0 Total Points 100 B D F G H Employee Name Employee ID Start on Trip dates End on Purpose Expenses at a glance Total trip days Transportation Expense $0.00 Lodging Expense $0.00 Meal Expense $0.00 TOTAL TRIP EXPENSES $0.00 Meals Transportation to (destination) Lodging $ Date From (origin) Breakfast Lunch Dinner Snacks 13 15 $0.00 12 $0.00 $0.00 $0.00 $0.00 $0.00 Travel expense calculator