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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?