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. |
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 Blinkit 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 task
Add Save, Undo, Redo and Sort A to Z to your Quick Access Toolbar. Then set the status bar to also show Minimum and Maximum.