1) Calculates the total of a range of values a) =AVERAGE(B1:B10) b) =SUM(A1:A10) c) =A2 - B2 d) =PRODUCT(F1:F10) 2) Calculates the average of a range of numbers a) =AVERAGE(B1:B10) b) =COUNT(E1:E10) c) =ABS(H2) d) =ROUND(I2, 1) 3) Returns the smallest value in a range a) =A2 - B2 b) =AVERAGE(B1:B10) c) =PRODUCT(F1:F10) d) =MIN(C1:C10) 4) Returns the largest value in a range a) =MAX(D1:D10) b) =ROUND(I2, 1) c) =MIN(C1:C10) d) =ABS(H2) 5) Counts only the cells with numeric values in a range a) =AVERAGE(B1:B10) b) =A2 - B2 c) =PRODUCT(F1:F10) d) =COUNT(E1:E10) 6) Multiplies all values in a range together a) =ABS(H2) b) =AVERAGE(B1:B10) c) =A2 - B2 d) =PRODUCT(F1:F10) 7) Subtracts one value from another a) =COUNT(E1:E10) b) =A2 - B2 c) =ABS(H2) d) =MIN(C1:C10) 8) Evaluates a condition and returns a specified result if true or another if false a) =AVERAGE(B1:B10) b) =PRODUCT(F1:F10) c) =IF(G1 > 50, "Pass", "Fail") d) =COUNT(E1:E10) 9) Returns the absolute (positive) value of a number a) =AVERAGE(B1:B10) b) =COUNT(E1:E10) c) =ABS(H2) d) =PRODUCT(F1:F10) 10) Rounds a number to a specified number of decimal places a) =MIN(C1:C10) b) =ROUND(I2, 1) c) =ABS(H2) d) =IF(G1 > 50, "Pass", "Fail")

Google Sheets Functions Matching Practice

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？