Answered

Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Get quick and reliable answers to your questions from a dedicated community of professionals on our platform. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

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 choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.