Array formulas basics in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to multiply each value in range A1:A5 by 2 using an array formula.

Excel

=A1:A5[1]2

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

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * will add 2 to each element, not multiply.

Using / will divide each element by 2, which is incorrect here.

The asterisk (*) is used to multiply each element in the range by 2 in an array formula.

2fill in blank

medium

Complete the formula to sum the product of ranges A1:A3 and B1:B3 using an array formula.

Excel

=SUM(A1:A3[1]B1:B3)

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

A*

B-

C/

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using + will add elements instead of multiplying.

Using / or - will not produce the correct product sum.

The multiplication operator (*) multiplies corresponding elements of the two ranges before summing them.

3fill in blank

hard

Fix the error in the array formula that calculates the square of each value in A1:A4.

Excel

=A1:A4[1]2

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

A^

B**

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using ** is common in some languages but not in Excel.

Using * will multiply but not raise to a power.

In Excel, the caret (^) is used for exponentiation, so raising each element to the power of 2 uses ^2.

4fill in blank

hard

Fill both blanks to create an array formula that returns TRUE for values in A1:A5 greater than 10.

Excel

=(A1:A5 [1] 10)

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

A<

B>

CTRUE

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using < will check for less than, which is the opposite.

Using FALSE will not correctly indicate values greater than 10.

The greater than operator (>) compares each value to 10, and the formula returns TRUE for those greater.

5fill in blank

hard

Fill all three blanks to create an array formula that sums values in A1:A5 only if they are greater than 5.

Excel

=SUM(IF(A1:A5 [1] 5, A1:A5, [2]))

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

A>

B<

C0

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using < will select values less than 5, which is incorrect.

Using FALSE instead of 0 will cause errors in summing.

The IF checks if values are greater than 5 (using >), returns the value if true, else 0 to sum only those greater than 5.