Answered

Quality of Media Files (12 marks)

(c) State one feature of Microsoft Publisher.
(i) ___________________________

(d) Study the Microsoft Excel worksheet carefully and use it to answer the question that follows.

\begin{tabular}{|l|l|c|c|c|c|}
\hline & \multicolumn{1}{|c|}{ A } & B & C & D & E \\
\hline 1 & NAME OF STUDENT & TERM 1 & TERM 2 & TERM 3 & TOTAL \\
\hline 2 & Kofi Malik & 84 & 75 & 88 & 247 \\
\hline 3 & Ama Ghana & 85 & 74 & 86 & 245 \\
\hline
\end{tabular}

Write a function in Microsoft Excel to determine the lowest termly score for Kofi Malik.



Answer :

GinnyAnswer
To determine the lowest termly score for Kofi Malik using Microsoft Excel, follow these steps:

1. Identify the relevant cells:
- TERM 1 score for Kofi Malik is located in cell `B2`.
- TERM 2 score for Kofi Malik is located in cell `C2`.
- TERM 3 score for Kofi Malik is located in cell `D2`.

2. Use the MIN function:
- The `MIN` function in Excel can be used to find the smallest value in a range of cells.

3. Write the function:
- In any empty cell where you want to display the lowest termly score, write the following formula:

```
=MIN(B2, C2, D2)
```

By entering this formula, Excel will search through the scores in cells `B2`, `C2`, and `D2`, and return the smallest value—a termly score of 75 for Kofi Malik.