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

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?