Spreadsheet fundamentals — cells, formulas, and key shortcuts tested regularly in RRB Computer Awareness.
MS Excel is a spreadsheet application used for organising, calculating, and analysing data in rows and columns (cells).
| Term | Meaning |
|---|---|
| Cell | Intersection of a row and column, identified by a reference like A1 |
| Workbook | An Excel file, containing one or more worksheets |
| Formula | An expression starting with "=" used to calculate values (e.g., =A1+B1) |
| Function | A predefined formula (SUM, AVERAGE, IF, VLOOKUP) |
| Function | Purpose |
|---|---|
| SUM() | Adds a range of values |
| AVERAGE() | Finds the mean of a range |
| COUNT() | Counts numeric entries in a range |
| IF() | Returns a value based on a condition |
This free chapter covers the key concepts. For complete coverage with 500+ MCQs, mock tests, and previous year analysis — grab the premium eBook.
📚 Browse Premium eBooks →