Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month Product 1 Product 2 Product 3 April 1000 1500 2000 May 1500 2000 2500 June 2000 3000 2500 July 2500 4000 2500 August 3000
Month | Product 1 | Product 2 | Product 3 |
April | 1000 | 1500 | 2000 |
May | 1500 | 2000 | 2500 |
June | 2000 | 3000 | 2500 |
July | 2500 | 4000 | 2500 |
August | 3000 | 3000 | 2500 |
September | 4000 | 6000 | 5000 |
Using the data to the left, in columns A to D: | ||||
Record a Macro, and perform the steps below: | ||||
Delete Line 1 and Line 2 | ||||
Bold Month & Products (1, 2 & 3) | ||||
Sum total each Product (1, 2 & 3) on Line 10 | ||||
Stop recording the Macro |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started