QUESTION 1 (20 MARKS) STONE MENTORY STATEMENT TEGER NO CORT 2011 . SLIITTI ALLT 19/ I DOBRE 13 TETT BEST CM Figure 1 Based on the above Figure 1, write the formula for each of the following cells:- . Explain the steps to enter the dates as shown in column E (from cell E6 to cell 09). (8 marks) Write down the formula to calculate the values in the following cells: D7 DII B13 (6 marks) Write the IF function to calculate the value of closing inventory in cell CIS. (6 marks) QUESTION 2 (20 MARKS) QUESTION 1 (20 MARKS) STONE MENTORY STATEMENT TEGER NO CORT 2011 . SLIITTI ALLT 19/ I DOBRE 13 TETT BEST CM Figure 1 Based on the above Figure 1, write the formula for each of the following cells:- . Explain the steps to enter the dates as shown in column E (from cell E6 to cell 09). (8 marks) Write down the formula to calculate the values in the following cells: D7 DII B13 (6 marks) Write the IF function to calculate the value of closing inventory in cell CIS. (6 marks) QUESTION 2 (20 MARKS)