LEN function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to find the length of the text in cell A1.

Google Sheets

=LEN([1])

Drag options to blanks, or click blank then click option'

A1A

BB1

CA1

DLEN

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong cell reference like B1 or 1A.

Putting the function name LEN inside itself.

The LEN function counts the number of characters in the text inside the specified cell. Here, we want the length of the text in cell A1, so we use A1 as the argument.

2fill in blank

medium

Complete the formula to find the length of the text in cell B2.

Google Sheets

=LEN([1])

Drag options to blanks, or click blank then click option'

AB2

BA2

CC2

DLEN

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different cell reference like A2 or C2.

Putting the function name LEN inside itself.

To find the length of the text in cell B2, we use B2 as the argument inside the LEN function.

3fill in blank

hard

Fix the error in the formula to correctly find the length of the text in cell C3.

Google Sheets

=LEN([1])

Drag options to blanks, or click blank then click option'

AC

B3C

CLEN

DC3

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the row and column like '3C'.

Using the function name or partial cell references.

The correct cell reference is C3. '3C' is invalid, and 'LEN' or 'C' are not valid cell references.

4fill in blank

hard

Fill both blanks to create a formula that finds the length of the text in cell D4 and adds 5.

Google Sheets

=LEN([1])[2]5

Drag options to blanks, or click blank then click option'

AD4

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference.

Using subtraction or multiplication instead of addition.

We use D4 as the cell reference inside LEN to get the text length. Then we add 5 using the + operator.

5fill in blank

hard

Fill all three blanks to create a formula that finds the length of the text in cell E5, multiplies it by 2, and then subtracts 3.

Google Sheets

=(LEN([1])[2]2)[3]3

Drag options to blanks, or click blank then click option'

AE5

B*

C-

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong cell references.

Using addition instead of subtraction.

Using wrong operators for multiplication.

We use E5 as the cell reference inside LEN. Then multiply the length by 2 using *, and subtract 3 using -.