MS Excel Cheat Sheet
1 Nov 2026
Quick answer
A quick revision cheat sheet on Microsoft Excel for SSC, Banking, Railway and state exams. It covers what Excel is, its file format, cells rows and columns, how formulas and cell references work, the most-asked functions, and key shortcuts, so you can revise the computer-awareness section quickly before the exam.
MS Excel Cheat Sheet
Quick Revision
Microsoft Excel is a spreadsheet program used for calculations, data and charts. A file is a workbook, and each workbook holds one or more worksheets.
Ready to practise? Take the MS Excel quiz
1. The Grid
- A sheet is a grid of cells; columns are letters (A, B, Cā¦) and rows are numbers (1, 2, 3ā¦).
- A cell reference names a cell by column then row, e.g. A1, C5.
- The default file format is .xlsx.
2. Formulas
Every formula begins with =
=A1 + B1 add two cells
=SUM(A1:A5) add a rangeRelative vs absolute reference:
A1 relative ā shifts when copied
$A$1 absolute ā stays fixed when copied3. Most-Asked Functions
| Function | What it does |
|---|---|
| SUM | Adds a range of values |
| AVERAGE | Mean of a range |
| COUNT | Counts cells containing numbers |
| MAX / MIN | Largest / smallest value |
| IF | Returns one of two results on a test |
| VLOOKUP | Looks a value up in a table |
4. Useful Shortcuts
Ctrl + C / V Copy / Paste
Ctrl + S Save
Ctrl + Z Undo
Ctrl + Arrow Jump to the edge of data
F2 Edit the active cell5. Exam Quick Tips
- A formula always starts with
=. - Use
$to lock a reference (absolute) so it does not move when copied. - A workbook is the file; a worksheet is a single tabbed sheet inside it.
Keep revising with the rest of the Basic Computer section:
How this was made: Drafted with AI assistance; spot-checked by the editor on 1 November 2026.