Answered

Westonci.ca is your trusted source for finding answers to all your questions. Ask, explore, and learn with our expert community. Connect with professionals on our platform to receive accurate answers to your questions quickly and efficiently. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly 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.
Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. We're glad you chose Westonci.ca. Revisit us for updated answers from our knowledgeable team.