By using excel function solve the following.
Q1 Suppose you have a list of expenses in cells A1 to A5 ,in cell B1, calculate the total expense, in B2 calculate Max, in B3 calculate Average
| A |
|——-|
| 50 |
| 30 |
| 20 |
| 40 |
| 25 |
Answer
Q2
Suppose you have a project with different cost categories and their corresponding expenses:
| A
|———-| Category
| Labor
| Supplies
| Equipment
| B |
|——–|
|Amount |
|5000 |
| 1500 |
| 2000 |
In cell B5, what is the total project budget:
Q3 Suppose you have a list of test scores in cells A1 to A5 what is the lowest score in B1:
| A |
|——-|
| 85 |
| 92 |
| 78 |
| 65 |
| 88 |
Purchase answer to see full
attachment
