โ Computer Fundamentals & MS Office learning pathComputer Fundamentals & MS Office ยท Module 6 of 10
MS Excel basics
Enter data and use simple formulas.
๐ Key ideas
- Excel is a grid of cells; each cell has an address like B3.
- Formulas start with =, for example =A1+B1.
- SUM, AVERAGE, MIN, MAX and COUNT are common functions.
- AutoFill copies a formula or series by dragging the fill handle.
- Format numbers as currency, percentage or date.
๐ก Real-life example: An Excel sheet is a smart notebook: change one number and every total updates itself.
CellOne box addressed like B3
FormulaCalculation starting with =
SUMAdds a range
Fill handleDrag to copy a formula