Question: Problem 1 (10 points total) Table 1 Create a worksheet called Problem 1. A B A Record a Macro (called Problem_1) 1 2 4.4 1

Problem 1 (10 points total) Table 1 Create a worksheet called Problem 1. A B A Record a Macro (called Problem_1) 1 2 4.4 1 4.4 that swaps the content of the cells 2 4 7.1 2 7.1 A1:A5 with that of the cells B1:B5. 3 -0.3 2 3 2 Use data given in Table 1 to demon- 4 1.7 9 4 9 strate this functionality. You can as- 5 5.5 3 5 3. sume that nothing else is written in the worksheet so that you can use any place in the worksheet to do any formatting operation. B 2 4 -0.3 1.7 5.5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
