Skip to main content

MS Excel MCQs with explanations

MS Excel MCQs with explanations, suitable for competitive exams, computer exams, UGC/college exams, SSC, banking, teaching recruitment, and general computer knowledge.

MS Excel MCQs

1. Microsoft Excel is primarily used for:

A. Word processing
B. Spreadsheet and data analysis
C. Presentation design
D. Web browsing

Answer: B. Spreadsheet and data analysis

Explanation: Excel is spreadsheet software used for storing, organizing, calculating, analyzing, and visualizing data.

2. The intersection of a row and a column is called:

A. Sheet
B. Cell
C. Workbook
D. Range

Answer: B. Cell

Explanation: A cell is the basic unit of an Excel worksheet, such as A1 or B5.

3. A collection of worksheets is called:

A. Workbook
B. Range
C. Column
D. Cell

Answer: A. Workbook

Explanation: An Excel file containing one or more worksheets is called a workbook.

4. Which symbol is used to begin a formula in Excel?

A. #
B. @
C. =
D. %

Answer: C. =

Explanation: Every Excel formula generally starts with the equal (=) sign.

5. Which function is used to calculate the total of selected numbers?

A. COUNT()
B. SUM()
C. AVG()
D. TOTAL()

Answer: B. SUM()

Explanation: Example: =SUM(A1:A10) adds all values from A1 to A10.

6. Which function calculates the arithmetic average?

A. MEAN()
B. AVERAGE()
C. AVG()
D. COUNT()

Answer: B. AVERAGE()

Explanation: Example: =AVERAGE(A1:A10) calculates the average of the selected values.

7. What is the maximum number of rows in modern versions of Excel?

A. 65,536
B. 1,048,576
C. 16,384
D. 1,000,000

Answer: B. 1,048,576

Explanation: Modern Excel versions support 1,048,576 rows per worksheet.

8. What is the maximum number of columns in modern Excel?

A. 256
B. 1,024
C. 16,384
D. 65,536

Answer: C. 16,384

Explanation: The last column in modern Excel is XFD, making a total of 16,384 columns.

9. Which shortcut is commonly used to save an Excel workbook?

A. Ctrl + S
B. Ctrl + P
C. Ctrl + C
D. Ctrl + X

Answer: A. Ctrl + S

Explanation: Ctrl + S saves the current workbook.

10. Which shortcut is used to copy selected data?

A. Ctrl + X
B. Ctrl + C
C. Ctrl + V
D. Ctrl + Z

Answer: B. Ctrl + C

Explanation: Ctrl + C copies selected cells or content.

11. Which chart is best for showing parts of a whole?

A. Line Chart
B. Pie Chart
C. Scatter Chart
D. Area Chart

Answer: B. Pie Chart

Explanation: A pie chart shows how different categories contribute to a total.

12. Which Excel function counts cells containing numbers?

A. COUNTA()
B. COUNT()
C. COUNTIF()
D. SUM()

Answer: B. COUNT()

Explanation: COUNT() counts only cells containing numeric values.

13. Which function counts all non-empty cells?

A. COUNT()
B. COUNTA()
C. COUNTBLANK()
D. COUNTIF()

Answer: B. COUNTA()

Explanation: COUNTA() counts cells containing numbers, text, or other non-empty values.

14. Which symbol represents an absolute cell reference?

A. #
B. $
C. @
D. &

Answer: B. $

Explanation: $A$1 is an absolute reference. Both the column and row remain fixed when copied.

15. Which of the following is a relative cell reference?

A. $A$1
B. A$1
C. $A1
D. A1

Answer: D. A1

Explanation: A relative reference changes automatically when a formula is copied to another location.

16. What does the formula =A1+B1 do?

A. Multiplies A1 and B1
B. Adds A1 and B1
C. Compares A1 and B1
D. Counts A1 and B1

Answer: B. Adds A1 and B1

17. Which error appears when a formula divides a number by zero?

A. #NAME?
B. #VALUE!
C. #DIV/0!
D. #REF!

Answer: C. #DIV/0!

Explanation: This error occurs when attempting to divide by zero or an empty cell treated as zero.

18. Which error indicates an invalid cell reference?

A. #REF!
B. #NAME?
C. #NUM!
D. #N/A

Answer: A. #REF!

Explanation: #REF! usually occurs when a referenced cell has been deleted or becomes invalid.

19. Which function finds the largest value?

A. MAX()
B. HIGH()
C. LARGEVALUE()
D. TOP()

Answer: A. MAX()

20. Which function finds the smallest value?

A. LOW()
B. MIN()
C. SMALLVALUE()
D. LEAST()

Answer: B. MIN()

21. Which feature is used to arrange data in ascending or descending order?

A. Filter
B. Sort
C. Freeze Panes
D. Wrap Text

Answer: B. Sort

22. Which feature displays only records meeting specific conditions?

A. Sort
B. Filter
C. Format Painter
D. Find

Answer: B. Filter

23. Which function is used to apply a condition?

A. IF()
B. SUM()
C. MAX()
D. COUNT()

Answer: A. IF()

Explanation: Example: =IF(A1>=50,"Pass","Fail").

24. Which shortcut is used to undo the last action?

A. Ctrl + Y
B. Ctrl + Z
C. Ctrl + U
D. Ctrl + A

Answer: B. Ctrl + Z

25. Which shortcut is used to select the entire worksheet?

A. Ctrl + A
B. Ctrl + S
C. Ctrl + E
D. Ctrl + W

Answer: A. Ctrl + A

26. What does AutoFill help users do?

A. Delete data automatically
B. Fill a sequence or copy formulas
C. Create charts
D. Protect worksheets

Answer: B. Fill a sequence or copy formulas

Explanation: AutoFill can continue sequences such as 1, 2, 3 or copy formulas into adjacent cells.

27. Which function is used to count cells that meet a specific condition?

A. COUNT()
B. COUNTA()
C. COUNTIF()
D. SUMIF()

Answer: C. COUNTIF()

28. Which function adds values that meet a condition?

A. SUM()
B. SUMIF()
C. COUNTIF()
D. IF()

Answer: B. SUMIF()

29. Which key is commonly used to edit the active cell?

A. F1
B. F2
C. F5
D. F12

Answer: B. F2

30. The default extension of a modern Excel workbook is:

A. .docx
B. .pptx
C. .xlsx
D. .txt

Answer: C. .xlsx

Explanation: Modern Microsoft Excel workbooks are generally saved with the .xlsx extension.

Labels:

Comments

Post a Comment

Popular posts from this blog

Top 5 Safe Chat Apps for Kids with Parental Controls

Now a days kids are growing up with technology at their fingertips. While communication apps help children stay connected with family and friends, safety remains a top concern for parents. Unregulated platforms can expose children to inappropriate content, online predators, and cyberbullying. That’s why choosing a kid-friendly chat app with parental controls is essential. To help parents find the best options, we’ve compiled a list of the top five safest chat apps for kids that offer safe and controlled environment. 1. Messenger Kids (By Meta) Best for: Safe video calls and text messaging with parental supervision Features: Parents approve all contacts No ads or in-app purchases Fun filters, stickers, and games Monitored messaging and activity reports Why It’s Safe: Messenger Kids is designed for children under 13 and requires parental approval for every contact. Parents can monitor chats and control screen time through the Parent Dashboard. Download Messenger Kids 2...
Post a Comment
Read more

10 Distance Vector and Link-State Routing MCQ

  10 multiple-choice questions  on  Distance Vector and Link-State Routing with explanations, useful for  UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Basic Concept of Distance Vector Routing Q1: In a distance vector routing protocol, how do routers share routing information? A) By flooding the entire network with routing updates B) By periodically exchanging routing tables with their immediate neighbors C) By using a link-state database to determine the shortest path D) By dynamically updating paths based on link failure reports Answer: B) By periodically exchanging routing tables with their immediate neighbors Explanation: In Distance Vector Routing, routers share their routing tables with neighbors at regular intervals, leading to a simple but slow convergence mechanism. Question 2: Example of Distance Vector Routing Protocol Q2: Which of the following is an example of a Distance Vector routing protocol? A) OSPF ...
Post a Comment
Read more

10 Routing Protocol MCQ

10 multiple-choice questions on Routing protocol s  with explanations, useful for UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Purpose of Routing Protocols Q1: What is the primary purpose of a routing protocol? A) To assign IP addresses to devices B) To determine the best path for data packets to reach their destination C) To encrypt data during transmission D) To physically connect different networks Answer: B) To determine the best path for data packets to reach their destination Explanation: Routing protocols help routers determine the most efficient path for data transmission across a network, ensuring fast and reliable communication. Question 2: Classification of Routing Protocols Q2: Routing protocols can be broadly classified into which two main categories? A) TCP and UDP B) Distance Vector and Link-State C) IPv4 and IPv6 D) Static and Dynamic Answer: B) Distance Vector and Link-State Explanation: Routing prot...
Post a Comment
Read more