Entering and editing data in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enter the number 100 into cell A1 using Excel formula syntax.

Excel

= [1]

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

A100

B"100"

CA1

DSUM(100)

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around numbers makes Excel treat them as text.

Using cell references instead of values.

To enter the number 100 directly, just type =100 in the cell.

2fill in blank

medium

Complete the formula to add the values in cells A1 and B1.

Excel

=A1 [1] B1

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

A-

B+

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus or multiplication instead of addition.

Forgetting to include the operator.

The plus sign + adds two numbers in Excel formulas.

3fill in blank

hard

Fix the error in the formula to multiply cell A2 by 5.

Excel

=A2 [1] 5

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

A+

B-

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus or minus instead of multiplication.

Using slash which divides instead of multiplies.

The asterisk * is the multiplication operator in Excel formulas.

4fill in blank

hard

Complete the code to create a formula that calculates the average of cells A1 to A5.

Excel

= [1] (A1:A5)

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

AAVERAGE

BSUM

C:

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVERAGE.

Using a comma instead of a colon for ranges.

The AVERAGE function calculates the average. The colon : specifies a range from A1 to A5.

5fill in blank

hard

Fill both blanks to create a formula that sums cells B1 to B3 and multiplies the result by 2.

Excel

=[1](B1:B3)[2]2

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

ASUM

B:

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus instead of multiplication.

Using comma instead of colon for range.

The SUM function adds the range B1 to B3 (using colon :). Then multiply * by 2.