MS Excel MCQs Multiple Choice Questions and Answers PDF: This post is all about Excel questions with answers.

**MS Excel MCQ Questions and Answers PDF | Top 100 MCQs of Excel**

**What is the shortcut key to create a new workbook in Excel?**

a) Ctrl + N

b) Ctrl + O

c) Ctrl + S

d) Ctrl + W**Answer:** a) Ctrl + N

**Which function is used to find the largest number in a range?**

a) MIN()

b) MAX()

c) AVERAGE()

d) COUNT()**Answer:** b) MAX()

**Which of the following will not be considered as a text in Excel?**

a) 12345

b) =A1+A2

c) “Hello”

d) “12345”**Answer:** b) =A1+A2

**What is the intersection of a row and a column in Excel called?**

a) Formula

b) Cell

c) Chart

d) Address**Answer:** b) Cell

**What is the default file extension for an Excel workbook?**

a) .xls

b) .doc

c) .xlsx

d) .txt**Answer:** c) .xlsx

**Which of the following functions is used to calculate the total of a range of cells?**

a) AVERAGE

b) SUM

c) COUNT

d) MAX**Answer:** b) SUM

**Which symbol is used in Excel to begin a formula?**

a) @

b) &

c) =

d) %**Answer:** c) =

**What is the function of Ctrl + D in Excel?**

a) Copy the selected text

b) Fill down the values in the selected cells

c) Delete the selected row

d) Open a new worksheet**Answer:** b) Fill down the values in the selected cells

**In Excel, which function is used to join two or more text strings together?**

a) CONCATENATE

b) JOIN

c) MERGE

d) COMBINE**Answer:** a) CONCATENATE

**What is the name of the Excel feature that suggests different chart types based on your data?**

a) Smart Charts

b) Quick Analysis

c) Data Visualizer

d) Chart Assistant**Answer:** b) Quick Analysis

**Which of the following options is used to protect a worksheet from changes?**

a) Save As

b) Freeze Panes

c) Protect Sheet

d) Lock Workbook**Answer:** c) Protect Sheet

**MS Excel Objective Questions and Answers PDF**

**Which function returns the current date and time in Excel?**

a) TODAY()

b) NOW()

c) DATE()

d) TIME()**Answer:** b) NOW()

**How do you activate the “Go To” dialog box in Excel?**

a) Ctrl + G

b) Ctrl + H

c) Ctrl + F

d) Ctrl + P**Answer:** a) Ctrl + G

**Which of the following is NOT a valid chart type in Excel?**

a) Bar

b) Line

c) Bubble

d) Image**Answer:** d) Image

**What is the purpose of the IF function in Excel?**

a) To format cells based on criteria

b) To return one value if a condition is true and another if it’s false

c) To join multiple text strings

d) To find the sum of cells**Answer:** b) To return one value if a condition is true and another if it’s false

**How can you remove data validation from a cell?**

a) Right-click and delete

b) Home > Clear > Clear Formats

c) Data > Data Validation > Clear All

d) Press Ctrl + X**Answer:** c) Data > Data Validation > Clear All

**Which of these is a conditional formatting option?**

a) Highlight Cells Rules

b) Data Bars

c) Color Scales

d) All of the above**Answer:** d) All of the above

**What does the VLOOKUP function do?**

a) Looks for a value in a column

b) Looks for a value in a row

c) Sorts values in a column

d) Filters data in a sheet**Answer:** a) Looks for a value in a column

**Which command will you use to restrict the value range of a cell?**

a) Data > Filter

b) Data > Data Validation

c) Formulas > Data Tables

d) Review > Protect Workbook**Answer:** b) Data > Data Validation

**What happens when you press Ctrl + Spacebar in Excel?**

a) It selects the entire worksheet

b) It selects the entire row

c) It selects the entire column

d) It selects the entire cell content**Answer:** c) It selects the entire column

**Which of the following can be used to add comments to a cell?**

a) Insert > Comment

b) Review > New Comment

c) Data > Add Comment

d) View > Show Comments**Answer:** b) Review > New Comment

**Which function is used to count only the numeric values in a range?**

a) COUNTA()

b) COUNTIF()

c) COUNT()

d) COUNTBLANK()**Answer:** c) COUNT()

**What is the default alignment for text entered in a cell?**

a) Left

b) Center

c) Right

d) Justify**Answer:** a) Left

**Which of the following errors appears when a formula has a divide-by-zero error?**

a) #VALUE!

b) #DIV/0!

c) #NUM!

d) #NULL!**Answer:** b) #DIV/0!

**Which of the following Excel features allows users to automatically complete a series of data?**

a) AutoComplete

b) AutoFill

c) AutoSum

d) AutoCorrect**Answer:** b) AutoFill

**What does the PMT function calculate?**

a) Loan interest rate

b) Loan payment amount

c) Total loan amount

d) Future value of investment**Answer:** b) Loan payment amount

**What is the keyboard shortcut to open the “Format Cells” dialog box?**

a) Ctrl + 1

b) Ctrl + 2

c) Ctrl + 3

d) Ctrl + 4**Answer:** a) Ctrl + 1

**Which function returns the number of characters in a text string?**

a) LEN()

b) LEFT()

c) RIGHT()

d) MID()**Answer:** a) LEN()

**Advanced Excel Objective Questions and Answers pdf**

**How can you select non-adjacent cells in Excel?**

a) By holding Shift and clicking the cells

b) By holding Alt and clicking the cells

c) By holding Ctrl and clicking the cells

d) By holding Enter and clicking the cells**Answer:** c) By holding Ctrl and clicking the cells

**Which function is used to find the average of a group of numbers in Excel?**

a) SUM()

b) AVERAGE()

c) COUNT()

d) MEDIAN()**Answer:** b) AVERAGE()

**Which of the following is the correct syntax of the IF function in Excel?**

a) IF(logical_test, [value_if_true], [value_if_false])

b) IF([value_if_true], logical_test, [value_if_false])

c) IF(logical_test, [value_if_false], [value_if_true])

d) IF([value_if_false], [value_if_true], logical_test)**Answer:** a) IF(logical_test, [value_if_true], [value_if_false])

**What is the use of Freeze Panes in Excel?**

a) To lock a specific column or row to keep it visible while scrolling

b) To protect a worksheet

c) To prevent data editing

d) To format cells**Answer:** a) To lock a specific column or row to keep it visible while scrolling

**Which of the following charts is best for showing trends over time?**

a) Pie Chart

b) Line Chart

c) Column Chart

d) Bar Chart**Answer:** b) Line Chart

**Which Excel function will you use to find the smallest value in a range?**

a) MIN()

b) MAX()

c) SMALL()

d) LOWER()**Answer:** a) MIN()

**What does the shortcut Ctrl + Shift + L do in Excel?**

a) Applies bold formatting

b) Filters the selected data

c) Selects the entire column

d) Opens the Print Preview window**Answer:** b) Filters the selected data

**Which of the following is NOT a valid data type in Excel?**

a) Text

b) Number

c) Formula

d) Date/Time**Answer:** c) Formula

**How can you quickly multiply the contents of two cells in Excel?**

a) Use the formula =A1+B1

b) Use the formula =A1*B1

c) Use the formula =A1/B1

d) Use the formula =A1-B1**Answer:** b) Use the formula =A1*B1

**Which function can be used to count the number of blank cells in a range?**

a) COUNTBLANK()

b) COUNTA()

c) COUNT()

d) COUNTIF()**Answer:** a) COUNTBLANK()

**What is the shortcut key to insert a new worksheet in Excel?**

a) Shift + F11

b) Ctrl + N

c) Alt + Shift + N

d) Ctrl + F11**Answer:** a) Shift + F11

**How can you remove duplicate entries from a range of cells?**

a) Data > Sort

b) Data > Remove Duplicates

c) Home > Clear Formats

d) Data > Data Validation**Answer:** b) Data > Remove Duplicates

**What does the shortcut Ctrl + ; (semicolon) do in Excel?**

a) Inserts the current date

b) Inserts the current time

c) Deletes the contents of the selected cell

d) Opens the Find and Replace dialog box**Answer:** a) Inserts the current date

**Which Excel feature allows you to combine data from multiple sheets into one?**

a) Data Validation

b) Consolidate

c) Subtotal

d) Scenario Manager**Answer:** b) Consolidate

**Which of the following functions will return the remainder after a number is divided by a divisor?**

a) MOD()

b) ROUND()

c) INT()

d) FLOOR()**Answer:** a) MOD()

**What is the keyboard shortcut to edit the active cell?**

a) F2

b) F4

c) F7

d) F10**Answer:** a) F2

**In Excel, what is a Pivot Table used for?**

a) To summarize, analyze, and explore data

b) To create charts

c) To create scenarios

d) To format a table**Answer:** a) To summarize, analyze, and explore data

**What does the TRIM function do in Excel?**

a) Removes all spaces from text

b) Removes extra spaces from text, leaving single spaces between words

c) Deletes text in a cell

d) Concatenates text**Answer:** b) Removes extra spaces from text, leaving single spaces between words

**Which of the following Excel functions can be used to look up values horizontally in a table?**

a) VLOOKUP

b) HLOOKUP

c) INDEX

d) MATCH**Answer:** b) HLOOKUP

**Which function can be used to find the position of a character in a text string?**

a) SEARCH()

b) FIND()

c) LEFT()

d) MID()**Answer:** b) FIND()

**How do you insert a comment in Excel?**

a) Review > New Comment

b) Data > Data Validation

c) Insert > Comment

d) File > Options**Answer:** a) Review > New Comment

**Which of the following is used to link data from one workbook to another?**

a) Hyperlink

b) External Reference

c) Data Validation

d) Text Box**Answer:** b) External Reference

**Which function is used to round a number to a specified number of digits?**

a) ROUNDUP()

b) ROUNDDOWN()

c) ROUND()

d) MROUND()**Answer:** c) ROUND()

**What does the shortcut Ctrl + Shift + “+” do in Excel?**

a) Insert a new worksheet

b) Insert a new row or column

c) Delete a row

d) Insert a chart**Answer:** b) Insert a new row or column

**Which function would you use to find the largest value that is less than or equal to a specific value in a lookup array?**

a) VLOOKUP with TRUE as the range_lookup argument

b) HLOOKUP with FALSE as the range_lookup argument

c) MATCH with 0 as the match_type argument

d) INDEX with 1 as the match_type argument**Answer:** a) VLOOKUP with TRUE as the range_lookup argument

**Which function in Excel checks whether a condition is met and returns TRUE or FALSE?**

a) AND()

b) IF()

c) ISERROR()

d) OR()**Answer:** b) IF()

**Which feature allows you to copy formatting from one cell to another?**

a) Format Painter

b) Conditional Formatting

c) Copy and Paste Special

d) AutoFormat**Answer:** a) Format Painter

**What does the COUNTIF function do in Excel?**

a) Counts the number of cells that meet a single condition

b) Counts the number of cells that meet multiple conditions

c) Counts all cells with numerical values

d) Counts blank cells**Answer:** a) Counts the number of cells that meet a single condition

**Which of the following functions will return today’s date?**

a) DATE()

b) NOW()

c) TODAY()

d) TIME()**Answer:** c) TODAY()

**What happens when you press Alt + Enter in Excel?**

a) Moves to the next cell

b) Adds a line break within a cell

c) Opens the Find dialog box

d) Inserts a new worksheet**Answer:** b) Adds a line break within a cell

**Which of the following is used to calculate the total number of cells in a range that are not empty?**

a) COUNT()

b) COUNTA()

c) COUNTBLANK()

d) SUM()**Answer:** b) COUNTA()

**What is the default alignment for numeric values in a cell?**

a) Left

b) Center

c) Right

d) Justify**Answer:** c) Right

**Which Excel function is used to find the middle value in a range?**

a) AVERAGE()

b) MEDIAN()

c) MODE()

d) MIN()**Answer:** b) MEDIAN()

**Which of the following can be used to group rows or columns in Excel?**

a) Data Validation

b) Data Consolidation

c) Data Grouping

d) Data Subtotal**Answer:** c) Data Grouping

**Which of these functions would you use to calculate the monthly payment for a loan in Excel?**

a) PMT()

b) NPV()

c) RATE()

d) FV()**Answer:** a) PMT()

**How can you remove all the borders applied to a cell?**

a) Home > Clear > Clear Formats

b) Home > Delete > Remove Borders

c) Home > Border > No Border

d) Format > Clear Borders**Answer:** c) Home > Border > No Border

**Which function would you use to count the number of cells that meet multiple conditions?**

a) COUNTIF()

b) COUNTBLANK()

c) SUMIF()

d) COUNTIFS()**Answer:** d) COUNTIFS()

**Which of the following is true about a worksheet in Excel?**

a) It can contain only text data

b) It can contain only one chart

c) It can contain multiple sheets

d) It cannot be renamed**Answer:** c) It can contain multiple sheets

**How can you display formulas in the worksheet instead of the results?**

a) Press Ctrl + F3

b) Press Ctrl + `

c) Press F2

d) Press Alt + =**Answer:** b) Press Ctrl + `

**Which of the following functions will return the largest value less than or equal to the lookup value in a lookup array?**

a) LOOKUP()

b) VLOOKUP()

c) MATCH()

d) HLOOKUP()**Answer:** a) LOOKUP()

**Which of the following is NOT a text function in Excel?**

a) LEFT()

b) PROPER()

c) CONCATENATE()

d) SUM()**Answer:** d) SUM()

**How do you apply a filter to data in Excel?**

a) Data > Sort

b) Data > Filter

c) Home > Sort & Filter

d) Review > Protect Sheet**Answer:** b) Data > Filter

**What is the primary purpose of the CONCATENATE function in Excel?**

a) To sum numbers in a range

b) To join multiple text strings into one

c) To count text strings in a range

d) To format text**Answer:** b) To join multiple text strings into one

**Which Excel function would you use to retrieve a value from a specific row and column in a table?**

a) INDEX()

b) MATCH()

c) VLOOKUP()

d) HLOOKUP()**Answer:** a) INDEX()

**How do you open the Format Cells dialog box quickly?**

a) Right-click and select Format Cells

b) Press Ctrl + Shift + 1

c) Press Ctrl + 1

d) Press Alt + F1**Answer:** c) Press Ctrl + 1

**What is the effect of using the absolute cell reference ($A$1) in a formula?**

a) The cell reference will change when copied to another cell

b) The cell reference will remain constant when copied

c) The cell reference will change in rows only

d) The cell reference will change in columns only**Answer:** b) The cell reference will remain constant when copied

**Which of the following is true about Named Ranges in Excel?**

a) They can only refer to a single cell

b) They make formulas easier to read

c) They cannot be used in charts

d) They are automatically deleted when the workbook is closed**Answer:** b) They make formulas easier to read

**Which function calculates the future value of an investment based on periodic, constant payments and a constant interest rate?**

a) FV()

b) PV()

c) PMT()

d) NPV()**Answer:** a) FV()

**How can you change the format of multiple cells at once?**

a) Select cells and press Ctrl + 1

b) Format > Cells

c) Select cells and right-click to choose Format Cells

d) All of the above**Answer:** d) All of the above

**What is the result of the formula =A1 + A2 * A3 if A1=2, A2=3, and A3=4?**

a) 14

b) 20

c) 12

d) 10**Answer:** c) 14 (according to order of operations)

**What feature would you use to create a chart from selected data in Excel?**

a) Data Validation

b) Chart Wizard

c) PivotTable

d) Insert Chart**Answer:** d) Insert Chart

**Which of the following actions would NOT create a hyperlink in Excel?**

a) Using the HYPERLINK function

b) Right-clicking a cell and selecting Hyperlink

c) Pressing Ctrl + K

d) Selecting Data Validation**Answer:** d) Selecting Data Validation

**Which function can be used to remove all non-printable characters from a text string?**

a) TRIM()

b) CLEAN()

c) SUBSTITUTE()

d) REPLACE()**Answer:** b) CLEAN()

**What is the purpose of the IFERROR function in Excel?**

a) To calculate errors in formulas

b) To handle errors and return a specified value if an error occurs

c) To find the first error in a range

d) To format error messages**Answer:** b) To handle errors and return a specified value if an error occurs

**Which of the following will NOT work as a data validation rule in Excel?**

a) Whole number

b) List

c) Decimal

d) Formula**Answer:** d) Formula

**What feature allows you to create a visual representation of data trends over time in Excel?**

a) Sparkline

b) Data Bar

c) Conditional Formatting

d) SmartArt**Answer:** a) Sparkline

**Which of the following shortcuts will allow you to quickly sum a column of numbers?**

a) Alt + =

b) Ctrl + S

c) Shift + S

d) Ctrl + R**Answer:** a) Alt + =

**What does the DATEDIF function calculate?**

a) The difference between two dates in years, months, or days

b) The current date and time

c) The total number of days in a month

d) The end date of a given period**Answer:** a) The difference between two dates in years, months, or days

**Which of the following can be used to create a dropdown list in a cell?**

a) Data > Filter

b) Data > Data Validation

c) Home > Conditional Formatting

d) Insert > Comment**Answer:** b) Data > Data Validation

**What does the LOOKUP function do in Excel?**

a) Searches for a value in a range and returns a corresponding value

b) Counts the number of occurrences of a value

c) Sorts data in ascending or descending order

d) Merges multiple cells into one**Answer:** a) Searches for a value in a range and returns a corresponding value

**Which of the following options can you use to highlight duplicate values in a range?**

a) Conditional Formatting

b) Data Validation

c) Data Consolidation

d) Sorting**Answer:** a) Conditional Formatting

**How can you protect a worksheet in Excel?**

a) File > Options > Protect Workbook

b) Review > Protect Sheet

c) Home > Format > Protect Sheet

d) Data > Security > Protect Sheet**Answer:** b) Review > Protect Sheet

**Which of the following functions can be used to calculate the average of a range of cells?**

a) AVERAGEIF()

b) MEAN()

c) AVERAGEA()

d) AVERAGE()**Answer:** d) AVERAGE()

**What does the function TEXT() do in Excel?**

a) Converts text to numbers

b) Formats a number and converts it to text

c) Removes text from a cell

d) Counts the number of text entries**Answer:** b) Formats a number and converts it to text

**Which of the following is NOT a valid option in the Sort dialog box?**

a) Sort by values

b) Sort by color

c) Sort by formula

d) Sort by font**Answer:** c) Sort by formula

**Which shortcut can you use to quickly create a chart from the selected data?**

a) Alt + F1

b) Ctrl + C

c) Shift + F11

d) Ctrl + N**Answer:** a) Alt + F1

**What does the COUNT function do?**

a) Counts the number of cells containing any text

b) Counts all cells with numeric values

c) Counts only blank cells

d) Counts the number of unique values**Answer:** b) Counts all cells with numeric values

**What happens when you use the F4 key after selecting a cell reference in a formula?**

a) It opens the Function Arguments dialog box

b) It toggles between relative and absolute references

c) It calculates the formula

d) It copies the cell reference**Answer:** b) It toggles between relative and absolute references

**Which of the following formulas will find the total of cells A1 through A10?**

a) =TOTAL(A1)

b) =SUM(A1)

c) =ADD(A1)

d) =AGGREGATE(A1)**Answer:** b) =SUM(A1)

**Which of the following features allows you to group data and perform calculations on it?**

a) Filter

b) PivotTable

c) Chart

d) Table**Answer:** b) PivotTable

**What does the ROUNDUP function do in Excel?**

a) Rounds a number down to the nearest integer

b) Rounds a number up to the nearest integer

c) Rounds a number to the nearest multiple of a specified value

d) Rounds a number to a specified number of digits**Answer:** b) Rounds a number up to the nearest integer

**Which of the following statements is true regarding data in Excel?**

a) Data can only be stored in rows

b) Data can only be stored in columns

c) Data can be stored in both rows and columns

d) Data cannot be stored in Excel**Answer:** c) Data can be stored in both rows and columns

**FAQs on MS Excel**

### 1. **What is MS Excel?**

MS Excel is a spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas. It is widely used for data analysis, financial modeling, and project management due to its ability to handle large datasets and perform complex calculations.

### 2. **How can I create a formula in Excel?**

To create a formula, click on the cell where you want the result to appear, type `=`

, and then enter your formula. For example, to add two numbers, type `=A1 + B1`

and press Enter. Excel will compute the result.

### 3. **What is the difference between a workbook and a worksheet?**

A **workbook** is an Excel file that contains one or more **worksheets**. Each worksheet is a grid of rows and columns where you can input and analyze data. You can switch between worksheets using the tabs at the bottom of the workbook.

### 4. **How can I freeze rows or columns in Excel?**

To freeze rows or columns, go to the “View” tab, click on “Freeze Panes,” and choose the appropriate option (e.g., “Freeze Top Row” to freeze the top row). This helps keep certain rows or columns visible while scrolling.

### 5. **How do I sort data in Excel?**

To sort data, highlight the data range, go to the “Data” tab, and click on “Sort.” You can sort by specific columns in ascending or descending order. Sorting can help organize your data more effectively.

### 6. **What is a Pivot Table in Excel?**

A **Pivot Table** is a powerful tool in Excel that allows you to summarize, analyze, and explore large sets of data. It enables you to group and calculate data based on different categories without changing the original dataset.

### 7. **How do I use conditional formatting?**

To use **Conditional Formatting**, select the cells you want to format, go to the “Home” tab, click on “Conditional Formatting,” and choose the rule you want (e.g., highlight cells greater than a certain value). This feature makes it easy to visually differentiate data based on conditions.

### 8. **What is the VLOOKUP function in Excel?**

**VLOOKUP** is a function used to search for a value in the first column of a table and return a corresponding value from another column. The syntax is `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`

.

### 9. **How can I protect a worksheet in Excel?**

To protect a worksheet, go to the “Review” tab and click “Protect Sheet.” You can set a password and restrict users from editing specific cells or making structural changes to the worksheet.

### 10. **How do I remove duplicates in Excel?**

To remove duplicates, select the data range, go to the “Data” tab, and click on “Remove Duplicates.” Excel will prompt you to select which columns to check for duplicates, and it will delete any duplicate entries found.