Microsoft MS Excel MCQ 100 Best Question Answer

Microsoft MS Excel MCQ 100 Best Multiple Choice Question Answer for scoring full marks in exams and interviews.

I. Basic Concepts and Navigation

Understanding the Excel Interface

Question 1: What is the name for a collection of worksheets saved as a single file?

A. Workbook

B. Worksheet

C. Cell

D. Column

Question 2: What are the individual sheets within an Excel file called?

A. Workbooks

B. Worksheets

C. Rows

D. Columns

Question 3:  What is the intersection of a row and a column called?

A.  Table

B.  Range

C.  Cell

D.  Worksheet

Question 4: What is the term for the horizontal lines of cells in a worksheet?

A. Columns

B. Rows

C. Cells

D. Tabs

Question 5: Where can you find commands organized into groups in Excel?

A. Formula Bar

B. Status Bar

C. Ribbon

D. Quick Access Toolbar

Data Entry and Manipulation

Question 6:  Which of the following is NOT a valid way to enter data into a cell?

A. Typing directly into the cell

B. Typing into the formula bar

C. Dragging data from another cell

D. Selecting the cell and pressing the Delete key

Question 7:  What is a contiguous group of cells called?

A.  Worksheet

B.  Row

C.  Column

D.  Range

Question 8: To quickly copy a formula to adjacent cells, what feature can you use?

A. Cut and Paste

B. Fill Handle

C. Formula Bar

D. Status Bar

Question 9:  How do you move data from one cell to another?

A.  Select the cell and press Delete

B.  Use the Cut and Paste commands

C.  Use the Copy and Paste commands

D.  Double-click the cell and type the new data

Question 10:  What does the Insert command allow you to do?

A.  Add new rows or columns

B.  Delete existing rows or columns

C.  Change the font of the selected cells

D.  Apply a formula to a range of cells

Question 11:  How do you remove a row from your worksheet?

A.  Select the row and press the Backspace key

B.  Right-click the row number and choose Delete

C.  Use the Cut command

D.  Click the row number and press the Delete key

Question 12: What is the primary function of the AutoFill feature?

A. To automatically fill a cell with a specific color

B. To automatically adjust the width of a column

C. To automatically continue a series of data or formulas

D. To automatically check for spelling errors in a worksheet

II. Formatting – Microsoft MS Excel MCQ 100 Best Question Answer

Cell Formatting

Question 13: Which of these options is NOT a font style in Excel?

A. Bold

B. Italic

C. Justify

D. Underline

Question 14:  What format should you apply to a cell to display values as monetary amounts?

A.  General

B.  Number

C.  Currency

D.  Percentage

Question 15:  Which formatting option allows you to change the vertical position of text within a cell?

A.  Horizontal Alignment

B.  Vertical Alignment

C.  Text Wrapping

D.  Font Style

Question 16:  What formatting feature allows you to combine multiple cells into one?

A.  Merge & Center

B.  Text Wrapping

C.  Conditional Formatting

D.  Cell Styles

Question 17: How can you add a line around a cell or group of cells?

A. Using the Font formatting options

B. Applying a Border

C. Using the Fill Color option

D. Changing the Cell Style

Question 18: What feature allows you to quickly apply a predefined set of formats to a cell?

A. Conditional Formatting

B. Cell Styles

C. Number Formatting

D. Font Formatting

Worksheet Formatting

Question 19:  Where do you adjust the top, bottom, left, and right margins of a worksheet?

A.  Page Setup

B.  Sheet Options

C.  Print Preview

D.  Formula Bar

Question 20:  What setting controls whether gridlines are displayed on the worksheet?

A.  Page Setup

B.  Sheet Options

C.  Print Preview

D.  Formula Bar

Question 21:  Which view allows you to see how the worksheet will look when printed?

A.  Normal view

B.  Page Layout view

C.  Print Preview

D.  Page Break Preview

Question 22:  What is the purpose of headers and footers in Excel?

A.  To define the printable area of a worksheet

B.  To add titles, page numbers, or dates to the top and bottom of each printed page

C.  To insert images or logos into a worksheet

D.  To create a table of contents for a workbook

Question 23:  How can you change the printing orientation of a worksheet from portrait to landscape?

A.  By adjusting the column widths

B.  By using the Page Setup options

C.  By changing the zoom level

D.  By modifying the header and footer

Question 24: What does “scaling” a worksheet for printing do?

A. Changes the font size of the data

B. Adjusts the size of the worksheet to fit on a specific number of pages

C.  Adds or removes page breaks

D.  Rotates the page from portrait to landscape

Question 25:  Which option allows you to print only a selected range of cells?

A.  Print Active Sheet

B.  Print Entire Workbook

C.  Print Selection

D.  Print Preview

III. Formulas and Functions

Basic Formulas

Question 26: Which symbol is used for multiplication in Excel formulas?

A. x

B. *

C. ^

D. &

Question 27: What type of cell reference changes when a formula is copied to a new location?

A. Absolute reference

B. Relative reference

C. Mixed reference

D. 3D reference

Question 28: Which symbol is used to indicate an absolute reference in a formula?

A. $

B. &

C. %

D. #

Question 29:  What is the correct order of operations in Excel formulas?

A.  Addition, Subtraction, Multiplication, Division

B.  Multiplication, Division, Addition, Subtraction

C.  Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

D.  Subtraction, Addition, Division, Multiplication

Question 30:  What does the ^ symbol represent in a formula?

A.  Multiplication

B.  Division

C.  Exponentiation

D.  Concatenation

Essential Functions

Question 31: Which function calculates the sum of a range of cells?

A. AVERAGE

B. COUNT

C. SUM

D. MAX

Question 32:  Which function calculates the average of a range of cells?

A.  SUM

B.  COUNT

C.  AVERAGE

D.  MAX

Question 33:  Which function counts the number of cells that contain numbers?

A.  COUNT

B.  COUNTA

C.  COUNTBLANK

D.  SUM

Question 34: Which function returns the largest value in a range?

A. MAX

B. MIN

C. LARGE

D. SMALL

Question 35:  Which function is used to make a logical comparison between a value and what you expect?

A.  SUM

B.  IF

C.  AND

D.  OR

Question 36:  Which function returns TRUE if all of its arguments are TRUE?

A.  AND

B.  OR

C.  NOT

D.  IF

Question 37:  Which function searches for a value in the first column of a table array and returns a value in the same row from a specified column?

A.  VLOOKUP

B.  HLOOKUP

C.  INDEX

D.  MATCH

Question 38:  Which function joins several text strings into one text string?

A.  CONCATENATE

B.  TEXT

C.  LEFT

D.  RIGHT

Question 39:  Which function converts a value to text in a specific number format?

A.  VALUE

B.  TEXT

C.  UPPER

D.  LOWER

Question 40:  What does the HLOOKUP function do?

A.  Performs a vertical lookup in a table array

B.  Performs a horizontal lookup in a table array

C.  Calculates the average of a range of cells

D.  Counts the number of cells that contain numbers

Working with Formulas

Question 41:  How do you begin entering a formula in a cell?

A.  By typing an asterisk (*)

B.  By typing an equals sign (=)

C.  By selecting the cell and pressing Enter

D.  By double-clicking the cell

Question 42:  What does a circular reference error mean?

A.  A formula refers to a cell that is not valid.

B.  A formula refers to its own cell, directly or indirectly.

C.  A formula contains an invalid operator.

D.  A formula is too long.

Question 43:  What does the green triangle in the top-left corner of a cell indicate?

A.  A potential error in the formula

B.  The cell contains a comment

C.  The cell is protected

D.  The cell is formatted as currency

Question 44: What is the quickest way to sum a column or row of numbers?

A. Use the SUM function and manually select the range

B. Type the formula =A1+A2+A3…

C. Use the AutoSum feature

D. Use the COUNT function

Question 45:  Which key do you press to cycle through the different types of cell references (relative, absolute, mixed) in a formula?

A.  F1

B.  F2

C.  F4

D.  F5

IV. Data Management

Sorting and Filtering

Question 46: How can you arrange data in ascending order based on the values in a specific column?

A. By applying a filter

B. By using the Sort Ascending command

C. By using the Sort Descending command

D. By creating a table

Question 47:  What feature allows you to display only rows that meet certain criteria?

A.  Sorting

B.  Filtering

C.  Conditional Formatting

D.  Data Validation

Question 48:  Which of the following is NOT a standard filter option in Excel?

A.  Sort by color

B.  Filter by font size

C.  Filter by value

D.  Filter by text contains

Question 49:  What does the “Clear Filter” command do?

A.  Removes the filter and displays all data

B.  Deletes the filtered rows

C.  Sorts the data in ascending order

D.  Copies the filtered data to a new worksheet

Question 50:  What feature allows you to create more complex filter criteria with multiple conditions?

A.  Sort

B.  AutoFilter

C.  Advanced Filter

D.  Data Validation

Data Validation

Question 51: What feature helps prevent invalid data from being entered into a cell?

A.  Data Validation

B.  Conditional Formatting

C.  Data Analysis

D.  Goal Seek

Question 52:  Which of the following is NOT a type of data validation rule?

A.  Whole number

B.  Decimal

C.  Text length

D.  Font color

Question 53:  How can you create a drop-down list in a cell?

A.  By using the Data Validation feature

B.  By using the Conditional Formatting feature

C.  By inserting a comment

D.  By applying a cell style

Question 54:  What is an input message in data validation?

A.  An error message that appears when invalid data is entered

B.  A message that appears when the cell is selected, providing instructions or information

C.  A warning message that appears when the cell is about to be deleted

D.  A message that appears when the worksheet is saved

Question 55:  What is an error alert in data validation?

A.  A message that appears when the cell is selected

B.  A message that appears when valid data is entered

C.  A message that appears when invalid data is entered

D.  A message that appears when the worksheet is printed

Working with Tables

Question 56: What is the advantage of using an Excel table to organize data?

A. Tables automatically apply formatting to the data.

B. Tables make it easier to filter and sort data.

C. Tables can be used to create charts.

D. All of the above.

Question 57:  How do you create an Excel table?

A.  By selecting the data and clicking the “Format as Table” option

B.  By inserting a table from the Insert tab

C.  By using the “Create Table” dialog box

D.  All of the above

Question 58:  What are structured references in Excel tables?

A.  Cell references that use column headers instead of letters and numbers

B.  Formulas that refer to cells in other worksheets

C.  Formulas that use absolute references

D.  Formulas that use named ranges

Question 59:  How do you add a new row to an Excel table?

A.  By using the Insert command

B.  By typing data in the row below the table

C.  By right-clicking and choosing “Insert Row”

D.  All of the above

Question 60:  What happens when you filter data in an Excel table?

A.  The filtered rows are deleted.

B.  The filtered rows are hidden.

C.  The filtered rows are copied to a new worksheet.

D.  The filtered rows are moved to the bottom of the table.

V. Charts and Graphs

Creating Charts

Question 61: Which chart type is best for showing trends over time?

A. Pie chart

B. Bar chart

C. Line chart

D. Scatter chart

Question 62:  Which chart type is best for comparing different categories of data?

A.  Pie chart

B.  Line chart

C.  Scatter chart

D.  Column chart

Question 63:  What must you do before creating a chart in Excel?

A.  Sort the data

B.  Filter the data

C.  Select the data you want to include in the chart

D.  Apply conditional formatting

Question 64:  Where can you find the options to insert a chart?

A.  Home tab

B.  Insert tab

C.  Data tab

D.  View tab

Question 65:  How can you change the chart type after it has been created?

A.  By right-clicking the chart and choosing “Change Chart Type”

B.  By using the “Chart Tools” tabs that appear when the chart is selected

C.  By deleting the chart and creating a new one

D.  Both A and B

Chart Elements

Question 66:  What is the purpose of a chart title?

A.  To identify the data series

B.  To provide a clear description of what the chart represents

C.  To label the horizontal axis

D.  To display the data values

Question 67:  What are the individual data values plotted on a chart called?

A.  Data series

B.  Data points

C.  Legends

D.  Trendlines

Question 68:  What is the purpose of a legend in a chart?

A.  To display the chart title

B.  To identify the different data series

C.  To label the axes

D.  To show the data source

Question 69:  What are trendlines used for in a chart?

A.  To connect all the data points

B.  To show the general direction of the data

C.  To identify outliers

D.  To display the exact data values

Question 70:  What are gridlines in a chart?

A.  Lines that connect the data points

B.  Lines that extend from the axes to help read values

C.  Lines that separate different data series

D.  Lines that highlight the trendline

Chart Formatting

Question 71:  How can you change the colors of the data series in a chart?

A.  By using the “Chart Tools” tabs

B.  By right-clicking the chart and selecting “Format Data Series”

C.  By double-clicking on the chart element you want to change

D.  All of the above

Question 72:  What options can you change in the chart layout?

A.  The position of the legend

B.  The display of chart titles and axis labels

C.  The presence of data labels

D.  All of the above

Question 73:  How can you add data labels to a chart?

A.  By using the “Chart Tools” tabs

B.  By right-clicking the data series and choosing “Add Data Labels”

C.  By selecting the chart and clicking the “Data Labels” button on the Ribbon

D.  All of the above

Question 74:  What is the purpose of data labels in a chart?

A.  To identify the different data series

B.  To display the exact values of the data points

C.  To label the axes

D.  To show the chart title

Question 75:  How can you apply a predefined style to a chart?

A.  By selecting the chart and choosing a style from the “Chart Styles” gallery

B.  By manually formatting each chart element

C.  By copying the format from another chart

D.  Both A and C

VI. Advanced Excel Features (Optional)

PivotTables

Question 76: What is the primary purpose of a PivotTable?

A. To create charts and graphs.

B. To summarize and analyze large amounts of data.

C. To automate repetitive tasks.

D. To perform complex calculations.

Question 77:  Which area in the PivotTable Fields pane is used to display summary statistics?

A.  Rows

B.  Columns

C.  Values

D.  Filters

Question 78:  What can you use the “Filters” area in a PivotTable for?

A.  To sort the data in the PivotTable

B.  To include or exclude specific data from the PivotTable

C.  To change the calculation method in the PivotTable

D.  To format the PivotTable

Question 79:  What is a PivotChart?

A.  A chart created from the data in a PivotTable

B.  A chart that shows the relationships between different PivotTables

C.  A chart that is used to create a PivotTable

D.  A chart that is linked to an external data source

Question 80:  How can you update a PivotTable after making changes to the source data?

A.  By right-clicking the PivotTable and choosing “Refresh”

B.  By clicking the “Refresh” button on the PivotTable Analyze tab

C.  By pressing F5

D.  All of the above

Macros

Question 81: What is a macro in Excel?

A. A formula that performs a complex calculation.

B. A recorded sequence of actions that can be replayed to automate tasks.

C. A tool for analyzing data.

D. A type of chart.

Question 82:  How do you record a macro in Excel?

A.  By using the “Record Macro” command on the Developer tab

B.  By writing VBA code

C.  By copying and pasting actions

D.  By using the “Macros” dialog box

Question 83:  What is the file extension for an Excel workbook that contains macros?

A.  .xlsx

B.  .xlsm

C.  .xlsb

D.  .xltx

Data Analysis Tools

Question 84: What does the Goal Seek tool do?

A.  It finds the optimal solution to a problem with multiple variables.

B.  It calculates the result of a formula for different input values.

C.  It finds the input value needed to achieve a specific target output.

D.  It analyzes data trends and predicts future values.

Question 85:  What is the purpose of the Solver add-in?

A.  To create PivotTables

B.  To record macros

C.  To find the optimal solution to a problem with constraints

D.  To perform statistical analysis

VII. Shortcuts and Time-Saving Techniques

Keyboard Shortcuts

Question 86: Which keyboard shortcut selects the entire worksheet?

A. Ctrl + A

B. Ctrl + S

C. Ctrl + C

D. Ctrl + V

Question 87:  Which keyboard shortcut moves to the beginning of the current row?

A.  Home

B.  End

C.  Page Up

D.  Page Down

Question 88:  Which keyboard shortcut applies the currency format to the selected cells?

A.  Ctrl + Shift + $

B.  Ctrl + Shift + %

C.  Ctrl + 1

D.  Alt + Enter

Question 89:  Which keyboard shortcut inserts a new worksheet?

A.  Shift + F11

B.  Ctrl + N

C.  Alt + I

D.  Ctrl + Page Down

Question 90:  Which keyboard shortcut opens the “Format Cells” dialog box?

A.  Ctrl + 1

B.  Ctrl + B

C.  Ctrl + I

D.  Ctrl + U

Efficiency Related

Question 91:  What is the most efficient way to apply the same format to multiple non-adjacent ranges?

A.  Format each range individually.

B.  Use the Format Painter.

C.  Use conditional formatting.

D.  Create a macro.

Question 92:  Which Paste Special option allows you to paste only the values from a copied cell, excluding formulas?

A.  Paste Formulas

B.  Paste Values

C.  Paste Formats

D.  Paste Transpose

Question 93:  Which Paste Special option allows you to paste only the formatting from a copied cell?

A.  Paste Formulas

B.  Paste Values

C.  Paste Formats

D.  Paste Transpose

Question 94:  Which Paste Special option switches rows and columns when pasting data?

A.  Paste Formulas

B.  Paste Values

C.  Paste Formats

D.  Paste Transpose

Question 95:  How can you quickly insert the current date into a cell?

A.  Type the date manually.

B.  Use the TODAY() function.

C.  Use the NOW() function.

D.  Both B and C

Question 96:  How can you quickly insert the current date and time into a cell?

A.  Type the date and time manually.

B.  Use the TODAY() function.

C.  Use the NOW() function.

D.  Use the DATE() function.

Question 97:  What is the purpose of the Quick Access Toolbar?

A.  To provide access to frequently used commands

B.  To display the formula bar

C.  To show the status bar

D.  To access the ribbon tabs

Question 98:  How can you add a command to the Quick Access Toolbar?

A.  Right-click the command on the Ribbon and choose “Add to Quick Access Toolbar.”

B.  Drag the command from the Ribbon to the Quick Access Toolbar.

C.  Use the “Customize Quick Access Toolbar” drop-down menu.

D.  All of the above.

Question 99:  What does the “Freeze Panes” command do?

A.  Prevents any changes to the worksheet

B.  Locks the position of rows or columns so they remain visible while scrolling

C.  Hides the selected rows or columns

D.  Protects the worksheet with a password

Question 100:  What is the purpose of using named ranges in Excel?

A.  To make formulas easier to read and understand

B.  To assign descriptive names to cells or ranges

C.  To make it easier to navigate to specific areas in a worksheet

D.  All of the above

Read Also: M S Word 100 MCQs | Master Microsoft Word

Most asked important MS Excel questions