Entering and editing data in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the result of this formula after editing the cell?

You have entered the formula =A1+B1 in cell C1. Cell A1 contains 5 and cell B1 contains 3. You then edit cell B1 and change its value to 7. What is the new value displayed in cell C1?

A 12

B 8

C 5

D 7

💡 Hint

Remember that formulas update automatically when referenced cells change.

The formula =A1+B1 adds the values in A1 and B1. When B1 changes from 3 to 7, the formula recalculates as 5 + 7 = 12.

❓ Function Choice

intermediate

Which function helps to quickly fill a series of numbers when editing data?

You want to enter numbers 1 to 10 in a column quickly without typing each number. Which Excel feature or function should you use?

A SUM function

B Data Validation

C VLOOKUP function

D AutoFill by dragging the fill handle

💡 Hint

Think about dragging the small square at the corner of a selected cell.

AutoFill lets you drag the fill handle to fill cells with a series like numbers or dates automatically.

🎯 Scenario

advanced

You accidentally overwrite data in a cell. How can you undo this change?

You typed new data in cell D5 but realize it was a mistake and want to restore the original content. What is the quickest way to undo the change?

A Press Ctrl + Z (Undo)

B Delete the cell content manually

C Close Excel without saving

D Copy data from another cell

💡 Hint

Think about the universal shortcut for undoing actions.

Pressing Ctrl + Z immediately reverses the last change, restoring the original data.

❓ data_analysis

advanced

How many cells contain data after these edits?

You start with an empty worksheet. You enter data in cells A1, B1, and C1. Then you delete the content in B1. How many cells contain data now?

A 0

B 2

C 1

D 3

💡 Hint

Deleting content removes data from that cell.

Initially, 3 cells have data. After deleting B1's content, only A1 and C1 contain data, so 2 cells remain filled.

📊 Formula Result

expert

What is the displayed value after entering this formula with mixed data?

Cell A1 contains the text '10', cell B1 contains the number 5. You enter the formula =A1+B1 in cell C1. What is the result shown in C1?

A 105

B 10

C 15

D #VALUE!

💡 Hint

Excel tries to convert text to numbers when possible in formulas.

Excel converts the text '10' in A1 to the number 10 and adds it to 5, resulting in 15.