Question: Instructions: Part 1: Excel Macro Creation Open Microsoft Excel. Create a new workbook and enter some sample data in cells A1 to A10. Record a
Instructions: Part 1: Excel Macro Creation Open Microsoft Excel. Create a new workbook and enter some sample data in cells A1 to A10. Record a macro that does the following: a. Sorts the data in ascending order. b. Applies bold formatting to the sorted data. c. Saves the workbook with a desired name. Assign a shortcut key of your choice to the macro. Test the macro by pressing the assigned shortcut key. Ensure that it performs the sorting, formatting, and saving actions as intended. Save the workbook. Part 2: Word Macro Creation Open Microsoft Word. Create a new document and type some sample text. Record a macro that does the following: a. Changes the font color of the selected text to red. b. Inserts a new paragraph after the selected text. c. Saves the document with a desired name. Assign a toolbar button of your choice to the macro. Test the macro by selecting some text and clicking the assigned toolbar button. Ensure that it changes the font color, inserts a new paragraph, and saves the document as expected. Save the document. Submission Guidelines: Save the Excel workbook and Word document with appropriate names. Create a ZIP file containing both the Excel workbook and Word document. Submit the ZIP file as your assignment submission. Part 3: Reflection Create a word document and provide a brief reflection on your experience creating macros in Microsoft Tools. Explain any challenges you faced and how you overcame them, as well as any interesting discoveries you made during the process
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
