Excel flashcards: Which function do you need?

A few questions from this set

• Which function do you use?You want to add up a column of numbers.
• Which function do you use?You want to know how much a customer paid on average.
• Which function do you use?You're looking for the price that goes with a product code. The codes are on the left of your table.
• Which function do you use?If the score is above 50, it should say Pass, and otherwise Fail.
• Which function do you use?You want the total of only the rows for Leeds.
• Which function do you use?You want to count how often Leeds appears in a column.