Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to find the length of the text in cell A1.
Excel
=LEN([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a number instead of a cell reference.
Putting the function name inside the parentheses.
✗ Incorrect
The LEN function counts the number of characters in the cell A1.
2fill in blank
mediumComplete the formula to count the characters in cell B2.
Excel
=LEN([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a wrong cell reference like A2 or C2.
Using a number instead of a cell reference.
✗ Incorrect
The formula counts characters in cell B2 using LEN.
3fill in blank
hardFix the error in the formula to count characters in cell C3.
Excel
=LEN([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Missing the opening parenthesis.
Using brackets or braces instead of parentheses.
✗ Incorrect
The LEN function requires parentheses around the cell reference: LEN(C3).
4fill in blank
hardFill both blanks to create a formula that counts characters in cell D4 and multiplies by 2.
Excel
=LEN([1])[2]2
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using addition or subtraction instead of multiplication.
Using the wrong cell reference.
✗ Incorrect
The formula counts characters in D4 and multiplies the result by 2 using LEN(D4)*2.
5fill in blank
hardFill all three blanks to create a formula that counts characters in cell E5, adds 3, and divides by 2.
Excel
=(LEN([1])[2]3)[3]2
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using subtraction instead of addition.
Using multiplication instead of division.
Using the wrong cell reference.
✗ Incorrect
The formula counts characters in E5, adds 3, then divides by 2: (LEN(E5)+3)/2.