Exp19_excel_ch12_ml2_travel_expense | Computer Science homework help

 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.

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Quality Essay Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At Quality Essay Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.

Admissions

Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.

Editing

Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.

Coursework

Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.