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

Does siemens own bosch - Examples of time connectives - Essay #1: Ethics Lit. - Little animals activity centre - 2009 general maths hsc answers - Theories and techniques of counseling corey - Cultural & Ethnic Contexts - Force - Gorilla playing drums cadbury advert - Rules that dictate sentences - Whitley county consolidated schools - Richard fitzsimmons merrill lynch - The null and alternative hypotheses divide all possibilities into: - COM 201: The Power of Effective Speaking - Math practice for economics activity 14 answer key - 568a vs 568b performance - Midnight time 24 hour clock - English Essay - A Dolls House - Read write inc assessment sheet - Hooked on gadgets and paying a mental price - Mosque tower crossword clue - History 1302 - ASSIGNMENT 8/9/20 /2 - Access grader project chapter 3 - Eyeball covering crossword clue - Balancing equations practice worksheet chemfiesta - A miracle in town nativity - Biblical meaning of the name tracey - Soft and hard capital rationing - Https hbr org video 5236216251001 what makes a leader - Project Work - Match each retail term with the correct definition - Edith hollander frank biography - Romeo and juliet essay prompts 9th grade - Extra linguistic elements of communication - MTH/110 Week 2 Discussion - Ikea case study harvard business school - What happens to mrna after it completes transcription - Paint per square metre - Sunflower paintings by famous artists - 1 2-dichlorobutane structural formula - Security Architecture & design - Loading and unloading employment - Mehrabian a 1972 nonverbal communication new brunswick aldine transaction - Population per square mile china - Identify the bsha core courses - Create a 10- to 12-slide presentation with speaker notes Smart Parking Space App Presentation - A terre wilfred owen analysis - Three major types of governmentsinging in the rain characters - Purchased merchandise from boden company for $6 000 - Was jesus born in south africa - Aquafresh white trays where to buy - Exercises - Austin brown unchained melody - ?? same-day +27833173182 MASVINGO ABORTION CLINIC // PILLS,,,, - Enterprise Risk Management - Master slave jk flip flop truth table - Work breakdown structure examples restaurant - Naoh and acetic acid titration - Mafs 912 g co 3.11 - Ethical theory comparison chart - $$$ASSIGNMENT$$$ - Internet - Print network diagram ms project - Where are avon products made - Combinational logic circuit real life examples - How to tell if a sugar is reducing or nonreducing - How to find area of z score on ti 83 - Why do auditors establish a preliminary judgment about materiality - Hard rock cafe case study answers - Fundamentals of organizational behaviour pdf download - Accounting 201 Monopoly - Https icampus strayer edu login - Explain the concept of statistical quality control - Surface tension of tap water - Shimadzu lab solutions operator's guide - Emergency evacuation procedure checklist - Ps music continuing problem answers - Albany kitchens bishops stortford - Cengage diet analysis plus login - New perspectives excel 2019 module 7 sam project 1a - Review the topics and concepts that were introduced throughout the course including study questions, purpose of research, study - Discussion - Essay - Solve x 2 10 - Narrandera shire council general manager - Ms 13 hand signs - Blue gate fields infant school - HRMT - Continuation of part 1 - My contraband - Pnb properties for sale - Learning theories matrix - I never saved anything for the swim back meaning - Why does othello start in the middle of a conversation - Wk 7 forum 2 Catry - Volar by judith ortiz cofer summary - Case Study - Awake my soul piano tutorial - Chinese American Language and Literature Essay