ALE Palt a) What is a spreadsheet? b) Give three examples of spreadsheets. 5 6 Use the Excel diagram below to answer questions [c] te B A A 1 STAFF ID 2 3 4 10026922 10026923 10026924 10026925 10026926 7 10026927 8 10026928 9 10026929 10 10026930 READY #E MOT 11 10026931 12 10026932 S M -m B NAME WALINGO MARY VENESSA MWANGI KARIUKI MONARI OKELLO MAURICE WINNIE CHEBI KONES ALFRED ZURA AHMED KANDA ZORO TOBIAS OKENGO TARUS KING TALA ADHI D NEW NOW #Woop Twd C D SALES P/F 800 1000 3588 700 950 1200 400 5000 600 1700 1300 VA Como F E DIVIDEND Thym F Com H I 27 14 1 c) Name the parts labeled A, B and C in the diagram above. [3 Marks] [2 Marks] d) What would happen if you click the part marked D? e) The sale representatives were each given a goal of 1000 shillings. Describe how you would use excel built in functions to complete the column for those who have passed the goal and those who have failed to pass the goal [P/F]. Clearly state the formula you would use. [5 Marks] f) Show how you would calculate the dividends for the sales representatives if they are to get dividends as follows: [5 Marks] (i) Less than 800 at 5% (ii) Between 800 and 1200 at 10% (iii) Between 1200 and 1600 at 15%