You are managing the expenses for a school event and have a list of different costs in a column. You want to quickly find out the total amount spent. - SUM formula, A teacher wants to determine the average score of students in a test from a list of marks. - AVERAGE function, You have a list of daily temperatures recorded for a week. You need to find out the highest temperature recorded during the week. - MAXIMUM (MAX) function., n a list of product prices, you want to round each price to the nearest whole number. - ROUND function, You are tracking attendance in a class, and you have a list of "Present" and "Absent" marks. You need to count how many times students were marked "Present." - COUNTIF function., In a list of exam scores, you want to check if a student has scored more than 50 to determine if they passed. - IF function, You have a long list of student names in one column and their corresponding grades in another. You need to find the grade of a specific student. - LOOKUP function, You need to count out how many students scored above 80 in an exam from a list of scores. - COUNTIF function, You need to count the total number of entries in a list, but the list contains some text as well. - COUNTA function, You have a list of employees with their salaries and need to find out who has the least salary. - MINIMUM (MIN) function,

Spreadsheets

by
Print
Embed

Leaderboard

Flash cards is an open-ended template. It does not generate scores for a leaderboard.

Visual style

Options

Switch template

Continue editing: ?