Microsoft Excel is used every day in offices for preparing lists, calculations, records and reports. Most competitive exams include basic questions on Excel, so knowing simple functions, shortcuts and data tools is very useful. The MCQs below are written in a clear, practical way and cover the topics usually asked in tests — use them for quick revision while preparing for any computer-related exam.
Related Reads
Q1. What is the default file extension of MS Excel 2007 and later?
Show Answer
✔ B. .xlsx
Q2. Which function is used to find the average in Excel?
Show Answer
✔ C. AVERAGE()
Q3. In Excel, rows are identified by?
Show Answer
✔ A. Numbers
Q4. What is the intersection of a row and a column called?
Show Answer
✔ B. Cell
Q5. Which of these is a valid Excel formula?
Show Answer
✔ A. =A1+A2
Q6. Which function returns the largest value?
Show Answer
✔ A. MAX()
Q7. Shortcut key to create a new workbook?
Show Answer
✔ A. Ctrl + N
Q8. Which chart is best for showing trends over time?
Show Answer
✔ B. Line Chart
Q9. The formula bar is located in which area?
Show Answer
✔ D. Top of the window
Q10. Which function counts only numeric values?
Show Answer
✔ A. COUNT()
Q11. What is the maximum number of rows in Excel 2016?
Show Answer
✔ B. 1048576
Q12. Which symbol is used for absolute reference?
Show Answer
✔ B. $
Q13. Shortcut to save a workbook?
Show Answer
✔ B. Ctrl + S
Q14. A group of worksheets is called?
Show Answer
✔ A. Workbook
Q15. A formula always starts with?
Show Answer
✔ B. =
Q16. Which key is used to edit a cell?
Show Answer
✔ B. F2
Q17. Which feature quickly fills data based on patterns?
Show Answer
✔ B. Flash Fill
Q18. Which tab contains the Sort & Filter option?
Show Answer
✔ A. Home
Q19. What does CONCAT() function do?
Show Answer
✔ B. Combines text
Q20. Which shortcut selects an entire column?
Show Answer
✔ A. Ctrl + Space
Q21. Which operator is used for exponentiation in Excel?
Show Answer
✔ A. ^
Q22. Which error means a number is divided by zero?
Q23. Which feature allows you to lock specific rows/columns?
Show Answer
✔ A. Freeze Panes
Q24. Which function returns the current date?
Show Answer
✔ B. TODAY()
Q25. Excel is a type of?
Show Answer
✔ B. Spreadsheet Software