1.1 The Excel Interface
When you open a blank workbook in Microsoft 365 you see these parts:
| Part | Where | What it does |
|---|---|---|
| Ribbon | Top | Tabs (File, Home, Insert, Page Layout, Formulas, Data, Review, View, Help; Developer only if you turn it on). Each tab has groups, e.g. Home › Number. |
| Quick Access Toolbar (QAT) | Above or below the ribbon | Your favourite commands (Save, Undo…). Right-click any command › Add to Quick Access Toolbar. |
| Name Box | Left of the formula bar | Shows the active cell address (e.g. C5). Type an address or a name here and press Enter to jump. |
| Formula bar | Top, right of Name Box | Shows the real content of the cell – the formula, not only the result. |
| Grid | Centre | Columns A…XFD (16,384 columns) × rows 1…1,048,576. |
| Sheet tabs | Bottom | One tab per worksheet. |
| Status bar | Very bottom | Quick Sum, Average, Count of selected cells; zoom; view buttons. Right-click it to choose what it shows. |
About this data: Teaching sample for a fictional shop “Summit Schools”. Figures and names (e.g. Aarti Kulkarni) are made up for this lesson on the excel interface.
Mitrano, the formula bar is your best friend. A cell may show ₹1,250 but the formula bar tells you whether it is a typed number or a formula like =B2*C2. Doubt aala ki formula bar bagha.
Steps in Excel
- File › New › Blank workbook (or Ctrl + N).
- Click cell C5. See
C5in the Name Box. - Type
=10*3and press Enter. The cell shows 30; click it again and the formula bar shows=10*3. - Select a few numbers and look at the status bar: Average, Count, Sum appear automatically.
- Press Ctrl + F1 to collapse or expand the ribbon.
Worked example. Ruhi Bagale, a FreshGo store analyst in Kothrud, selects the Amount cells of today's orders. Without typing any formula, the status bar shows Sum: ₹18,450 and Count: 212. That is the fastest "quick check" in Excel.
Ravindra Bagale's Tip
Friends, many students think the number they see in a cell is the real value, but it is often the result of a formula or a rounded format. Always check the real content in the formula bar. Use the Sum on the status bar too – you can see at once whether the total matches.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students cell मध्ये दिसणारा number खरा आहे असं समजतात, पण तो बऱ्याचदा formula चा result असतो किंवा rounded format असतो. खरा content नेहमी formula bar मध्ये चेक करा. Status bar वरचा Sum पण वापरा – total जुळतोय का ते लगेच कळतं.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students cell में दिखने वाले number को ही असली value समझते हैं, पर वह अक्सर formula का result या rounded format होता है. असली content हमेशा formula bar में चेक करो. Status bar का Sum भी इस्तेमाल करो – total match हो रहा है या नहीं, तुरंत पता चल जाता है.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of the excel interface on a blank sheet for FreshGo Mart.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Vikram Rao and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Emma Clarke.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply the excel interface to a 5-row made-up FreshGo Mart table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with the excel interface.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as FreshGoMart_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
