Utilizing "expert" features in Excel such as text importing (outstanding condo sales results for Jesse Gonzales), cell protection and macro generation (X Game Calculator).
Description
Scenario/Summary
Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. 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 fool proof for all those using it.
Just like traversing a double black diamond slope, you have the Excel knowledge to manoeuvre all of these tasks with excellence. This lab is for experts only.
Deliverables
After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week7_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week7_Lab.xlsx.
|
LAB 7 Expert Features in Excel |
||||
|
Step |
Task |
Points Possible |
Points Received |
Comments |
|
1 |
Import and Organize Data |
|||
|
1a
– b |
Import Data |
5 |
||
|
1c
-i |
Professional
Clean up & Formatting |
5 |
||
|
2 |
Create Macro for X Games Calculator |
|||
|
2a
– l |
Create & Record Macro |
6 |
||
|
3 |
Assign Macro |
|||
|
3a
– f |
Draw
Macro button |
5 |
||
|
3g
– i |
Associate
Macro with button |
5 |
||
|
4 |
Save Macro enabled file & Protect Calculator |
|||
|
4a,
b |
Save
as .xlsm file type |
3 |
||
|
4c |
unlock
user input cells |
4 |
||
|
4d |
Associate
Macro with button |
4 |
||
|
5 |
Create a Documentation Sheet – Apply Watermark |
|||
|
5a-c |
Insert
and create documentation sheet |
4 |
||
|
5d-j |
Create
watermark |
4 |
BIS 155 Week 7 iLab | Summit Ridge Mountain Resort
Related ProductsTags: BIS 155 Week 7 iLab, BIS155 Week7 iLab, BIS 155 Week 7 iLab Summit Ridge Mountain Resort, BIS 155 Week 7 Summit Ridge Mountain Resort, BIS 155 Week 7 iLab expert features in excel, outstanding condo sales results for Gonzales, X Game Calculator sheet with a macro. MessageAll members who signed up before 2023 are requested to register again. | |