MS Excel Basics (Formulas, Cells, Sheets)
A clear introduction to MS Excel covering cells, formulas, common functions, and sheet management.
A clear introduction to MS Excel covering cells, formulas, common functions, and sheet management. This guide is written for Indian students, government exam aspirants, and typing learners who want clear, practical, and exam-relevant information they can apply immediately.
Table of Contents
- Basic structure
- Common formulas
- Formatting
- Useful features
- Practical Tips
- Frequently Asked Questions
- Conclusion
Basic structure
Rows numbered 1, 2, 3 …; columns labelled A, B, C …; intersection is a cell (e.g., B3). A file (workbook) contains multiple sheets (tabs).
Common formulas
Formulas start with =.
Math
=SUM(A1:A10), =AVERAGE(B1:B10), =MIN, =MAX, =COUNT.
Logic
=IF(A1>10,"High","Low"), =AND, =OR.
Lookup
=VLOOKUP, =HLOOKUP, =XLOOKUP.
Formatting
Number formats (currency, percentage, date), conditional formatting (colour cells based on value), borders, cell merging.
Useful features
Sort, Filter, Pivot Tables, Charts (bar, pie, line), Freeze Panes, Data Validation.
Practical Tips
- Always use cell references (=A1+B1) rather than typed numbers (=5+10).
- Press F2 to edit a cell quickly.
- Pivot Tables save hours of manual summarisation.
Frequently Asked Questions
Q: How many cells does Excel support?
Over 17 billion per sheet (1,048,576 rows × 16,384 columns).
Q: What is the difference between formula and function?
A function is a built-in operation (SUM, IF). A formula is any expression you write (=A1+B1).
Conclusion
Consistent application of the techniques above will produce visible results within weeks. Bookmark this guide, share it with a friend preparing alongside you, and return to it whenever you need a refresher. For more guides, browse the TypingMaster India blog or try a free typing test to measure where you stand today.