02 Dec 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 thro
Exp19_Excel_Ch12_ML2_Travel_Expense
Exp19 Excel Ch12 ML2 Travel Expense
Excel Chapter 12 Mid-Level 2 – 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.
Start Excel. Download and open the file named Exp19_Excel_Ch12_ML2_HW_TravelExpense.xlsx. Grader has automatically added your last name to the beginning of the filename.
Select the range A1:J16 and clear all data validation that was included in the worksheet.
Click cell B7 and type Mileage Rate.
Click cell C7, click Align Left in the Alignment group, and type .25.
Insert a column after column D. 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 =IFERROR(Mileage(, click 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 close EXP19_Excel_Ch12_ML2_HW_TravelExpense.xlsx. Exit Excel. Submit the file as directed.
Exp19_Excel_Ch12_ML2_Travel_Expense_Instructions.docx
Grader – Instructions Excel 2019 Project
Exp19_Excel_Ch12_ML2_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 |
Start Excel. Download and open the file named Exp19_Excel_Ch12_ML2_HW_TravelExpense.xlsx. Grader has automatically added your last name to the beginning of the filename. |
0 |
|
2 |
Select the range A1:J16 and clear all data validation that was included in the worksheet. |
0 |
|
3 |
Click cell B7 and type Mileage Rate. |
4 |
|
4 |
Click cell C7, click Align Left in the Alignment group, and type .25. |
11 |
|
5 |
Insert a column after column D. Name the column Miles. |
12 |
|
6 |
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 |
0 |
|
7 |
Exit the VBA Editor and click cell F11. Type =IFERROR(Mileage(, click cell E11, type , and then click cell C7. Press F4, and type ), 0). Press ENTER to complete the function. |
20 |
|
8 |
Click cell E10 and add the comment Enter miles driven. |
18 |
|
9 |
Insert a new worksheet named Code. |
10 |
|
10 |
Open the VBA Editor, open module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1. |
25 |
|
11 |
Save and close EXP19_Excel_Ch12_ML2_HW_TravelExpense.xlsx. Exit Excel. Submit the file as directed. |
0 |
|
Total Points |
100 |
Created On: 10/15/2019 1 Exp19_Excel_Ch12_ML2 – Travel Expense 1.0
Ahmed_EXP19_Excel_Ch12_ML2_HW_TravelExpenses.xlsx
Travel expense calculator
| Travel Expense Calculator | |||||||||
| Employee Name | Expenses at a glance | ||||||||
| Employee ID | Total trip days | ||||||||
| Trip dates | Start on | Transportation Expense | $0.00 | ||||||
| End on | Lodging Expense | $0.00 | |||||||
| Purpose | Meal Expense | $0.00 | |||||||
| TOTAL TRIP EXPENSES | $0.00 | ||||||||
| Transportation | Lodging | Meals | |||||||
| Date | From (origin) | to (destination) | $ | $ | Breakfast | Lunch | Dinner | Snacks | |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Exp19_Excel_Ch12_ML2_HW_Travel Expense_Final.jpg
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.