Excel Functions Flashcard (M)

Front

John is managing a small store and wants to find out the total sales for the week. He has recorded daily sales in cells A1 to A7. Which Excel function should he use to calculate the total sales?

Back

SUM(A1:A7)

Front

Emily is analyzing her class test scores stored in cells B2 to B10. She wants to find out the highest score. Which function should she use?

Back

MAX(B2:B10)

Front

Michael is creating a budget spreadsheet. He wants to count how many expenses are listed in column C, from C2 to C20, excluding any blank cells. Which function should he use?

Back

COUNTA(C2:C20)

Front

Sarah is tracking her monthly expenses and wants to find out the average amount she spends on groceries. Her grocery expenses are listed in cells D1 to D12. Which function should she use?

Back

AVERAGE(D1:D12)

Front

David is working on a project and needs to determine the minimum temperature recorded over a week. The temperatures are listed in cells E1 to E7. Which function should he use?

Back

MIN(E1:E7)

Front

Lisa is organizing a charity event and wants to count the number of donations that are greater than $50. The donations are listed in cells F1 to F15. Which function should she use?

Back

COUNTIF(F1:F15, ">50")

Front

Tom is calculating the total number of products sold that are priced above $20. The prices are listed in cells G1 to G10. Which function should he use?

Back

SUMIF(G1:G10, ">20")

Front

Anna is preparing a report and needs to find out how many students scored above 75 in their exams. The scores are listed in cells H1 to H30. Which function should she use?

Back

COUNTIF(H1:H30, ">75")

Front

Mark is analyzing survey data and wants to calculate the total number of responses recorded in cells I1 to I50, including some blank cells. Which function should he use?

Back

COUNTA(I1:I50)

Front

Jessica is reviewing her monthly income and wants to find out the total income from all sources. Her income from different sources is listed in cells J1 to J5. Which function should she use?

Back

SUM(J1:J5)