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

av
Skriv ut
Bädda in

Rankningslista

Visuell stil

Alternativ

Växla mall

Återställ sparas automatiskt: ?