Related Reads
- MCQs on Demography and Census 2011 of India | Junior Assistant
- MCQS on Political and Physical Divisions of India | Junior Assistant
- MCQs on National Parks and Wildlife Sanctuaries of India | Junior Assistant
- MCQs on Waterfalls of India | Junior Assistant
- MCQs on Rivers and Lakes of J&K | Junior Assistant
MCQs on MS Excel – Computer Knowledge Notes
Introduction
MS Excel is one of the most important software tools used for data analysis, tables, charts, and mathematical calculations. Questions from Excel are asked regularly in exams like JKSSB, SSC, Banking, UPSC CSAT, and all state-level computer exams.
This post provides detailed MS Excel notes along with a quiz section for better practice.
📌 What is MS Excel?
MS Excel is a spreadsheet program developed by Microsoft. It helps in storing, organizing, calculating, and analyzing data using rows, columns, formulas, and charts.
Key Features
- Data entry and management
- Mathematical and statistical functions
- Charts and graphs
- Sorting and filtering data
- Pivot tables and advanced data tools
📊 Important Excel Functions
- SUM() – Adds numbers
- AVERAGE() – Calculates mean
- COUNT() – Counts numbers
- MAX() / MIN() – Finds highest/lowest value
- LEFT(), RIGHT(), MID() – Text extraction functions
💡 Frequently Asked One-Liners (Exam-Oriented)
- Default file extension of Excel: .xlsx
- Row numbers start from: 1
- Column labels start from: A
- Shortcut to save a file: Ctrl + S
- Shortcut to insert new sheet: Shift + F11
📖 FAQs on MS Excel
Q1. What is a cell in Excel?
Ans: The intersection of a row and a column.
Q2. What is a formula?
Ans: A statement that performs calculations starting with (=) symbol.
Q3. What is the use of a chart?
Ans: Charts visually represent numerical data.
Q4. What is a workbook?
Ans: A collection of multiple worksheets.
Q5. What does the Fill Handle do?
Ans: Copies formulas or extends data patterns.
📝 Final Takeaways
- Excel is important for every government exam.
- Shortcut keys are frequently asked in MCQs.
- Learn basic formulas for sure-shot marks.
Pro Tip: Practice Excel on your computer to understand formulas deeply instead of only memorizing.