Question: 3. Get a dataset for 12 months average temperatures (any country of your choice). Name the sheet as Data and keep your main data on

 3. Get a dataset for 12 months average temperatures (any country

3. Get a dataset for 12 months average temperatures (any country of your choice). Name the sheet as "Data" and keep your main data on this sheet. Do the following tasks: Create a button of macro on the main sheet and when this button is clicked, the following task should be performed. A new sheet is created after the "data" sheet and named as "analysis". Average of the whole data is calculated and copied to the analysis sheet. A line graph is created on the analysis sheet. Next do the following: - Name the full range of dataset as "monthlydata" - Using macros, find max and min of the above range. - Add value of " 10 " in each data point using looping in macros and generate a new dataset on the "analysis" sheet. - Create a button in macro which when clicked "highlights" this new dataset. - Take an input from user for a value. If this value is in the updated dataset (highlighted), display "YES" else display "NO" in the output message

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!