Froggy Jumps Excel - 7thOnline version Select the correct answer to help Froggy get to the other side. by P. S. R. 1 The COUNTBLANK function: a counts the number of empty cells in a given range of cells. b counts the number of cells with information in a given range of cells. c counts the number of cells in a given range of cells. 2 The COUNT function: a counts the number of cells that contain numbers. b counts the number of cells that contain letters. c counts the number of cells that contain numbers and letters. 3 Function that changes a number to roman number: a SUBSTITUTE b TRIM c ROMAN 4 Function that eliminates extra spaces: a SUBSTITUTE b TRIM c ROMAN 5 Function that substitutes the information in a cell with new information: a SUBSTITUTE b TRIM c ROMAN 6 Function that joins a string of text: a AVERAGE b CHARACTER c CONCATENATE 7 Function that returns the arithmetic mean of the arguments: a AVERAGE b CHARACTER c CONCATENATE 8 Function used to identify the character based on the number in the cell: a AVERAGE b CHARACTER c CONCATENATE 9 The PRODUCT function: a adds b subtratcs c multiplies 10 The SUM function: a adds b subtratcs c multiplies 11 Must be added when working with formulas: a = sign b * sign c / sign 12 Is the correct syntax when working with functions: a equal sign, name of the function, quotation marks. b equal sign, name of the function, parentheses. c equal sign, name of the function, brackets.
New game