Formula bar and cell preview in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a retail company.

📋 Request: Your manager wants you to check and understand how formulas work in the sales report. They want you to use the formula bar and cell preview to verify calculations.

📊 Data: You have a sales report table with columns for Product, Units Sold, Unit Price, and Total Sales. Total Sales is calculated by multiplying Units Sold by Unit Price.

🎯 Deliverable: You need to show how to use the formula bar and cell preview to check the Total Sales calculation for each product.

Sample Data

Product	Units Sold	Unit Price	Total Sales
Notebook	10	2.50	=B2*C2
Pen	25	1.20	=B3*C3
Eraser	15	0.80	=B4*C4
Marker	8	3.00	=B5*C5
Ruler	12	1.50	=B6*C6

1

Step 1: Click on the cell D2 which contains the formula for Total Sales of Notebook.

Look at the formula bar above the spreadsheet. It shows the formula =B2*C2.

Expected Result

Formula bar displays =B2*C2 and cell D2 shows the calculated value 25.00.

2

Step 2: Click on cell D3 to check the Total Sales for Pen.

Observe the formula bar showing =B3*C3.

Expected Result

Formula bar shows =B3*C3 and cell D3 shows 30.00.

3

Step 3: Select cell D4 to verify the Total Sales for Eraser.

Formula bar displays =B4*C4.

Expected Result

Cell D4 shows 12.00 as the result.

4

Step 4: Click on cell D5 to see the formula for Marker sales.

Formula bar shows =B5*C5.

Expected Result

Cell D5 displays 24.00.

5

Step 5: Select cell D6 to check the Total Sales for Ruler.

Formula bar shows =B6*C6.

Expected Result

Cell D6 shows 18.00.

6

Step 6: Click on any Total Sales cell and look at the cell preview (the small tooltip near the cell) to see the formula result quickly.

No formula needed, just observe the preview.

Expected Result

Cell preview shows the calculated value matching the formula bar result.

Final Result

Product   Units Sold   Unit Price   Total Sales
---------------------------------------------
Notebook       10          2.50          25.00
Pen            25          1.20          30.00
Eraser         15          0.80          12.00
Marker          8          3.00          24.00
Ruler          12          1.50          18.00

✓The formula bar shows the exact formula used in each Total Sales cell.

✓The cell preview helps quickly see the result without clicking the formula bar.

✓Total Sales is correctly calculated by multiplying Units Sold by Unit Price.

Bonus Challenge

Change the Unit Price of 'Pen' to 1.50 and use the formula bar to verify the updated Total Sales.

Show Hint

Click cell C3, change the value to 1.50, then click D3 and check the formula bar and cell preview for the new result.