66 MS Excel MCQ Questions in english

Home
Subjects
MS Excel

Subjectwise MCQ

English Hindi General Knowledge Mathematics History Geography Science Reasoning Economics Accounts Business Computer Government Scheme Statewise first CM List Biology Invention Environment Science Polity Sports GK JavaScript C And C++HTML and CSS MS Word MS Excel MS PowerPoint Bootstrap Python PHP MySQL Uttarakhand Fair

Select Subject

Statewise Prepration

Andaman Nicobar Andhra Pradesh Arunchal Pradesh Assam Bihar Chandigarh Chhatisgarh Dadra & Nagar Haveli and Daman & Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnatka Kerala Laddakh Lakshadweep Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Odisha Pondicherry Punjab Rajasthan Sikkim Tamil Nadu Telangana Tripura Uttar Pradesh Uttarakhand West Bengal

Select State

Govt. Examwise MCQ

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer CTET UTET

Select Examination

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer CTET UTET

66 MS Excel MCQ Questions in english हिन्दी

Microsoft produced Microsoft Excel, a spreadsheet, for Windows, macOS, Android, and iOS. It has calculating or computing capabilities, graphing tools, pivot tables, and the Visual Basic for Applications macro programming language. The Microsoft Office program package includes Excel.

38. Which of the following functions can be utilized within a Pivot Table to determine a column sum?

A. COUNT()

B. AVERAGE()

C. SUM()

D. IF()

37. The main purpose of a Pivot Table is:

A. To Sort Data

B. To Summarize Data

C. To Format Data

D. To Enter Data

36. What is the result of =LEN("Hello World")?

A. 10

B. 11

C. 12

D. Error

35. Which function is used to remove extra spaces from text?

A. CLEAN()

B. TRIM()

C. SUBSTITUTE()

D. FIND()

34. What will the formula =LEFT("Excel", 2) return?

A. Ex

B. Exc

C. El

D. Error

33. Which function finds data both horizontally and vertically?

A. VLOOKUP

B. HLOOKUP

C. INDEX-MATCH

D. CONCATENATE

32. What does VLOOKUP stand for?

A. Vertical Lookup

B. Value Lookup

C. Virtual Lookup

D. Variable Lookup

31. Which of the following chart types does not exist in Excel?

A. Histogram

B. Waterfall Chart

C. Radar Chart

D. Sunburst Chart

30. Which of the following can be used to remove duplicate values in a dataset?

A. Remove Duplicates option

B. Find & Replace

C. Data Validation

D. Pivot Table

29. What does the Sort feature in Excel allow you to do?

A. Arrange data in ascending or descending order

B. Remove duplicates

C. Find and replace data

D. Apply conditional formatting

28. Which chart is best suited to display trends over time?

A. Bar Chart

B. Pie Chart

C. Line Chart

D. Doughnut Chart

27. What is the shortcut key to apply a filter to a dataset?

A. Ctrl + F

B. Alt + D + F + F

C. Ctrl + Shift + L

D. Ctrl + L

26. What is the shortcut key to apply bold formatting?

A. Ctrl + B

B. Ctrl + I

C. Ctrl + U

D. Alt + B

25. Which Excel feature is used to combine and center the content of selected cells?

A. Merge & Center

B. Wrap Text

C. Conditional Formatting

D. Data Validation

24. What does Ctrl + 1 do in Excel?

A. Opens the Format Cells dialog box

B. Opens a new workbook

C. Inserts a new sheet

D. Deletes a row

23. What is the default file extension of Excel 2016?

A. .xls

B. .xlsx

C. .docx

D. .csv

22. Which shortcut key is used to insert a new worksheet?

A. Shift + F11

B. Ctrl + N

C. Ctrl + W

D. Alt + Shift + N

21. The function used to count the number of numerical values in a range is:

A. COUNT()

B. COUNTA()

C. COUNTIF()

D. COUNTBLANK()

20. If A1=8, what will the formula =IF(A1>10, "Pass", "Fail") return?

A. Pass

B. Fail

C. Error

D. True

19. The function =ROUND(15.678,2) returns:

A. 15.67

B. 15.68

C. 16

D. 15.7

18. The formula correct for calculating the average of A1:A10 is:

A. =MEAN(A1:A10)

B. =AVERAGE(A1:A10)

C. =SUM(A1:A10)/10

D. both b and c

17. Which function is used to find the highest number in a range?

A. MAX()

B. MIN()

C. LARGE()

D. HIGHEST()

16. Which kind of graph will you use to compare the sales performance of the two products?

A. Column Chart

B. Line Chart

C. Pie Chart

D. Both A and B

15. It is a group of data that has been electronically saved as a table of records.

A. spreadsheet

B. presentation

C. database

D. MS Word

14. Which one in Excel stood for the range B1 through E5?

A. E-Spreadsheet

B. Woorksheet

C. Workbook

D. Sheet

13. Which one in Excel stood for the range B1 through E5?

A. B1 - E5

B. B1:E5

C. B1 to E5

D. B1$E5

12. When we create a new Excel file, how many sheets are there by default?

A. 1

B. 3

C. 5

D. 10

11. A cell is the fundamental building block of an Excel spreadsheet in that you insert data into.

A. cell

B. box

C. column

D. table

« Previous
Next »

Showing 29 to 56 of 66 results

Latest Jobs

NITTTR Bhopal Recruitment 2025

Last Date: Jun 26

Career

(6,180 vacancies) RRB Technician Recruitment

Last Date: Jul 28

Career

KDMC Recruitment 2025 – 490 JE, Fireman & Other ...

Last Date: Jul 03

Group C

WCD MP Recruitment 2025

Last Date: Jun 04

Career

MANIT Bhopal Recruitment 2025

Last Date: Jul 11

Career

Latest Blogs

Subjectwise MCQ

Statewise Prepration

Govt. Examwise MCQ

66 MS Excel MCQ Questions in english हिन्दी

38. Which of the following functions can be utilized within a Pivot Table to determine a column sum?

37. The main purpose of a Pivot Table is:

36. What is the result of =LEN("Hello World")?

35. Which function is used to remove extra spaces from text?

34. What will the formula =LEFT("Excel", 2) return?

33. Which function finds data both horizontally and vertically?

32. What does VLOOKUP stand for?

31. Which of the following chart types does not exist in Excel?

30. Which of the following can be used to remove duplicate values in a dataset?

29. What does the Sort feature in Excel allow you to do?

28. Which chart is best suited to display trends over time?

27. What is the shortcut key to apply a filter to a dataset?

26. What is the shortcut key to apply bold formatting?

25. Which Excel feature is used to combine and center the content of selected cells?

24. What does Ctrl + 1 do in Excel?

23. What is the default file extension of Excel 2016?

22. Which shortcut key is used to insert a new worksheet?

21. The function used to count the number of numerical values in a range is:

20. If A1=8, what will the formula =IF(A1>10, "Pass", "Fail") return?

19. The function =ROUND(15.678,2) returns:

18. The formula correct for calculating the average of A1:A10 is:

17. Which function is used to find the highest number in a range?

16. Which kind of graph will you use to compare the sales performance of the two products?

15. It is a group of data that has been electronically saved as a table of records.

14. Which one in Excel stood for the range B1 through E5?

13. Which one in Excel stood for the range B1 through E5?

12. When we create a new Excel file, how many sheets are there by default?

11. A cell is the fundamental building block of an Excel spreadsheet in that you insert data into.

Latest Jobs

Latest Blogs

for Latest Updates