MS Excel – Basics
Objectives
- Understand cells, rows, columns, and ranges
- Use basic functions and formatting quickly
Key Concepts
- File types: .xlsx vs .xls
- Functions: SUM, AVERAGE, MIN, MAX; AutoSum; Fill handle
Solved Examples
Calculate average of marks in cells B2:B11 using AVERAGE.
Previous Year Questions (PYQs)
PYQ Snippets
- Shortcut for editing a cell: F2
- Function for summation: SUM
BETA
