=SUM(A1:A10), function would you use to add together all the numbers in cells A1 through A10?, =AVERAGE(B1:B10), calculate the average value of the numbers in cells B1 through B10 using a function, =COUNT(C1:C10), function should you use to count the number of cells in the range C1 through C10 that contain numbers?, =MIN(D1:D10), function will return the smallest number found in cells D1 through D10?, =IF(G1>=50, "Pass", "Fail"), Imagine cell G1 holds a student's score. Write a function that returns "Pass" if the score is 50 or above, and "Fail" if it’s below 50., =COUNTIF(A1:A20, ">50"), you have a list of numbers in cells A1:A20. Write a formula that counts how many of these cells contain a value greater than 50.

Functions in spreadsheets

由
列印
嵌入

排行榜

我們目前正在努力改進排行榜功能。請通過提供您的反饋來幫助我們。

提供反饋

視覺風格

選項

我們目前正致力於改善活動設定。請提供您的回饋來協助我們。

提供反饋

切換範本

恢復自動保存: ?