please answers these questions and follow the instructions b
please answers these questions and follow the instructions belowVIEW:InstructionsPrevious AttemptsBest PracticesIndependent Project 8-5These instructions are compatible with both Microsoft Windows and Mac operating systems.Courtyard Medical Plaza developed a trainer’s worksheet for personalized workout plans. You record and edit macros for a macros-only workbook and run the macros in the trainer’s workbook.[Student Learning Outcomes 8.1, 8.2, 8.4, 8.5, 8.7]File Needed: CourtyardMedical-08.xlsx (Available from the Start File link.) and Excel 8-5Macros.xlsm (Downloaded from the Resources link)Completed Project File Names: [your name]-CourtyardMedical-08.xlsxSkills Covered in This ProjectSet macro security options.Create a macros-only workbook.Record a macro with relative references.Run macros with keyboard shortcuts.Edit a macro in the Visual Basic Editor. Open the CourtyardMedical-08 workbook and click the Enable Editing button. The file will be renamed automatically to include your name. Open the Excel 8-5Macros.xlsm file downloaded from the Resources link. This file is an Excel macro-enabled workbook. Display the Developer tab and verify that macro security is set to Disable all macros with notification. Activate the Use Relative References command and select cell A1.Record a macro with relative references. Record a macro named Titles with a shortcut of Ctrl+Shift+T in This Workbook. Type Enter column titles for the Description and click OK. Type Activities and press the right arrow key. Type Calories and press the right arrow key. Type Times and press the right arrow key. Type Burned and press the right arrow key.Figure 8-58 Data is entered as macros are recorded Press the left arrow key four times to return to the “Activities” label. Select cells A1:D1 and apply bold and italic. Stop recording. Select cell A4 and record a macro with relative references named Activities with a shortcut of Ctrl+Shift+A in This Workbook. Type Enter activities for the Description. Type the labels shown here and press Enter after each one to move from row to row. Backspace to correct a typing error before you press Enter. Errors that you notice after you press Enter can be corrected later in the code window.Dance FusionHigh Intensity IntervalPilates/YogaRunningStrength TrainingSwimmingWater AerobicsFigure 8-59 Documentation for the macros workbook Stop recording (Figure 8-58). Turn off Use Relative References. Select cell F1 and type Titles Macro. Remove bold and italic from cell F1. Select cell F2 and type Ctrl+Shift+T. Select cell F4 and type Activities Macro. Type Ctrl+Shift+A in cell F5 (Figure 8-59). Edit the Titles macro in the Visual Basic Editor to change the word “Activities” to Activity. Correct other typing errors as needed. Size the Code window in the Visual Basic Editor so that you can see both macros. Print the code [File menu] if instructed to do so (Figure 8-60).Figure 8-60 Print code from the File menu in the VBE Close the Visual Basic Editor to return to the worksheet. Edit cell A1 to display Activity. Save the macros-only workbook and leave it open. Return to the your.name-CourtyardMedical-08 file you opened in step 1.Run the Titles macro. Click cell A3 and press Ctrl+Shift+T. Run the Titles macro starting in each of cells F3, A15, and F15.Run the Activities macro. Click cell A4 and press Ctrl+Shift+A. Run the Activities macro starting in each of cells F4, A16, and F16. Save and close the macros-only workbook (Excel 8-5Macros.xlsm). Hide the Developer tab. Save and close the your.name-CourtyardMedical-09 workbook (Figure 8-61). Upload and save your project file. Submit project for grading.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
