MS Excel Important Mcqs

61- Which chart type is best for displaying proportions or percentages ?

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

Answer : B. Pie Chart

62- What does a Waterfall Chart show ?

A. Changes in a value over time
B. The relationship between two variables
C. Data distribution
D. Step-by-step changes in a value

Answer : D. Step-by-step changes in a value

63- What is the purpose of a Histogram in Excel ?

A. To show data trends
B. To display frequency distribution
C. To compare multiple categories
D. To summarize data

Answer : B. To display frequency distribution

64- Which chart type is best for showing correlations between two numeric variables ?

A. Pie Chart
B. Line Chart
C. Scatter Plot
D. Column Chart

Answer : C. Scatter Plot

65- What is the purpose of the Sparklines feature in Excel ?

A. To insert a small chart inside a cell
B. To create a Pivot Table
C. To add conditional formatting
D. To summarize numerical data

Answer : A. To insert a small chart inside a cell

66- Which of the following allows multiple users to work on an Excel file at the same time ?

A. Share Workbook
B. Track Changes
C. OneDrive Collaboration
D. All of the above

Answer : D. All of the above

67- Where can you check for Excel version history in a shared document ?

A. File → Info → Version History
B. Review → Track Changes
C. Data → Manage Versions
D. View → History

Answer : B. Review → Track Changes

68- What does the Protect Sheet feature do ?

A. Prevents changes to specific cells
B. Locks the entire workbook
C. Prevents file sharing
D. Disables formulas

Answer : A. Prevents changes to specific cells

69- How can you restrict access to an Excel workbook ?

A. View → Hide Workbook
B. Data → Secure File
C. Home → Lock File
D. File → Protect Workbook → Encrypt with Password

Answer : D. File → Protect Workbook → Encrypt with Password

70- What does the Co-Authoring feature in Excel Online allow ?

A. Macros automation
B. Multiple users to edit a document in real-time
C. Version control tracking
D. Automatic data validation

Answer : B. Multiple users to edit a document in real-time

71- What is the primary use of Power Query in Excel ?

A. Sorting and filtering data
B. Automating macros
C. Data cleaning and transformation
D. Creating Pivot Tables

Answer : C. Data cleaning and transformation

72- How can you combine data from multiple Excel files using Power Query ?

A. Get & Transform → Append Queries
B. Data → Merge Tables
C. Insert → Import Data
D. Home → Lookup Tables

Answer : A. Get & Transform → Append Queries

73- What does Power Pivot allow you to do ?

A. Encrypt workbooks
B. Sort large datasets
C. Automate repetitive tasks
D. Create relational data models

Answer : D. Create relational data models

74- How do you refresh a Power Query ?

A. Insert → Update Query
B. Review → Refresh Data
C. Data → Refresh All
D. View → Update Pivot

Answer : C. Data → Refresh All

75- What function is used in DAX (Data Analysis Expressions) for Power Pivot ?

A. SEARCH
B. COUNTIF
C. SUMIF
D. CALCULATE

Answer : D. CALCULATE

76- What is the main purpose of Macros in Excel ?

A. Automate repetitive tasks
B. Encrypt data
C. Create data models
D. Apply conditional formatting

Answer : A. Automate repetitive tasks

77- How can you disable Macros for security reasons ?

A. Insert → Macro Settings
B. File → Options → Trust Center → Macro Settings
C. Home → Disable Macros
D. Data → Secure Workbook

Answer : B. File → Options → Trust Center → Macro Settings

78- What is the AI-powered feature in Excel that suggests data insights ?

A. AutoFill
B. Goal Seek
C. Solver
D. Ideas (Insights)

Answer : D. Ideas (Insights)

79- How can you automatically fill a column with AI-based predictions ?

A. AutoFill
B. Predictive Entry
C. Flash Fill
D. Smart Fill

Answer : C. Flash Fill

80- What is the Python integration feature in Excel used for advanced data analysis ?

A. Python in Excel
B. Excel Lab
C. Data Science Toolkit
D. Machine Learning Add-in

Answer : A. Python in Excel

1

2

3

4

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top