# Excel MCQs With Answers for Online Test Preparation

Are you looking most important and repeated Excel MCQs With Answers for your online test preparation and competitive exams? In this section of MS Office MCQs, you will find advanced MCQs of MS Excel. All these multiple choice questions about Microsoft Excel cover all the important topics about MS Excel.

**1: Which function in Excel allows you to add up a range of numbers?**

- a) COUNT
- b) AVERAGE
- c) SUM
- d) MAX

c) SUM

**2: What is the maximum number of rows in a single worksheet in Excel?**

- a) 65,536
- b) 1,048,576
- c) 256
- d) 16,384

b) 1,048,576

**3: What is the purpose of the INDEX function in Excel?**

- a) It converts text to numbers.
- b) It returns the value of a cell in a specified row and column of a range.
- c) It calculates the average of a range of cells.
- d) It finds the highest value in a range of cells.

Answer: b)

**4: Which Excel formula is used to calculate the total number of cells in a range that meet a specific condition?**

- a) COUNT
- b) COUNTA
- c) COUNTIF
- d) COUNTBLANK

c) COUNTIF

**5: Which shortcut key combination allows you to insert the current date in Excel?**

- a) Ctrl+D
- b) Ctrl+T
- c) Ctrl+Shift+;
- d) Ctrl+Shift+:

c) Ctrl+Shift+;

**6: What does the VLOOKUP function do in Excel?**

- a) It counts the number of cells that contain numbers in a range.
- b) It searches for a value in the leftmost column of a table and returns a corresponding value from a specified column.
- c) It calculates the difference between two dates.
- d) It returns the maximum value in a range of cells.

Answer: b)

**7: Which Excel feature is used to find and remove duplicate values in a range of cells?**

- a) Sort
- b) Filter
- c) Dedupe
- d) Remove Duplicates

d) Remove Duplicates

**8: What is the function of the VLOOKUP function in Excel?**

- a) It counts the number of cells that contain numbers in a range.
- b) It searches for a value in the leftmost column of a table and returns a corresponding value from a specified column.
- c) It calculates the average of a range of numbers.
- d) It returns the maximum value in a range of cells.

Answer: b)

**9: Which Excel formula is used to round a number to a specified number of decimal places?**

- a) ROUND
- b) CEILING
- c) FLOOR
- d) TRUNC

a) ROUND

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

- a) It counts the number of cells that meet a specific condition.
- b) It calculates the total sum of a range of cells.
- c) It finds and replaces text in a worksheet.
- d) It returns the largest value in a range of cells.

Answer: a)

## MS Excel MCQ Questions with Answers

**11: Which chart type in Excel is suitable for showing trends over time?**

- a) Pie chart
- b) Scatter plot
- c) Line chart
- d) Bar chart

c) Line chart

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

- a) It calculates the difference between two dates.
- b) It performs logical tests and returns different values based on the results.
- c) It handles errors and returns a specified value if an error occurs.
- d) It counts the number of cells that contain text.

Answer: c)

**13: Which Excel formula is used to calculate the average of a range of cells, excluding any zero values?**

- a) AVERAGE
- b) SUM
- c) COUNTIF
- d) AVERAGEIF

d) AVERAGEIF

**14: Which Excel feature allows you to freeze rows and columns so that they remain visible while scrolling through a large worksheet?**

- a) Lock Cells
- b) Conditional Formatting
- c) Freeze Panes
- d) Split Window

c) Freeze Panes

**15: Which Excel formula is used to find the largest value in a range of cells?**

- a) MAX
- b) MIN
- c) LARGE
- d) BIGGEST

a) MAX

**16: What is the purpose of the CONCATENATE function in Excel?**

- a) It converts text to numbers.
- b) It combines the contents of multiple cells into a single cell.
- c) It calculates the difference between two dates.
- d) It rounds a number to the nearest integer.

Answer: b)

**17: Which keyboard shortcut key combination is used to insert the current time in a cell in Excel?**

- a) Ctrl+D
- b) Ctrl+T
- c) Ctrl+Shift+;
- d) Ctrl+Shift+:

d) Ctrl+Shift+:

**18: Which Excel function is used to calculate the average of a range of cells, excluding any zero values?**

- a) AVERAGE
- b) SUM
- c) COUNTIF
- d) AVERAGEIF

d) AVERAGEIF

**19: Which symbol is used as a reference operator in Excel formulas?**

- a) %
- b) #
- c) $
- d) @

c) $

**20: What does the SUMIF function do in Excel?**

- a) It calculates the average of a range of cells.
- b) It counts the number of cells that meet a specific condition.
- c) It finds and replaces text in a worksheet.
- d) It sums the values in a range based on a specified condition.

Answer: d)

## Microsoft Excel Online Test Preparation

**21: Which function in Excel allows you to count the number of cells that contain text?**

- a) TEXT
- b) COUNT
- c) COUNTA
- d) CHAR

c) COUNTA

**22: Which Excel feature allows you to apply a set of formatting options to a cell or range based on specified conditions?**

- a) AutoFill
- b) Data Validation
- c) Conditional Formatting
- d) PivotTables

c) Conditional Formatting

**23: What does the PMT function do in Excel?**

- a) It calculates the payment for a loan based on a constant interest rate.
- b) It returns the current date and time.
- c) It finds the highest value in a range of cells.
- d) It counts the number of cells that meet a specific condition.

Answer: a)

**24: Which Excel feature allows you to create visual representations of data using bars, columns, or slices?**

- a) Tables
- b) PivotTables
- c) Charts
- d) Filters

c) Charts

**25: How do you sort data in Excel in ascending order?**

- a) Go to the “Data” tab and click on “Sort A to Z.”
- b) Right-click on a cell and select “Sort Ascending.”
- c) Press Ctrl+S on the keyboard.
- d) Go to the “Home” tab and click on the “Sort & Filter” button.

Answer: a)

**26: Which Excel function is used to round a number to a specified number of decimal places?**

- a) ROUND
- b) CEILING
- c) FLOOR
- d) TRUNC

a) ROUND

**27: How do you insert a new worksheet in Excel?**

- a) Right-click on a sheet tab and select “Insert.”
- b) Go to the “Page Layout” tab and click on “Insert Sheet.”
- c) Press Ctrl+N on the keyboard.
- d) Go to the “View” tab and click on “Insert Sheet.”

Answer: a)

**28: Which Excel function is used to convert a text string into a number?**

- a) CONVERT
- b) VALUE
- c) NUMBER
- d) TEXT

b) VALUE

**29: What is the purpose of the COUNTBLANK function in Excel?**

- a) It counts the number of cells in a range that are not blank.
- b) It calculates the average of a range of cells, excluding any blank cells.
- c) It counts the number of blank cells in a range.
- d) It rounds a number to the nearest blank cell.

Answer: c)

**30:What is the purpose of the MAX function in Excel?**

- a) It calculates the sum of a range of cells.
- b) It returns the current date and time.
- c) It finds the highest value in a range of cells.
- d) It counts the number of cells that meet a specific condition.

Answer: c)

## Advance Excel MCQs

**31: Which Excel feature allows you to visually explore and analyze data by filtering, summarizing, and rearranging it?**

- a) Sort
- b) Filter
- c) PivotTables
- d) Freeze Panes

c) PivotTables

**32: What is the purpose of the CONCATENATE function in Excel?**

- a) It calculates the sum of a range of cells.
- b) It combines the contents of multiple cells into a single cell.
- c) It rounds a number to the nearest integer.
- d) It converts text to numbers.

Answer: b)

**33: Which Excel formula is used to calculate the square root of a number?**

- a) SQRT
- b) POWER
- c) SQ
- d) ROOT

a) SQRT

**34: How do you apply a currency format to a cell or range in Excel?**

- a) Go to the “Home” tab, click on the “Currency” button in the Number group, and select the desired currency format.
- b) Right-click on a cell and select “Currency Format.”
- c) Press Ctrl+C on the keyboard.
- d) Go to the “Format” tab and click on “Currency Format.”

Answer: a)

**35: Which Excel feature allows you to create formulas that refer to cells in other worksheets or workbooks?**

- a) Cell References
- b) Formula Bar
- c) Links
- d) Cross-Sheet References

d) Cross-Sheet References

**36: Which Excel function is used to calculate the difference between two dates?**

- a) DIFF
- b) DAYS
- c) DATEDIF
- d) DATE

c) DATEDIF

**37: How do you create a line break within a cell in Excel?**

- a) Press Alt+Enter on the keyboard.
- b) Right-click on the cell and select “Insert Line Break.”
- c) Go to the “Home” tab and click on “Line Break.”
- d) Press Ctrl+B on the keyboard.

Answer: a)

**38: What does the COUNT function do in Excel?**

- a) It counts the number of cells that meet a specific condition.
- b) It calculates the sum of a range of cells.
- c) It finds and replaces text in a worksheet.
- d) It returns the largest value in a range of cells.

Answer: a)

**39: What is the purpose of the CONCAT function in Excel?**

- a) It converts text to numbers.
- b) It combines the contents of multiple cells into a single cell.
- c) It calculates the average of a range of cells.
- d) It rounds a number to the nearest integer.

Answer: b)

## MS Excel Keyboard Shortcut MCQs

**40: Which keyboard shortcut key combination is used to insert a new worksheet in Excel?**

- a) Ctrl+N
- b) Ctrl+Shift+N
- c) Ctrl+Alt+N
- d) Ctrl+Insert

b) Ctrl+Shift+N

**41: Which keyboard shortcut key combination is used to select the entire worksheet in Excel?**

- a) Ctrl+A
- b) Ctrl+C
- c) Ctrl+X
- d) Ctrl+Z

a) Ctrl+A

**42: Which keyboard shortcut key combination is used to save the current workbook in Excel?**

- a) Ctrl+S
- b) Ctrl+C
- c) Ctrl+V
- d) Ctrl+Z

a) Ctrl+S

**43: Which keyboard shortcut key combination is used to open the Format Cells dialog box in Excel?**

- a) Ctrl+B
- b) Ctrl+I
- c) Ctrl+1
- d) Ctrl+F

c) Ctrl+1

**44: Which keyboard shortcut key combination is used to copy the selected cells in Excel?**

- a) Ctrl+C
- b) Ctrl+V
- c) Ctrl+X
- d) Ctrl+A

a) Ctrl+C

**45: Which keyboard shortcut key combination is used to paste the copied cells in Excel?**

- a) Ctrl+C
- b) Ctrl+V
- c) Ctrl+X
- d) Ctrl+A

b) Ctrl+V

**46: Which keyboard shortcut key combination is used to insert the current date in a cell in Excel?**

- a) Ctrl+D
- b) Ctrl+T
- c) Ctrl+Shift+;
- d) Ctrl+Shift+:

c) Ctrl+Shift+;

**47: Which keyboard shortcut key combination is used to undo the last action in Excel?**

- a) Ctrl+A
- b) Ctrl+C
- c) Ctrl+Z
- d) Ctrl+Y

c) Ctrl+Z

**48: Which keyboard shortcut key combination is used to format the selected cells as bold in Excel?**

- a) Ctrl+B
- b) Ctrl+I
- c) Ctrl+U
- d) Ctrl+F

a) Ctrl+B

**49: CTRL+9 in MS Excel is used for:**

- a) Hide Row
- b) Unhide Row
- c) Hide Column
- d) Unhide Column

a) Hide Row

**50: F4 is Excel is used to:**

- a) Edit Cells
- b) Anchor Cells
- c) Sava As
- d) Name a Cell

b) Anchor Cells

## Conclusion

I hope you find these Excel MCQs With Answers helpful for your test and exam. If you need more solved MCQs of Computer and MS Office for your Online Test Preparation. You can easily find them below.