Please follow the instructions carefully

This criterion is linked to a Learning OutcomeSTEP 1a-b: Import Data from text file

6.0 pts

This criterion is linked to a Learning OutcomeSTEP 1c: Create column and separate first and last names into two columns

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 1d: Capitalize ONLY first letter in address names

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 1e: Create City, State, zip columns and separate data to these fields

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 1f: Change JG initials to “Jesse Gonzales”

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1g: Add statistics to sum up sales and calculate Gonzales commission at 7%

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 1h, i: Change sheet name and apply a business-like theme for the overall sheet. Ensure all data in the sheet is appropriately formatted.

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 1j: Create a Pivot Table to show Gonzales sales by Development

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a-l: Create & Record Macro

6.0 pts

This criterion is linked to a Learning OutcomeSTEP 3a-f: Draw Macro button

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 3g-i: Associate Macro with button

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a,b: Save as .xlsm file type

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 4c: Unlock user input cells and protect sheet

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 5a-c: Insert and create documentation sheet

5.0 pts

This criterion is linked to a Learning OutcomeSTEP 5d-j: Create watermark

6.0 pts

This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab

5.0 pts