December 5, 2024

MS Excel | MCQ Questions With Answers (2024)

Multiple Choice Questions

Fun and Interactive Excel MCQ Questions for Practice
Test Your Excel Knowledge MCQ Questions for Students

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

Microsoft MS Excel MCQ Questions Learn at Your Own Pace
Learn MS Excel in a simple & easy way with these MCQ questions

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

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

Question 3. Which function is used to find the highest value in a range in Excel?
a) HIGHEST
b) MAX
c) TOP
d) HIGH

Question 4. Which Excel feature allows you to automatically fill a series of data?
a) AutoFill
b) AutoComplete
c) AutoSum
d) AutoFormat

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

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

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

Question 8. Which Excel function is used to check if a condition is true or false?
a) IF
b) TRUEFALSE
c) CHECK
d) CONDITION

Question 9. Which function is used to find the smallest value in a range in Excel?
a) SMALLEST
b) MIN
c) BOTTOM
d) LOW

Practice Excel Easily with MCQ Questions

Top Selected Excel MCQ Questions Learn and Excel Together
Excel MCQ Questions Learn & Improve Your Knowledge Now

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

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

Question 12. Which Excel function is used to calculate the square root of a number?
a) SQRT
b) ROOT
c) SQR
d) SQUARE

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

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

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

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

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

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

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

Question 20. In Excel, which function is used to return the current row number?
a) ROW
b) CURRENTROW
c) GETROW
d) ROWNUM

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

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

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

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

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

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 + –

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

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

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

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

Question 31. In Excel, which function is used to calculate the factorial of a number?
a) FACT
b) FACTORIAL
c) FACTNUM
d) NUMFACT

Question 32. Which Excel function is used to calculate the cosine of an angle?
a) COS
b) COSINE
c) TRIG
d) ANGLECOS

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

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

Question 35. In Excel, which function is used to calculate the sine of an angle?
a) SIN
b) SINE
c) TRIG
d) ANGLESIN

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

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

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

Question 39. In Excel, which function is used to calculate the tangent of an angle?
a) TAN
b) TANGENT
c) TRIG
d) ANGLETAN

Question 40. Which Excel function is used to convert a value to radians?
a) RAD
b) RADIANS
c) DEG2RAD
d) TORAD

Question 41. Which Excel feature allows you to automatically sum a range of adjacent cells?
a) AutoSum
b) AutoFill
c) AutoCalculate
d) AutoTotal

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

Question 43. In Excel, which function is used to calculate the natural logarithm of a number?
a) LOG
b) LN
c) LOGN
d) NATLOG

Question 44. Which Excel function is used to convert radians to degrees?
a) DEG
b) DEGREES
c) RAD2DEG
d) TORAD

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

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

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

Question 48. Which Excel function is used to calculate the future value of an investment?
a) FV
b) FUTUREVAL
c) FVAL
d) INVESTVAL

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

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

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

Question 52. Which Excel function is used to calculate the present value of an investment?
a) PV
b) PRESENTVAL
c) PVAL
d) INVESTPRESENT

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

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

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

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

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

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 + ;

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

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

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

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

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 + #

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

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

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

Question 67. Which Excel feature allows you to create dynamic reports and summaries from large datasets?
a) PivotTables
b) Charts
c) Tables
d) SmartArt

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

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

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

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

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

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

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

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

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

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

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 + #

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

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

Cloud Computing | 200+ MCQ Questions With Answers.

Leave a Reply

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