1) SUM a) Adds up all the numbers in a range. b) Finds the smallest number in a group. c) Finds the biggest number in a group. d) Counts all non-empty cells (including text and numbers). 2) MIN a) Calculates the mean by dividing the total by how many values there are. b) Adds up all the numbers in a range. c) Counts all non-empty cells (including text and numbers). d) Finds the smallest number in a group. 3) MAX a) Counts all non-empty cells (including text and numbers). b) Finds the biggest number in a group. c) Finds the smallest number in a group. d) Adds up all the numbers in a range. 4) AVERAGE a) Adds up all the numbers in a range. b) Finds the biggest number in a group. c) Finds the smallest number in a group. d) Calculates the mean by dividing the total by how many values there are. 5) COUNTA a) Finds the biggest number in a group. b) Adds up all the numbers in a range. c) Calculates the mean by dividing the total by how many values there are. d) Counts all non-empty cells (including text and numbers). 6) COUNTIF a) Adds up all the numbers in a range. b) Counts how many times something specific appears. c) Finds the biggest number in a group. d) Checks a condition and returns one result if it’s true, and another if it’s not 7) IF a) Adds up all the numbers in a range. b) Counts how many times something specific appears. c) Finds the smallest number in a group. d) Checks a condition and returns one result if it’s true, and another if it’s not

Quiz - Spreadsheet Functions

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?