Question

1. 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.

o A new sheet is created after the "data" sheet and named as "analysis".

o Average of the whole data is calculated and copied to the analysis sheet.

o A line graph is created on the analysis sheet.

Next do the following:

Name the full range of dataset as "monthly data"

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.

Question image 1