The problem is based on an Excel sheet representing the quantity of products purchased in January by Kumara Stores. We need to answer the following questions: (i) Write the equation to calculate the total cost for January month school bag purchases in cell H4. (ii) Write the formula to get the discounted price for school bags in cell I4, given a 5% discount indicated in cell F11. (iii) Write the equation with functions to calculate the total net value indicated in cell J11. (iv) Determine the appropriate values for `function1`, `value1` and `value2` to calculate the quantity of goods purchased for the 3rd week. The equation is `= function1 (value1:value2)`. (v) Mention two chart types suitable for representing purchased items and quantities for the given weeks.

1. Problem Description

The problem is based on an Excel sheet representing the quantity of products purchased in January by Kumara Stores. We need to answer the following questions:

(i) Write the equation to calculate the total cost for January month school bag purchases in cell H

4. (ii) Write the formula to get the discounted price for school bags in cell I4, given a 5% discount indicated in cell F

1

1. (iii) Write the equation with functions to calculate the total net value indicated in cell J

1

1. (iv) Determine the appropriate values for `function1`, `value1` and `value2` to calculate the quantity of goods purchased for the 3rd week. The equation is `= function1 (value1:value2)`.

(v) Mention two chart types suitable for representing purchased items and quantities for the given weeks.

2. Solution Steps

(i) The total cost for January month school bag purchases is given in cell H

4. Since the question asks for the equation used to calculate this value, and we know from the context that Gross Value is calculated by multiplying Total Items by Item Price. Therefore, the formula for H4 should be:

$H4 = F4 * G4$

(ii) The discount is 5% and is stored in cell F

1

1. The gross value of School Bags is in cell H

4. To calculate the discount for school bags and store it in I4, we multiply the Gross Value by the discount percentage:

$I4 = H4 * F11$

(iii) The total net value is the sum of the Net Values for each item. The net values for each item are in cells J4 to J

9. Therefore, the formula for cell J11 is:

$J11 = SUM(J4:J9)$

(iv) To calculate the quantity of goods purchased for the 3rd week, we need to sum the values in column D (3rd week) from D4 to D

9. Thus, the equation is:

$=SUM(D4:D9)$

Therefore:

`function1` = SUM

`value1` = D4

`value2` = D9

(v) Two chart types that can be used to represent purchased items and quantities are:

* Column Chart: This chart type is useful for comparing the quantities of different items for the given weeks.

* Line Chart: This chart type is useful for showing the trend of quantities purchased over the four weeks for each item.

3. Final Answer

(i) $H4 = F4 * G4$

(ii) $I4 = H4 * F11$

(iii) $J11 = SUM(J4:J9)$

(iv) function1 = SUM, value1 = D4, value2 = D9

(v) Column Chart, Line Chart