Workbook, worksheet, and cell structure in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the value in cell B2 after entering this formula?

You have a worksheet where cell A1 contains 10 and cell A2 contains 20. In cell B2, you enter the formula =A1 + A2. What is the value shown in cell B2?

A 10 20

B A1 + A2

C 30

D Error

💡 Hint

Remember that formulas calculate values from referenced cells.

The formula adds the values in cells A1 and A2, which are 10 and 20, so the result is 30.

❓ Function Choice

intermediate

Which formula correctly references cell C3 in another worksheet named 'Sales'?

You want to get the value from cell C3 in the worksheet named 'Sales'. Which formula should you enter in your current worksheet?

A =Sales!C3

B =C3!Sales

C ='Sales:C3'

D =Sheet.Sales.C3

💡 Hint

Worksheet references use an exclamation mark after the sheet name.

To reference a cell in another worksheet, use the format SheetName!CellReference. So =Sales!C3 is correct.

❓ data_analysis

advanced

How many cells are included in the range A1:C3?

Consider the cell range A1:C3 in a worksheet. How many individual cells does this range include?

A 9

B 6

C 12

D 3

💡 Hint

Count the number of rows and columns in the range and multiply.

The range A1:C3 covers 3 columns (A, B, C) and 3 rows (1, 2, 3), so 3 x 3 = 9 cells.

🎯 Scenario

advanced

You want to keep a cell reference fixed when copying a formula. Which reference style should you use?

You have a formula in cell B1 that references cell A1. You want to copy the formula to other cells but always refer to A1. Which reference style should you use in the formula?

A A1

B A$1

C $A1

D $A$1

💡 Hint

Use dollar signs to lock both column and row.

Using $A$1 locks both the column and row, so the reference does not change when copying the formula.

🧠 Conceptual

expert

What error occurs if you enter a formula with a circular reference in Excel?

You enter a formula in cell A1 that directly or indirectly refers back to cell A1 itself. What happens when you try to calculate this formula?

A The formula returns zero without warning

B Excel shows a circular reference warning and may not calculate the formula

C Excel automatically fixes the formula to avoid the loop

D Excel crashes immediately

💡 Hint

Think about what happens when a formula depends on its own result.

Excel detects circular references and warns the user because it cannot calculate a value that depends on itself without iteration settings.