Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Zip to zip miles excel

07/12/2021 Client: muhammad11 Deadline: 2 Day

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

Swearingen_EXP19_Excel_Ch12_ML2_HW_TravelExpense.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
Swearingen_Exp19_Excel_Ch12_ML1_Sorority_Dues.zip
Exp19_Excel_Ch12_ML1_Sorority_Dues_Instructions.docx
Grader - Instructions Excel 2019 Project

Exp19_Excel_Ch12_ML1_Sorority_Dues
Project Description:
You are the outgoing treasurer of your sorority and as your last task, you would like to create a membership template to enable future treasurers to track memberships, dues, and activities. To reach your goal you will download and customize an Excel template. As part of the customization process, you will create a macro to format text, use VBA to protect the workbook, and inspect the workbook for issues.

Steps to Perform:
Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx. Grader has automatically added your last name to the beginning of the filename.

0

2

Click cell A1, delete the template text, and type Membership Dues.

2

3

Delete Column L.

0

4

Select the range A1:L7 and clear all data validation that was included in the template.

0

5

Add a comment in cell A1 that says "Unprotect the worksheet before editing.". Be sure to enter the comment as it appears, including the period and excluding the quotation marks.

12

6

Use the Macro Recorder to record a macro named Sort that sorts the records in ascending order based on selection (Hint: use relative references when recording the macro).

2

7

Ensure the Developer Tab is enabled, then create a Form Control Button named Sort spanning the cell range C1:D1 (ensure that the button is inside the cell borders), and assign the Sort macro. Be sure the label is displayed on the Form Control Button.

9

8

Use the VBA Editor to insert a new module named Unprotect. To complete the step, type the code as it appears below. Note there is one blank line after the opening declaration (sub Unprotect). The remaining code does not have space between lines. Sub Unprotect() ‘Unprotect Sheet Worksheets("Member List").Unprotect.Password = "eXploring"

0

9

Insert a new module named Protect. To complete the step, type the code as it appears below. Note there is one blank line after the declaration (Sub Protect). The remaining code does not have space between lines. Type the following to complete the procedure. Sub Protect() ‘Protect Sheet Worksheets("Member List").protect.Password= "eXploring"

0

10

Exit the VBA Editor and create a Form Control Button named Unprotect spanning the cell B1. Assign the UnprotectWorksheet macro. Be sure the label Unprotect appears on the Form control button. Then save the file as a macro enabled workbook.

9

11

Create a Form Control Button named Protect spanning the cell E1. Be sure to display the label Protect on the Form Control Button and then assign the Protect macro.

9

12

Use the Document Inspector to check the document for issues. Remove the Document Properties and Personal Information and the Headers and Footers information. Do not remove Comments and Macro information. Note: If using a Mac, please skip this step and proceed to step 13.

2

13

Check the document for Accessibility and compatibility with Excel 2010, 2013, and 2016.

0

14

Insert a new worksheet named Code.

10

15

Open the VBA Editor, open module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1. Then delete the rows that are blank (2,4,5, and 6).

15

16

Open the VBA Editor, open the Protect module, and copy the code. Paste the code in the Code worksheet starting in cell A17. Delete any additional blank rows that appear in the code (row 18).

15

17

Open the VBA Editor, open the Unprotect module, and copy the code. Paste the code in the Code worksheet starting in cell A22. Then delete any additional blank rows that appear in the code (row 23).

15

18

Save and close Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx. Be sure to save the workbook as a .xlsx file, not a macro enabled workbook. Exit Excel. Submit the file as directed.

0

Total Points

100

Created On: 03/26/2020 1 Exp19_Excel_Ch12_ML1 - Sorority Dues 1.3

Swearingen_EXP19_Excel_Ch12_ML1_HW_MembershipDues.xlsx
Member List

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Finance Professor
A+GRADE HELPER
Buy Coursework Help
Study Master
Quick N Quality
Pro Writer
Writer Writer Name Offer Chat
Finance Professor

ONLINE

Finance Professor

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$17 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$34 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$47 Chat With Writer
Study Master

ONLINE

Study Master

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$43 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$26 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$36 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Eastman dental hospital referrals - Who wrote let her go - Jack welch transformational leadership style - Bio-515 Exam - City of derby swimming club - Equal employment opportunity in hrm ppt - Lutron qsps 1 50 - Series and parallel circuits hypothesis - Smart bubble tea cooker - Discussion proof in turnitin - Closing question for interview - Planting caladium bulbs upside down - Glass wool insulation density kg/m3 - Www nbcsd k12 ms us - Countries with autocracy based governments have - Confidor for harlequin bugs - What magic trick does mr utterbunk perform - Minimum Word report on Market Analysis Research - Dcm personal care sdn bhddcm personal care sdn bhd - Ansi asq z1 9 pdf - I need 1200 words essay in Foundation of Army Leadership - Discuss the impact of cloud processing environments on application security. Be sure to define cloud computing, application security, and the various types of implications. - Stanford mobile inquiry based learning environment - SHOSHANGUVE ABORTION CLINIC +27717852514 ABORTION PILLS FOR SALE IN PRETORIA, SUNNYSIDE, BENONI, ATTERIDGEVILLE, MAMELODI, SHOSHANGUVE. ARCADIA, LAUDIUM - Severn suzuki speech text analysis - Classroom connections kath murdoch - Equipment iq oq pq template - Australorp breeders western australia - Financial analysis worksheet - Bus to neutral bay - Network traffic to hcibench 2003 is blocked - Excel wbs formula - Alvar aalto between humanism and materialism pdf - Direct material price variance - Schroder fixed income fund - What is the world's saddest candy worksheet answers - Critical Paper - What is a competitive profile matrix - Mona lisa mona lisa men have named you - Creative problem-solving and decision-making skills action plan - The PICOT - What is the purpose of dhs and dhs programs - Nick scali bedroom suites - Capital structure of apple inc - Byte of accounting inc answers - Prepare a trial balance at april 30 2014 - Cubs 1914 club seating chart - Excessive piston ring groove width - Organization and leadership - Planet fitness deals march 2018 - Teaching plan format for nurses - Block design vs visual puzzles - Series parallel combination circuits lab report - Sorenson goldsmith integrated budget model - To what does angelou compare her argument with the receptionist - Promotion proposal for employee - Two minutes hate quote - Suppose that intel is considering building - University of central missouri scholarships - Case study on biomedical ethics in the christian narrative - Research proposal - 1 million steps in km - Breeding bird survey codes - Systems of linear equations real world applications - Blaine company had these transactions pertaining to stock investments - Glass container used in laboratories crossword clue - Nursing essay - What is percent error - Fable 3 neutral wings - Team rocket kekeke pokemon go - Underline the collective nouns - Topworx dxp installation manual - Culture of israel ppt - Twisted chopsticks east vic park - Medical assistant creed and code of ethics - Assignment - The sniper liam o'flaherty questions - Gibbs free energy unit - Examples of ethnic boundary markers - When did cyclone tracy hit darwin - Common root words and word origins - The postmortal drew magary pdf - Week 4 discussion - Reflective Journal 3 - Leadership's Role in Organizational Change - Legal consequences of unethical police actions - Pico question examples stroke - Volume of truncated cone - Strategic group map restaurant industry - What size is a0 in cm - Healthcare Financial Management and Decision Making - Module 1 assignment 1 leadership self assessment - Advanced Business Statistics - Music2Go Situation Analysis and Marketing Plan - The day i was born essay - Donabedian model of patient safety - How to explain emotive language - Mintzberg managerial roles ppt - Question 1 - Counterbalancing within subjects design