Questions
2 questions per paper
Difficulty
Easy
Importance
High yield for SSC and Bank clerical exams
Overview
MS Excel is a core component of the Computer Awareness module in competitive exams, testing your understanding of data manipulation and automated calculations. Mastering this topic is essential because it consists of high-scoring, fact-based questions that can be solved in seconds if you recognize the function syntax and cell behavior. The core goal is to understand how spreadsheets manage data through logical functions and dynamic referencing.
Workbook and Worksheet Basics
A workbook is the entire file with an .xlsx extension, containing one or more worksheets. Understanding the structural limitations and navigation keys is vital for handling large datasets during practical or theory-based testing.
- Default workbook contains 1 worksheet in Excel 2016 and later.
- Maximum rows per worksheet: 1,048,576.
- Maximum columns per worksheet: 16,384 (labeled A to XFD).
- Ctrl + Home moves to the first cell (A1).
- Ctrl + End moves to the last used cell.
Cell Referencing and Editing
Cell references allow Excel to locate data in the grid. Mastering the difference between relative, absolute, and mixed references is critical for understanding how formulas behave when copied across a spreadsheet.
- Relative reference: A1 (adjusts automatically).
- Absolute reference: $A$1 (locked row and column).
- Mixed reference: $A1 or A$1 (locks either column or row).
- F4 function key is the shortcut to toggle absolute references.
- Edit cell content directly using F2 key.
Common Functions and Formulas
Functions are predefined formulas that perform calculations using specific syntax. Examiners often focus on logical, statistical, and text-based functions to test your ability to read spreadsheet logic.
- SUM(): Adds all numbers in a range.
- AVERAGE(): Returns the arithmetic mean.
- IF(): Performs logical tests (Syntax: IF(condition, value_if_true, value_if_false)).
- CONCATENATE() or &: Combines text strings.
- COUNT(): Counts cells with numbers; COUNTA(): Counts non-empty cells.
- TODAY() and NOW(): Inserts current date and time.
Formula Sheet
=SUM(range)
=AVERAGE(range)
=IF(condition, true_val, false_val)
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=NOW()
Exam Tip
Always identify the cell reference type ($, absolute vs relative) first when evaluating formula output questions to save time on manual calculation.
Common Mistakes
- Confusing the purpose of COUNT (numbers only) with COUNTA (non-empty cells).
- Failing to recognize that all Excel formulas must strictly start with an equal sign (=).
- Mixing up Absolute and Relative references when predicting how a formula changes during 'AutoFill'.
More Revision Notes
Ready to test yourself?
Play topic-wise MS Excel / Spreadsheets questions in Aspirant Arcade — gamified MCQ practice.
Download Free