New Activity
Ico create Educaplay New Activity
All the activities
Play Froggy Jumps
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.