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

Excel chapter 12 grader project

16/10/2021 Client: muhammad11 Deadline: 2 Day

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
Club Name Member List
Member Name Position Dues Paid Member Since (Year) Volunteer Interests Phone Street Address City State ZIP Code Email Address Fax Notes

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:

24/7 Assignment Help
Premium Solutions
George M.
Assignment Hut
Professional Accountant
Innovative Writer
Writer Writer Name Offer Chat
24/7 Assignment Help

ONLINE

24/7 Assignment 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.

$39 Chat With Writer
Premium Solutions

ONLINE

Premium Solutions

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$31 Chat With Writer
George M.

ONLINE

George M.

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

$20 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$41 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$31 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

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

$23 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

Dnv gl business assurance india pvt ltd - Group project one page submission - 5.6 on the richter scale - Political Science Assignment Week 3 - Cisco show arp interface - Batley girls high school sixth form - Irac example duty of care - W7 Research Case - Personal narrative - The zinger corporation is considering an investment that has the following data: - Viscosity of water at 100 degrees celsius - Aws pci dss compliance - English syllabus stage 6 - Examples of parallel plots - Ametek rotron regenerative blower - Po box 9822 melbourne - Relaxation station massage chairs - Triumph t150 electronic ignition - Change Theory - +91-8890675453 love marriage problem solution IN Tumkur - Revise your topic to include the journal motivation with references for your topic. - Unix timeshare - What greek myth inspired monteverdi's first opera - Should students have phones in class - Api 17g 3rd edition - CASE STUDY 7 - According to the lecture univisión's headquarters are in ___________________ - MKTG201 Week 1 Discussion - James joyce dubliners sparknotes - How to date a browngirl whitegirl or halfie - Pre lab activity worksheet cells - 400+ words answers - The __________ on packages were intended to improve inventory control for businesses. - Falcon bms 4.33 keyboard layout - Notice for breach of duty to landlord - Precalculus - Chemistry - Euro tyre centre punchbowl nsw 2196 - Brophy and good 1986 - Cango week 8 final report - The editing technique of joining together two shots is called - Alice 3 free download - Danny shadow health cough - Draw the major product s of nitration of benzonitrile - The life of buddha bbc documentary worksheet answers - 3 types of interdependence - Network pro exam answers - The romance of tristan and iseult pdf - Before the flood resources - Grand canyon university lesson plan template - Herzberg's two factor theory proposes that - Parable of the ten virgins historical context - What is alton towers mission statement - Packers and Movers Services - KstarPackers and Movers - Outliers questions and topics for discussion answers - Enthalpy of decomposition of ammonium chloride - Bus 475 week 2 individual assignment - John monash science school uniform - Avant garde music examples - E Documents - Transfer function of spring mass system - Apple compensation philosophy - Coach k vs coach knight - Sylvia plath youtube - N gregory mankiw principles of economics 6th edition pdf - Real time physics lab 2 homework answers - Northeastern lumber manufacturers association - Ahima vlab academy - Homage to my hips analysis - Continental drift pangea map - Sabe dónde hay un buen restaurante - Rules of the game amy tan activities - Dr mazhar qayyum eye specialist clinic - Huntercombe hospital eating disorders - L4 Homework Scenario Loosely based on a true story- applied epi - Pendleton act of 1881 - Nurse practitioner core competencies 2016 - Anna mcnulty room tour - Probationary review meeting template - Stem cells research - Big mac theory of exchange rates - Cryptography-Discussion - Porter generic strategies 1980 - Death of Archbishop Essay - All preparation equipment lidcombe - Copssh 3.1 4 download - English homework - Strategic Management - Pre demolition audit example - Light and growth lab - Battle of Little Bighorn - Pacific global HEALTH +27835179056 SAFE ABORTION CLINIC//PILLS Mkuze Mtubatuba St Lucia Ubombo Balgowan cape town limpopo - Polmont park medical group - Financial accounting chapter 8 solutions - WEEK II PART 2B - Translink day ticket price - Hieo - Ambu cuff pressure gauge - How to build a logistics network - Marvel make your own superhero