Why formatting improves readability in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to format the text using Excel formula.

Excel

=TEXT([1], "@")

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

AB1

BD1

CC1

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a cell reference that does not contain the text.

Leaving the cell reference blank.

Using the TEXT function with cell B1 formats the text from that cell. This is a simple way to refer to the cell you want to format.

2fill in blank

medium

Complete the formula to calculate the total price by multiplying quantity in A2 by price in B2.

Excel

=A2 [1] B2

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

A-

B*

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * causes addition, not multiplication.

Using / or - will give wrong results.

The multiplication operator (*) is used to calculate total price by multiplying quantity and price.

3fill in blank

hard

Fix the error in the formula to sum values from A1 to A5.

Excel

=SUM(A1[1]A5)

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

A:

B,

C;

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using comma or semicolon instead of colon causes syntax errors.

Using minus sign does not specify a range.

The colon (:) is used in Excel to specify a range of cells, so SUM(A1:A5) adds all values from A1 to A5.

4fill in blank

hard

Fill the blank to create a conditional formula that returns "Pass" if score in A1 is 50 or more, otherwise "Fail".

Excel

=IF(A1 [1] 50, "Pass", "Fail")

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

A==

B<

C>=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using == is not valid in Excel formulas.

Using < or != will give wrong logic.

The operator >= means 'greater than or equal to', which fits the condition for passing.

5fill in blank

hard

Fill all three blanks to create a formula that counts how many cells in range A1:A10 are greater than 5.

Excel

=COUNTIF(A1:A10, [1][2][3])

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

A"

B>

C5

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the condition causes errors.

Using < instead of > counts wrong cells.

The COUNTIF function needs the condition as a text string. So we use ">5" inside quotes to count cells greater than 5.