Answered

At Westonci.ca, we provide clear, reliable answers to all your questions. Join our vibrant community and get the solutions you need. Join our platform to connect with experts ready to provide precise answers to your questions in various areas. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

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.

Sagot :

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.
We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. We're dedicated to helping you find the answers you need at Westonci.ca. Don't hesitate to return for more.