(a) Use the information in the spreadsheet below to answer questions 5(a) i-v. A B C D E F G H I 1 S/N NAME SEX MATHEMATICS ENGLISH BIOLOGY ECONOMICS TOTAL ...

This question tests two practical skills: writing spreadsheet formulas/functions in a program such as Microsoft Excel, and identifying the parts of a presentation program (Microsoft PowerPoint) from a screenshot. The exact cell addresses depend on the layout of the spreadsheet supplied in your paper, so match the column and row letters below to the actual positions of the names and subjects in your sheet.

Part (a): spreadsheet formulas

• (i) Total score in Mathematics. A total is a sum of a column (or row) of marks. If the Mathematics scores for all candidates run from cell C2 to C7, the formula is \( =SUM(C2:C7) \). Every spreadsheet formula must begin with an equals sign.
• (ii) Paul's average of four subjects (two possible formulas). Suppose Paul's four subject marks are in cells B2, C2, D2 and E2. You may use the dedicated function \( =AVERAGE(B2:E2) \), or compute it manually as \( =(B2+C2+D2+E2)/4 \). Both give the same result.
• (iii) Highest score in English. The function that returns the largest value in a range is MAX, for example \( =MAX(D2:D7) \).
• (iv) Vera's total in all subjects, result in H8. Click the cell H8, type an equals sign, then use the SUM function on Vera's row of subject marks, e.g. type \( =SUM(B8:G8) \) and press Enter. The total appears in H8.
• (v) Pass/fail on an average pass mark of 60. Use the IF function to test Etta's average. If Etta's average is in cell I6, then \( =IF(I6>=60,\text{"Passed"},\text{"Failed"}) \). The condition returns "Passed" when the average is 60 or more, otherwise "Failed".

Part (b): the application in the diagram

• (i) The application shown is a presentation program, Microsoft PowerPoint (the give-away is the slide, slide pane and the Insert tab).
• (ii) One use: to design and deliver a slide show for lectures, seminars or business presentations.
• (iii) To launch from a desktop shortcut: point to the PowerPoint shortcut icon on the desktop and double-click it (or right-click and select Open).
• (iv) Default slide: the Title slide (containing a title and subtitle placeholder).
• (v) and (vi) depend on the specific part labelled I in your diagram; a very common labelled control is Save, whose keyboard shortcut is Ctrl + S. Read the label in your paper before answering.
• (vii) Three functions of the Insert tab: insert a picture/image, insert a table, and insert a new slide (also shapes, charts, header and footer, or a text box).

Examination reminder: every spreadsheet entry that computes a value must start with \( = \), and you must quote a cell range (like C2:C7) not the words. Because the actual cell addresses come from the printed sheet, always substitute the real column letters and row numbers shown in your question.