Question 7 a) Create the spreadsheet below using Excel. Include the rows and columns identifiers, text formatting and column highlighting as shown. [10 marks] A B C D E F 1 Tesco Revenue by Location between 2018 and 2022 UK & ROI Tesco Bank Total Number Central Europe Year Revenue Revenue Revenue of stores Revenue (Em) 2 (Em) (Em) (Em) W 2018 7,033 38,656 6,343 1,047 46,046 2019 6,993 44,883 6,030 1,097 52,010 UT 2020 4,613 45,752 3,968 1,068 50,788 2021 4,673 48,848 3,862 735 53,445 7 2022 4,752 49,984 3,862 922 54,768 b) What actions or steps in Excel can you take to order the revenue generated by the Tesco Bank division in ascending order. [4 marks] c) State the specific actions or steps in Excel that will produce a list/display of those years where Tesco's Central Europe division generates less than f4,000,000,000 in revenue? [4 marks] d) Which type of graph will be suitable for representing the number of Tesco stores that are open each year? [1 mark] e) In which column might replication have been used? [1 mark] f) How much revenue has Tesco generated overall over the last recorded five years? Write the formula you have used alongside the correct numerical answer. [3 marks]Question 3 a) What type of graph is suitable to show the correlation between the revenue generated by Tesco's UK 3:. RBI division and the revenue generated by Tesoo's Central Europe division over the last recorded ve years? [1 mark] b) Create an appropriate graph to show the correlation between the total revenue generated by Tesco and the number of its stores over the last recorded five years? [5 marks] c} What type of correlation is present between the total revenue generated by Tesco and the number of its stores over the last recorded ve years? [1 mark] [Total Marks for Question 3 = 1"] Question 5 a) Calculate the median generated revenue for each division of Tesco. stating the formula you would use for determining the median revenue for its Bank division. [5 marks] b) Calculate the average generated revenue for each division of Tesco, stating the formula you would use for determining the average for its UK 3. RBI division. [5 marks] :3 Calculate the standard deviation of the total revenue dataset (Column F) using Excel. Use the standard deviation range function. STDE'v'P. to check your answer. [1' marks] d) Provide a denition for the standard deviation of any dataset. You must cite any sources used. [1 0 marks] Question 11] a} Write the Excel function that gives the total number of stores for the years in which the number of stores is less than 5.[i[i. [4 marks] b} Write the Excel function that gives the average total generated revenue for the years in which Tesco's Central Europe division generated more than 4.D,, in revenue. [4 marks] c) Write the Excel function that finds the sum of the generated revenue by Tesco's Bank division for the years where the total number of stores is greater than 5.0%. [4 marks] d} Write the Excel function that searches the spreadsheet to find '2021' and also the corresponding Total Revenue for that year. [5 marks] [Total Marks for Question 1i} = 18] Question 11 a} Produce an appropriate fullyr labelled chart to compare each division's generated revenue over the last ve recorded years. [11} marks] b) Interpret the chart produced in Ha}. Discuss TWICEI probable justications for the behaviour of the data. [4 marks] c} Produce a suitable and fully labelled chart to reflect each division's proportion of the total amount of revenue generated in 2019. [11} marks] [Total Marks for Question 11 = 24]