Create a new sheet called Store Data and copy the data from the file 1962_2006_walmart_store_openings.xIsx and paste as values onto the new sheet. Using a lookup formula, add the city of each of the stores to the data set. Add columns to the table containing the data set for the following calculations. Remember to provide each column with a heading. Q.4.1 Add a column to the table that displays "Holiday" if the value in the IsHoliday column is 1 ; otherwise remains empty. (5) Q.4.2 Add a column to the table that calculates the temperate in degrees Celsius, based on the temperature in degrees Fahrenheit in the Temperature column. The formula is: Temperature in Celsius =( Temperature in Fahrenheit −32)× 9
5
​