Formula bar and cell preview in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add 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 - instead of plus.

Using multiplication * or division / by mistake.

The plus sign + adds the values of cells A1 and B1.

2fill in blank

medium

Complete the formula to calculate the average of cells A1 to A5.

Excel

=AVERAGE([1])

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

AA1:A5

BA1-B5

CA1+A5

DA1*5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus sign instead of a colon.

Adding cells instead of selecting a range.

The range A1:A5 selects cells from A1 to A5 for the average calculation.

3fill in blank

hard

Fix the error in the formula to multiply cell B2 by 10.

Excel

=B2[1]10

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 division operator by mistake.

The asterisk * is the multiplication operator in Excel formulas.

4fill in blank

hard

Fill both blanks to create a formula that subtracts 5 from the value in cell C3.

Excel

=C3[1][2]

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

A-

B5

C10

D+

E*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus instead of minus.

Using 10 instead of 5.

The minus sign - subtracts the number 5 from the value in cell C3.

5fill in blank

hard

Fill all three blanks to create a formula that calculates the sum of cells D1 to D4 and then divides by 4.

Excel

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

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

AD1:D4

B/

C4

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication instead of division.

Using incorrect cell range.

The formula sums cells D1 to D4, then divides the result by 4 to find the average.

Practice

1. What does the formula bar in Excel show when you select a cell?

easy

A. Only the result of the formula

B. The exact formula or content inside the selected cell

C. The sum of all numbers in the worksheet

D. The formatting style of the cell

Solution

1. Step 1: Understand the formula bar purpose

   The formula bar displays what is typed inside the cell, including formulas or text.

2. Step 2: Differentiate formula bar from cell preview

   The cell itself shows the result or value, but the formula bar shows the exact formula or content.

3. Final Answer:

   The exact formula or content inside the selected cell -> Option B

4. Quick Check:

   Formula bar = exact formula/content [OK]

Hint: Formula bar shows formula, cell shows result [OK]

Common Mistakes:

• Confusing formula bar with cell preview
• Thinking formula bar shows only results
• Assuming formula bar shows formatting

2. Which of the following is the correct way to enter a formula in Excel's formula bar?

easy

A. Start with an equal sign (=) followed by the formula

B. Start with a plus sign (+) followed by the formula

C. Start with a hashtag (#) followed by the formula

D. Start with a dollar sign ($) followed by the formula

Solution

1. Step 1: Recall Excel formula syntax

   Excel formulas must begin with an equal sign (=) to be recognized as formulas.

2. Step 2: Check other options

   Plus sign (+) can sometimes work but is not standard; hashtag and dollar sign are incorrect for starting formulas.

3. Final Answer:

   Start with an equal sign (=) followed by the formula -> Option A

4. Quick Check:

   Formula starts with = [OK]

Hint: Always start formulas with = in formula bar [OK]

Common Mistakes:

• Starting formulas with + instead of =
• Using # or $ incorrectly
• Typing formulas without any prefix

3. If cell A1 contains the formula =SUM(B1:B3) and cells B1=2, B2=3, B3=5, what will the cell preview show?

medium

A. 5

B. The text '=SUM(B1:B3)'

C. 10

D. An error message

Solution

1. Step 1: Calculate the sum of B1 to B3

   Values are 2 + 3 + 5 = 10.

2. Step 2: Understand cell preview behavior

   The cell preview shows the result of the formula, which is 10, not the formula text.

3. Final Answer:

   10 -> Option C

4. Quick Check:

   SUM(2,3,5) = 10 [OK]

Hint: Cell preview shows formula result, not formula text [OK]

Common Mistakes:

• Confusing formula text with result
• Adding only one cell value
• Expecting error without reason

4. You see the formula bar showing =SUM(B1:B3 (missing closing parenthesis). What will happen in the cell preview?

medium

A. The cell will show the correct sum

B. The cell will show the formula text as is

C. The cell will be blank

D. The cell will show a formula error like #NAME?

Solution

1. Step 1: Identify the formula error

   The formula is missing a closing parenthesis, so it is incomplete and invalid.

2. Step 2: Understand Excel error display

   Excel shows an error like #NAME? or #VALUE! in the cell preview when formula syntax is wrong.

3. Final Answer:

   The cell will show a formula error like #NAME? -> Option D

4. Quick Check:

   Missing parenthesis causes formula error [OK]

Hint: Check formula bar for missing symbols if error shows [OK]

Common Mistakes:

• Expecting correct sum despite syntax error
• Thinking cell will be blank
• Assuming formula text shows in cell

5. You want to quickly check if a cell contains a formula or just a number. What is the best way to do this using the formula bar and cell preview?

hard

A. Look at the formula bar; if it starts with '=', it has a formula

B. Look at the cell preview; if it shows a number, it has a formula

C. Check if the cell is colored; colored cells have formulas

D. Double-click the cell; if it edits, it has a formula

Solution

1. Step 1: Understand formula bar content

   The formula bar shows the exact content. If it starts with '=', it means the cell contains a formula.

2. Step 2: Differentiate cell preview and formula bar

   The cell preview shows the result, which can be a number even if no formula exists. Color or double-click do not reliably indicate formulas.

3. Final Answer:

   Look at the formula bar; if it starts with '=', it has a formula -> Option A

4. Quick Check:

   Formula bar starting with = means formula [OK]

Hint: Check formula bar for '=' to identify formulas fast [OK]

Common Mistakes:

• Assuming number in cell means formula
• Relying on cell color or formatting
• Thinking double-click shows formula presence