**Multiple Choice Questions**

In today’s world having the knowledge of Microsoft Excel is super important for students of all ages. MS Excel is a very popular computer program made by Microsoft that helps us to manage and analyze data very easily. Its been around since 1985 and it has been a game changer for organizing information at every level.

To help our students get ready for exams we have put together some top selected multiple choice questions (MCQ) about Excel. Our mcq questions cover a lots of different aspects like functions, shortcuts and formatting etc. So whether if you are just starting out or you already have a little bit of knowledge about MS Excel, our questions will help you learn & understand more.

Excel is really helpful at school, work and lots of other things. So its good to know how to use it well. With these MCQ our students can practice and improve their Excel skills making it easier to succeed in their studies, future careers or exams.

**300+ MS Word MCQ Questions and Answers | Boost Your IQ**

**MCQ Questions on Computer Basics | Multiple Choice Questions.**

**Interactive Excel MCQ Questions for Effective Learning**

Question 1. Which function can be used to calculate the average of a range of cells in Excel?

a) SUM

b) MAX

c) AVG

d) AVERAGE

Answer: d) AVERAGE.

Question 2. Which keyboard shortcut is used to open the “Format Cells” dialog box in Excel?

a) Ctrl + F

b) Ctrl + Shift + F

c) Ctrl + 1

d) Ctrl + Shift + 1

Answer: c) Ctrl + 1.

Question 3. Which function is used to find the highest value in a range in Excel?

a) HIGHEST

b) MAX

c) TOP

d) HIGH

Answer: b) MAX.

Question 4. Which Excel feature allows you to automatically fill a series of data?

a) AutoFill

b) AutoComplete

c) AutoSum

d) AutoFormat

Answer: a) AutoFill.

Question 5. Which function is used to count the number of cells in a range that meet a certain condition?

a) COUNT

b) COUNTIF

c) SUMIF

d) IF

Answer: b) COUNTIF.

Question 6. Which option in Excel allows you to freeze rows and columns so that they remain visible while scrolling?

a) Lock Cells

b) Freeze Panes

c) Hide

d) Split

Answer: b) Freeze Panes.

Question 7. In Excel, what does the function =NOW() do?

a) Returns the current date

b) Returns the current time

c) Returns both the current date and time

d) Returns the current day of the week

Answer: c) Returns both the current date and time.

Question 8. Which Excel function is used to check if a condition is true or false?

a) IF

b) TRUEFALSE

c) CHECK

d) CONDITION

Answer: a) IF.

Question 9. Which function is used to find the smallest value in a range in Excel?

a) SMALLEST

b) MIN

c) BOTTOM

d) LOW

Answer: b) MIN.

**Practice Excel Easily with MCQ Questions**

Question 10. Which Excel feature allows you to view two different parts of the same worksheet simultaneously?

a) Split

b) Duplicate

c) View Side by Side

d) Zoom

Answer: a) Split.

Question 11. Which keyboard shortcut is used to paste only the values in Excel?

a) Ctrl + V

b) Ctrl + Shift + V

c) Ctrl + Alt + V

d) Ctrl + Shift + C

Answer: c) Ctrl + Alt + V.

Question 12. Which Excel function is used to calculate the square root of a number?

a) SQRT

b) ROOT

c) SQR

d) SQUARE

Answer: a) SQRT.

Question 13. In Excel, which function is used to join the contents of two or more cells together?

a) CONCAT

b) COMBINE

c) JOIN

d) CONCATENATE

Answer: d) CONCATENATE.

Question 14. Which Excel feature allows you to protect a worksheet from being edited?

a) Lock Cells

b) Freeze Panes

c) Hide

d) Protect Sheet

Answer: d) Protect Sheet.

Question 15. Which function is used to round a number down to the nearest integer in Excel?

a) ROUND

b) CEILING

c) FLOOR

d) ROUNDUP

Answer: c) FLOOR.

Question 16. Which Excel feature allows you to display a set of data vertically and horizontally at the same time?

a) Freeze Panes

b) Split

c) View Side by Side

d) Arrange All

Answer: d) Arrange All.

Question 17. In Excel, which function is used to calculate the total number of cells in a range that contain numbers?

a) TOTAL

b) NUM

c) COUNT

d) COUNTNUMS

Answer: d) COUNTNUMS.

Question 18. Which keyboard shortcut is used to insert a new worksheet in Excel?

a) Ctrl + N

b) Ctrl + I

c) Shift + N

d) Shift + I

Answer: a) Ctrl + N.

**Master Microsoft MS Excel Easily with These MCQ Questions**

Question 19. Which Excel function is used to convert a text string to lowercase?

a) LOWER

b) TEXTLOWER

c) CONVERTCASE

d) LCASE

Answer: a) LOWER.

Question 20. In Excel, which function is used to return the current row number?

a) ROW

b) CURRENTROW

c) GETROW

d) ROWNUM

Answer: a) ROW.

Question 21. Which Excel feature allows you to apply a predefined set of colors, fonts, and effects to a range of cells?

a) AutoFill

b) AutoFormat

c) Conditional Formatting

d) Format Painter

Answer: b) AutoFormat.

Question 22. Which keyboard shortcut is used to select the entire worksheet in Excel?

a) Ctrl + A

b) Ctrl + E

c) Ctrl + W

d) Ctrl + S

Answer: a) Ctrl + A.

Question 23. Which Excel function is used to count the number of cells in a range that are not empty?

a) NONBLANK

b) NOTEMPTY

c) COUNT

d) COUNTA

Answer: d) COUNTA.

Question 24. Which Excel feature allows you to automatically adjust the width of a column to fit the contents?

a) AutoFit

b) AutoSize

c) Fit Content

d) Adjust Width

Answer: a) AutoFit.

Question 25. In Excel, which function is used to extract a specific number of characters from a text string?

a) SUBSTRING

b) EXTRACT

c) MID

d) STRPART

Answer: c) MID.

Question 26. Which keyboard shortcut is used to delete a selected column in Excel?

a) Ctrl + D

b) Ctrl + X

c) Ctrl + Delete

d) Ctrl + –

Answer: d) Ctrl + -.

Question 27. Which Excel function is used to calculate the exponential growth of a value over time?

a) EXP

b) GROWTH

c) EXPONENTIAL

d) GROW

Answer: b) GROWTH.

**Get Ready for Your Excel Exam with Multiple Choice Questions**

Question 28. In Excel, which function is used to return the current column number?

a) COL

b) COLUMN

c) GETCOL

d) CURRENTCOLUMN

Answer: b) COLUMN.

Question 29. Which Excel feature allows you to display a set of data in a visually appealing way using charts and graphs?

a) Sparklines

b) PivotTables

c) SmartArt

d) Conditional Formatting

Answer: c) SmartArt.

Question 30. Which keyboard shortcut is used to save an Excel workbook?

a) Ctrl + S

b) Ctrl + Shift + S

c) Ctrl + Save

d) Ctrl + W

Answer: a) Ctrl + S.

Question 31. In Excel, which function is used to calculate the factorial of a number?

a) FACT

b) FACTORIAL

c) FACTNUM

d) NUMFACT

Answer: a) FACT.

Question 32. Which Excel function is used to calculate the cosine of an angle?

a) COS

b) COSINE

c) TRIG

d) ANGLECOS

Answer: a) COS.

Question 33. Which Excel feature allows you to create a table with rows and columns of data?

a) PivotTables

b) Charts

c) Tables

d) SmartArt

Answer: c) Tables.

Question 34. Which keyboard shortcut is used to open the “Find and Replace” dialog box in Excel?

a) Ctrl + F

b) Ctrl + R

c) Ctrl + H

d) Ctrl + Shift + F

Answer: c) Ctrl + H.

Question 35. In Excel, which function is used to calculate the sine of an angle?

a) SIN

b) SINE

c) TRIG

d) ANGLESIN

Answer: a) SIN.

Question 36. Which Excel function is used to calculate the standard deviation of a set of values?

a) STDEV

b) STDDEV

c) VARIANCE

d) STDEVP

Answer: a) STDEV.

Question 37. Which Excel feature allows you to automatically apply formatting based on certain conditions?

a) AutoFormat

b) AutoFill

c) Conditional Formatting

d) Format Painter

Answer: c) Conditional Formatting.

**Explore Excel with These Engaging MCQ Questions**

Question 38. Which keyboard shortcut is used to undo the last action in Excel?

a) Ctrl + Z

b) Ctrl + U

c) Ctrl + Y

d) Ctrl + Shift + Z

Answer: a) Ctrl + Z.

Question 39. In Excel, which function is used to calculate the tangent of an angle?

a) TAN

b) TANGENT

c) TRIG

d) ANGLETAN

Answer: a) TAN.

Question 40. Which Excel function is used to convert a value to radians?

a) RAD

b) RADIANS

c) DEG2RAD

d) TORAD

Answer: b) RADIANS.

Question 41. Which Excel feature allows you to automatically sum a range of adjacent cells?

a) AutoSum

b) AutoFill

c) AutoCalculate

d) AutoTotal

Answer: a) AutoSum.

Question 42. Which keyboard shortcut is used to select the entire row in Excel?

a) Ctrl + R

b) Ctrl + Shift + R

c) Shift + Spacebar

d) Ctrl + Spacebar

Answer: c) Shift + Spacebar.

Question 43. In Excel, which function is used to calculate the natural logarithm of a number?

a) LOG

b) LN

c) LOGN

d) NATLOG

Answer: b) LN.

Question 44. Which Excel function is used to convert radians to degrees?

a) DEG

b) DEGREES

c) RAD2DEG

d) TORAD

Answer: b) DEGREES.

Question 45. Which Excel feature allows you to quickly apply a set of commonly used formatting options to a cell or range?

a) Quick Styles

b) AutoFormat

c) Quick Format

d) Format Painter

Answer: a) Quick Styles.

Question 46. Which keyboard shortcut is used to open the “Page Setup” dialog box in Excel?

a) Ctrl + P

b) Ctrl + Shift + P

c) Ctrl + Shift + S

d) Ctrl + Shift + O

Answer: b) Ctrl + Shift + P.

**Master Your Excel Knowledge With Us**

Question 47. In Excel, which function is used to calculate the hyperbolic cosine of a number?

a) COSH

b) HYPERCOS

c) HYPERCOSH

d) HYPCOS

Answer: a) COSH.

Question 48. Which Excel function is used to calculate the future value of an investment?

a) FV

b) FUTUREVAL

c) FVAL

d) INVESTVAL

Answer: a) FV.

Question 49. Which Excel feature allows you to quickly apply a previously used action or command?

a) Quick Access Toolbar

b) AutoFill

c) AutoComplete

d) Quick Analysis

Answer: a) Quick Access Toolbar.

Question 50. Which keyboard shortcut is used to select multiple non-adjacent cells in Excel?

a) Ctrl + Click

b) Shift + Click

c) Alt + Click

d) Ctrl + Alt + Click

Answer: d) Ctrl + Alt + Click.

Question 51. In Excel, which function is used to calculate the sum of squares of a set of values?

a) SUMSQ

b) SQUARESUM

c) SUMSQUARES

d) SQRTSUM

Answer: a) SUMSQ.

Question 52. Which Excel function is used to calculate the present value of an investment?

a) PV

b) PRESENTVAL

c) PVAL

d) INVESTPRESENT

Answer: a) PV.

Question 53. Which Excel feature allows you to quickly insert commonly used functions into a formula?

a) Function Wizard

b) Function Library

c) Formula AutoComplete

d) Function Quick Insert

Answer: c) Formula AutoComplete.

Question 54. Which keyboard shortcut is used to switch between open Excel workbooks?

a) Ctrl + Tab

b) Ctrl + Shift + Tab

c) Alt + Tab

d) Alt + Shift + Tab

Answer: c) Alt + Tab.

Question 55. In Excel, which function is used to calculate the sum of the absolute values of a set of numbers?

a) ABSUM

b) SUMABS

c) ABS

d) SUMPRODUCT

Answer: b) SUMABS.

**MS Excel Challenge**

Question 56. Which Excel function is used to calculate the internal rate of return for a series of cash flows?

a) IRR

b) RATE

c) INTRETURN

d) INTRATE

Answer: a) IRR.

Question 57. Which Excel feature allows you to display a set of data in a compact, summarized format?

a) PivotTables

b) Charts

c) Tables

d) SmartArt

Answer: a) PivotTables.

Question 58. Which keyboard shortcut is used to insert the current date in Excel?

a) Ctrl + D

b) Ctrl + Shift + D

c) Ctrl + ;

d) Ctrl + Shift + ;

Answer: c) Ctrl + ;

Question 59. In Excel, which function is used to calculate the total interest paid for a loan over a specific period?

a) INTEREST

b) TOTALINTEREST

c) IPMT

d) INT

Answer: c) IPMT.

Question 60. Which Excel function is used to calculate the cumulative interest paid on a loan up to a specific payment period?

a) CUMIPMT

b) INTEREST

c) CUMINTEREST

d) INT

Answer: a) CUMIPMT.

Question 61. In Excel, which function is used to calculate the number of periods required to pay off a loan?

a) NPV

b) NPER

c) PERIODS

d) LOANNPER

Answer: b) NPER.

Question 62. Which Excel feature allows you to link data from one worksheet to another?

a) Data Linking

b) Data Connection

c) Data Consolidation

d) Data Integration

Answer: c) Data Consolidation.

Question 63. Which keyboard shortcut is used to format cells as currency in Excel?

a) Ctrl + $

b) Ctrl + Shift + $

c) Ctrl + Shift + !

d) Ctrl + Shift + #

Answer: b) Ctrl + Shift + $.

Question 64. In Excel, which function is used to calculate the number of periods required to double an investment?

a) DOUBLINGTIME

b) DOUBLEPERIODS

c) DOUBLERATE

d) NPER

Answer: a) DOUBLINGTIME.

**Dive Into Excel with These MCQ Questions for Students**

Question 65. Which Excel function is used to calculate the future value of an investment based on periodic, constant payments and a constant interest rate?

a) FV

b) FUTUREVAL

c) FVAL

d) FUTUREINVEST

Answer: a) FV.

Question 66. In Excel, which function is used to calculate the net present value of an investment?

a) NPV

b) NETPRESENTVAL

c) NVAL

d) INVESTNPV

Answer: a) NPV.

Question 67. Which Excel feature allows you to create dynamic reports and summaries from large datasets?

a) PivotTables

b) Charts

c) Tables

d) SmartArt

Answer: a) PivotTables.

Question 68. Which keyboard shortcut is used to open the “Go To” dialog box in Excel?

a) Ctrl + G

b) Ctrl + Shift + G

c) Ctrl + F

d) Ctrl + Shift + F

Answer: a) Ctrl + G.

Question 69. In Excel, which function is used to calculate the total principal paid for a loan over a specific period?

a) PRIN

b) TOTALPRIN

c) PPMT

d) PAYMENT

Answer: c) PPMT.

Question 70. Which Excel function is used to calculate the cumulative principal paid on a loan up to a specific payment period?

a) CUMPRIN

b) PRINCIPAL

c) CUMPRINC

d) PRIN

Answer: c) CUMPRINC.

Question 71. In Excel, which function is used to calculate the payment for a loan based on constant payments and a constant interest rate?

a) PMT

b) PAYMENT

c) LOANPAYMENT

d) LOANPMT

Answer: a) PMT.

Question 72. Which Excel feature allows you to define a set of rules to automatically format cells based on their values?

a) AutoFormat

b) AutoFill

c) Conditional Formatting

d) Format Painter

Answer: c) Conditional Formatting.

**Excel MCQ Questions – Perfect Your Excel Skills Now**

Question 73. Which keyboard shortcut is used to apply bold formatting to selected text in Excel?

a) Ctrl + B

b) Ctrl + Shift + B

c) Ctrl + U

d) Ctrl + Shift + U

Answer: a) Ctrl + B.

Question 74. In Excel, which function is used to calculate the interest portion of a loan payment for a specific period?

a) INT

b) INTEREST

c) IPMT

d) LOANINTEREST

Answer: c) IPMT.

Question 75. Which Excel function is used to calculate the cumulative interest paid on a loan up to a specific payment period?

a) CUMIPMT

b) INTEREST

c) CUMINTEREST

d) INT

Answer: c) CUMINTEREST.

Question 76. In Excel, which function is used to calculate the number of periods required to pay off a loan?

a) NPV

b) NPER

c) PERIODS

d) LOANNPER

Answer: b) NPER.

Question 77. Which Excel feature allows you to link data from one worksheet to another?

a) Data Linking

b) Data Connection

c) Data Consolidation

d) Data Integration

Answer: c) Data Consolidation.

Question 78. Which keyboard shortcut is used to format cells as currency in Excel?

a) Ctrl + $

b) Ctrl + Shift + $

c) Ctrl + Shift + !

d) Ctrl + Shift + #

Answer: b) Ctrl + Shift + $.

Question 79. In Excel, which function is used to calculate the number of periods required to double an investment?

a) DOUBLINGTIME

b) DOUBLEPERIODS

c) DOUBLERATE

d) NPER

Answer: a) DOUBLINGTIME.

Question 80. Which Excel function is used to calculate the future value of an investment based on periodic, constant payments and a constant interest rate?

a) FV

b) FUTUREVAL

c) FVAL

d) FUTUREINVEST

Answer: a) FV.