MS Excel MCQs with Answers

Past Paper MCQ

Function for total sum:

• A.SUM()
• B.TOTAL()
• C.ADD()
• D.COUNT()

Past Paper MCQ

Add filter in MS Excel:

• A.View → Filter
• B.Home → Sort & Filter
• C.Insert → Filter
• D.Data → Filter

Past Paper MCQ

How many types of cell references are available in Microsoft Excel?

• A.2
• B.3
• C.4
• D.5

Past Paper MCQ

Which sign is used to create an absolute cell reference in MS Excel?

• A.$
• B.#
• C.&
• D.@

Past Paper MCQ

Which of the following is not a correct method of editing the contents of a cell in MS Excel?

• A.Double-click the cell
• B.Press F2 key
• C.Press the Alt key
• D.Click the formula bar

Past Paper MCQ

To return the remainder after the number is divided by a divisor in Excel we use the function?

• A.REMAINDER( )
• B.REM( )
• C.MOD( )
• D.DIV( )

Past Paper MCQ

Second Step in Creating Macros in Excel?

• A.Record the macro
• B.Assign a shortcut key
• C.Run the macro
• D.Save the macro

Past Paper MCQ

Which of the following formulas will MS-Excel 2016 not be able to calculate?

• A.=SUM(A1:A5)-10
• B.=SUM(A1:A5)*.5
• C.=SUM(A1:A5)/(10-10)
• D.=SUM(Sales)-A3

Past Paper MCQ

Complex Number Sum in Excel using?

• A.IMSUM()
• B.CSUM()
• C.COMPLEXSUM()
• D.SUMCOMPLEX()

Past Paper MCQ

MS Excel sheet consists of

• A.Rows & Columns
• B.Cells & Formulas
• C.Tables & Charts
• D.Slides & Notes