?? MS Excel Viva Questions + Answers
? Section A: Basic Concepts
❓ Q1: What is MS Excel?
Answer:
MS Excel is a spreadsheet software used to organize, calculate, and analyze data.
❓ Q2: What is a workbook?
Answer:
A workbook is an Excel file that contains one or more worksheets.
❓ Q3: What is a worksheet?
Answer:
A worksheet is a grid of rows and columns where data is entered.
❓ Q4: What is a cell?
Answer:
A cell is the intersection of a row and a column (e.g., A1).
❓ Q5: What is an active cell?
Answer:
The currently selected cell where data is entered.
? Section B: Formulas & Functions
❓ Q6: What is a formula?
Answer:
A formula is an expression used to perform calculations in Excel.
❓ Q7: What is a function?
Answer:
A function is a predefined formula (e.g., SUM, AVERAGE).
❓ Q8: How do you start a formula?
Answer:
With an equals sign (=).
❓ Q9: What is SUM function?
Answer:
It adds a range of values.
❓ Q10: What is AVERAGE function?
Answer:
It calculates the mean of values.
❓ Q11: Difference between MIN and MAX?
Answer:
MIN gives smallest value, MAX gives largest value.
❓ Q12: What is IF function?
Answer:
It performs logical tests and returns results based on conditions.
? Section C: Data Handling
❓ Q13: What is sorting?
Answer:
Arranging data in order (ascending/descending).
❓ Q14: What is filtering?
Answer:
Displaying selected data based on conditions.
❓ Q15: What is Data Validation?
Answer:
It restricts input values in cells.
❓ Q16: What is Conditional Formatting?
Answer:
It formats cells automatically based on conditions.
? Section D: Charts & Visualization
❓ Q17: What is a chart?
Answer:
A visual representation of data.
❓ Q18: Name types of charts.
Answer:
Column, Bar, Pie, Line.
❓ Q19: Why use charts?
Answer:
To understand data easily and visually.
? Section E: Advanced Features
❓ Q20: What is a Pivot Table?
Answer:
A tool used to summarize and analyze large data.
❓ Q21: What is VLOOKUP?
Answer:
A function used to find data in a table.
❓ Q22: What is absolute reference?
Answer:
A fixed cell reference (e.g., $A$1).
❓ Q23: What is relative reference?
Answer:
A cell reference that changes when copied.
❓ Q24: What is Goal Seek?
Answer:
A tool to find input value for a desired result.
❓ Q25: What is What-If Analysis?
Answer:
It analyzes outcomes by changing input values.
? Section F: Miscellaneous
❓ Q26: What is Merge & Center?
Answer:
It combines cells and centers text.
❓ Q27: What is AutoFill?
Answer:
It automatically fills data patterns.
❓ Q28: What is Freeze Panes?
Answer:
Keeps rows/columns visible while scrolling.
❓ Q29: What is Find & Replace?
Answer:
Tool to search and replace data.
❓ Q30: What is a shortcut key?
Answer:
Keyboard combination to perform tasks quickly.
? Practical Viva Questions
Students may be asked to:
❓ Q31: Apply SUM formula
❓ Q32: Create a chart
❓ Q33: Sort data
❓ Q34: Apply filter
❓ Q35: Use Conditional Formatting
? Evaluation Criteria
| Criteria | Marks |
|---|---|
| Concept Understanding | 10 |
| Practical Skills | 10 |
| Accuracy | 10 |
| Confidence | 10 |
| Total | 40 |
? Tips for Students
✅ Do’s
- Practice formulas
- Understand concepts
- Speak clearly
❌ Don’ts
- Avoid memorizing only
- Do not panic
- Avoid guessing
?? Instructor Guidelines
- Ask both theory & practical
- Check real understanding
- Encourage explanation
- Provide feedback
? Conclusion
This viva preparation ensures students gain strong conceptual knowledge and practical skills, essential for academic exams and real-world Excel usage.