Contact Us:
CONTACT for help AT WHATSAPP: +923015300014
Direct WhatsApp Link : wa.me/+9230153...
Email : myit799@gmail.com
#Exp22_Excel_Ch12_CumulativeAssessment_Business_Travel_Budget_Solution_KZitemVideo #Exp22_Excel_Ch12_CumulativeAssessment_Business_Travel_Budget_Sol
#Exp22 Excel Ch12 CumulativeAssessment Business Travel Budget
#exp22_excel_ch12_cumulativeassessment_business_travel_budget
#Exp22ExcelCh12 #cumulativeassessment #business_travel_budget #exp22excelch12 #excelchapter12 #excelch12 #BusinessTravelBudget
#Exp22 excel ch12 #business_travel #travel_budget #exp22excel #ch12
1 Start Excel. Download and open the file named EXP22_Excel_Ch12_Cumulative_Budget.xltx. Grader has automatically added your last name to the beginning of the filename.
2 Delete the sample values in the range B6:E15 and cell D2.
3 Clear all existing data validation in the range A1:K15.
4 Record a macro named Sort, be sure to use relative references. Ensure the macro sorts the data in descending order based on Amount (column F). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template.
5 Create a form control button that spans the cell J4:L5. Assign the Sort macro and edit the button text to Sort.
6 Use the VBA Editor to create a new module.
Type the following VBA code to create a custom Mileage function then save and exit the VBA Editor (be sure to leave a blank line between each line and before End Function):
Function Mileage (Miles, Rate)
'This function will calculate mileage reimbursement
Mileage = Miles * Rate
7 Type Mileage Calculator in cell F4.
8 AutoFit the width of column F.
9 Click or select cell G4 and test the newly created mileage function by calculating the reimbursement amount for 45 miles traveled at a reimbursement rate of .75 per mile. Delete the value in cell G4 after testing the function.
10 Use the VBA Editor to create a new module named ProtectWorkbook. Type the following VBA statements to create the sub procedure (leave appropriate line spacing).
Sub ProtectWorkbook()
'Protect workbook using the password Expl0r!ng
Worksheets("Business Trip Budget").Protect Password:="Expl0r!ng"
11 Insert a new module named UnprotectWorkbook. Type the following VBA statements to create the sub procedure and then save and exit the VBA Editor (leave appropriate line spacing).
Sub UnprotectWorkbook()
'Unprotect workbook using the password Expl0r!ng
Worksheets("Business Trip Budget").Unprotect Password:="Expl0r!ng"
12 Insert a Form Control Button spanning cells J7:L8 named Unprotect. Assign the UnprotectWorkbook macro to the newly created Control Button.
13 Insert a Form Control Button spanning the range J10:L11 named Protect. Assign the macro ProtectWorkbook.
14 Insert the comment Enter target trip budget in cell D2, insert the comment Please contact your supervisor if over budget in cell D4, and Insert the comment Please use the custom function
=MILEAGE(MILES,RATE) in cell G4.
15 Inspect the document for private information and hidden properties. Remove Document Properties and Personal Information, and Headers and Footers. Do not remove Comments, Macros, Forms, and ActiveX Controls, or Custom XML Data.
Note: Mac users, from the Excel menu, open your preferences, click or select Security, and then click or select the check box to Remove personal information from this file on save. Delete any headers or footers in the workbook.
16 Check the document for accessibility issues. Use the Accessibility Checker pane to Unmerge the Merged Cells.
17 Use the Accessibility Checker pane to assign the Quick Style White Table Style Medium 1.
18 Insert a new worksheet named Code.
19 Open the VBA Editor, open Module 1, and copy the code. Paste the code in the Code worksheet starting in cell A1.
20 In the VBA Editor, open the CustomFunction Module, and copy the code. Paste the code in the Code worksheet starting in cell A22.
21 In the VBA Editor, open the ProtectWorkbook, and copy the code. Paste the code in the Code worksheet starting in cell A30.
22 In the VBA Editor, open the UnprotectWorkbook module, and copy the code. Paste the code in the Code worksheet starting in cell A38.
23 Close the VBA Editor and save the workbook as an xlsx file (not Macro-Enabled).
24 Close EXP22_Excel_Ch12_Cumulative_Budget.xlsx. Exit Excel. Submit the file as directed.
#Exp22_Excel_Ch12_CumulativeAssessment_Business_Travel_Budget
#Exp22_Excel_Ch12_CumulativeAssessment_Variation_Teaching_Schedule
#Exp22_Excel_Ch12_HOE - Invoice 1.0
#Exp22_Excel_Ch12_ML2_Customer Estimate
#Exp19_Excel_Ch12_Cap_Bulldog_Collectibles
#Exp19_Excel_Ch12_CapAssessment_Teaching_Schedule
#Exp19_Excel_Ch12_HOEAssessment_To_Do_List
#Exp19_Excel_Ch12_ML2_Travel_Expense
#Exp19_Excel_Ch12_ML1_Sorority_Dues
#Exp22_Excel_Ch11_ML1_Internships
#Exp22_Excel_Ch11_ML2_Donors
#Exp22_Excel_Ch11_HOE_Halloween
#Exp22_Excel_Ch11_Cumulative - Client FICO Scores
#Exp22_Excel_Ch11_Cumulative_FICO
Негізгі бет Exp22_Excel_Ch12_CumulativeAssessment_Business_Travel_Budget
Пікірлер: 1