Exercise 1 (4 points) The following picture shows the first 17 rows of an IKEA purchase list. Description BELY Boekenkast SALIBD Bak, Set van AGOTNES Foamnatras SONGESAND Bedframe MALM Ladekast HUNE Element FRIHETEN Hoekslaapbank Met Opberger VESTEROY Pocketveringmatras NISSAFORS Roltafel LAGKAPTEN/ALEX Bureau JOKKMOKK Tafel En 4 Stoelen POKING Fauteuil TARNO Tafel 2 Stoelen, Bulten BEKRAFTA Gordijnroedeset Dubbel BSSA Schoenenkast 2 Vakken vanavan Ed Artide number 645.691.409 203.687.519 348.377.537 427.835.619 360.514.280 372.518.805 305.344.600 207.333.336 638.342.359 422.257.736 359.345.628 104.990.210 496.767.463 30.238.111 774.341.708 MI RAK 67) aty 2 1 1 1 1 1 1 1 1 1 1 3 2 Weight (kg) 31.25 6.33 5.1 31.34 47.85 5 115.8 32 5.06 37.3 33.33 35.75 1.M 3.36 15.36 HP Packages 1 1 1 5 1 3 1 1 S 4 1 2 3 1 1 Department Self-service Home organization Self-service Self-service Self-service Self-service Self-service Self-service Self-service Self-service Self-service Self-service Self-service Home textil Self-service Sell, candra ( ( C C ( ( ( C C ( C C C ( Price Total price 55.99 6.79 54.99 349.00 109.00 46.00 629.00 229.00 24.3 C 116.09 249.00 119.99 64.99 19.99 35.99 39.99 13.38 54.99 249.00 309.00 46.00 629.00 229.00 24.99 116.09 249.00 119.99 64.99 39.98 39.99 13044 a. What Excel function(s) would you use to obtain the total price of this purchase, but only considering items that are not in the Self-service department? Please, provide an explanation detailed enough to understand your proposal. b. You need to add the promotions (the reduced price) applied for some of the articles during summer sales. The normal price is applied if an article does not have any promotion. Then, the total price is computed multiplying the number of articles (Qty) and the normal price or the reduced price given by the promotion. For example, a BILLY boekenkast usually has a promotion of 40 euros during summer sales. Then, the total price to pay for only one BILLY boekencast is 40 euros. However, if the boekencast does not have any promotion applied, a customer has to pay the normal price (59.99 euros). Explain how you can update the Excel file to solve this problem. c. What tool you can use to control that the promotional code applied to an article is not greater than the normal price? Explain your proposal.

Exercise 1 (4 points) a. What Excel function(s) would you use to ovien. considering items that are not in the Self-service department? Please, provide an exprauawn. detalled enough to understand your proposal. b. You need to add the promotions (the reduced price) applied for some of the articles during summer sales. The normal price is applied if an article does not have any promotion. Then, the total price is computed multiplying the number of articles (Qty) and the normal price or the reduced price given by the promotion. For example, a BILLY boekenkast usually has a promotion of 40 euros during summer sales. Then, the total price to pay for only one BILLY boekencast is 40 euros. However, if the boekencast does not have any promotion applied, a customer has to pay the normal price (59.99 euros). Explain how you can update the Excel file to solve this problem. c. What tool you can use to control that the promotional code applied to an article is not greater than the normal price? Explain your proposal