2) Using Pivot Table to derive the information of Business Type - Apartment across timeline a...

Transcribed Image Text:

2) Using Pivot Table to derive the information of "Business Type - Apartment" across timeline a b C d d Column C: the values are the total insured value for Apartment at each month in 2021. Calculate Column D: the average should be average of the monthly Total InsuredValue, which is the average of Range C28:C39 Column E: the upper limit is Average *1.1; Column F: the Lower Limit is Average*0.9 Build Performance vs. Acceptable Levels chart Build the Thermometer Chart of Total InsuredValue, Using Average(Column D) as the Target Apartment Expiry Total InsuredValue Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Average Upper Lower Insured Value By construction 2) Using Pivot Table to derive the information of "Business Type - Apartment" across timeline a b C d d Column C: the values are the total insured value for Apartment at each month in 2021. Calculate Column D: the average should be average of the monthly Total InsuredValue, which is the average of Range C28:C39 Column E: the upper limit is Average *1.1; Column F: the Lower Limit is Average*0.9 Build Performance vs. Acceptable Levels chart Build the Thermometer Chart of Total InsuredValue, Using Average(Column D) as the Target Apartment Expiry Total InsuredValue Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Average Upper Lower Insured Value By construction