Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance withinthe resort. He is now very confident handing over complex tasks to your capable hands.This week he is requesting that you exercisesome expertskills. It seems he has some data that needs to be imported and cleaned up so that it is useful to the resort. He has quite a list of tasks he needs done with this data. Once the data are presentable the analysis needs to be summarized in a short memo and placed on the last sheet in the workbook.
Additionally your manager has also heard that macros can be added to a worksheet. He wants to make the X Games calculator even more efficient and foolproof for all those using it.
Just like traversing adouble black diamond slope you have the Excel knowledge to maneuver all of these tasks with excellence. This lab is for experts only.
Deliverables
NOTE
Submit your assignment to the Dropbox located at the top of this page. For instructions on how to use the Dropbox read these
Associate this button with the macro. Right-click on the shape and select Assign Macro from the menu.
Select CalcWipe and click OK to assign the macro to the button.
To prepare to test the macro provide input into cells E4 and E6 by selecting a ticket type in cell E4 and enter a quantity in cell E6 for starting values. Then test your macro by simply clicking the button. Did it clear the contents of your input cells? If yes congratulations on creating your first macro. If no please return to Step 2 Part E to build the macro again.
Step 4: Save the Macro-Enabled File and Turn on Protection in the X Games Calculator Sheet
Step 5: Create a Documentation Sheet and Apply a Footer With Watermark Ski Image
Clean up the formatting of your Excel workbook taking into account professional appearance.
The Minimum Requirement (per the Grading Rubric)
Transcript
Step 6: Summarize and Write Memo
Return to the worksheet named Gonzales. The analysis on this worksheetneeds to be summarized in ashort memo. Here are some details and ideas about the memo to be written.
Finish and Submit
Save your Excel file as aMacro-enabledworkbook!! Your Excel file should contain fourworksheets.
Submit one Macro-enabled Excel file to the Dropbox. When submitting the file provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe then your file should be named very similar to Doe_J_Week7Lab.xlsm.