MS Excel MCQs with Answers

Past Paper MCQ

In MS Excel, which operator can be used to concatenate text from two cells into one cell?

• A.At sign (@)
• B.Plus (+)
• C.Hash (#)
• D.Ampersand (&)

Past Paper MCQ

In MS Excel, which function is used to perform addition of numbers?

• A.=ADD()
• B.=SUM()
• C.=TOTAL()
• D.=PLUS()

Past Paper MCQ

In MS Excel, under which tab can you find ready-made templates in the new option?

• A.View
• B.Home
• C.Insert
• D.File

Past Paper MCQ

Which function in Excel is used to insert the current system date?

• A.CURRENT()
• B.NOW()
• C.DATE()
• D.TODAY()

Past Paper MCQ

Which of the following is not a valid data type in MS Excel?

• A.Number
• B.Text
• C.Character
• D.Logical

Past Paper MCQ

You can apply conditional formatting in Excel to check conditions against which of the following?

• A.Cell value only
• B.Formula only
• C.Both cell value and formula
• D.Neither cell value nor formula

Past Paper MCQ

In a computer spreadsheet, how are rows typically labeled?

• A.By numbers
• B.By letters
• C.By special characters
• D.By alphanumeric codes

Past Paper MCQ

What is the primary function of the horizontal scroll bar in MS Excel?

• A.To switch between open Excel workbooks
• B.To move between different worksheets
• C.To zoom in and out of the spreadsheet
• D.To view the data from left to the right

Past Paper MCQ

Which component of MS Excel displays the content of the active cell?

• A.Title bar
• B.Status bar
• C.Name box
• D.Formula bar

Past Paper MCQ

Which of the following is an example of spreadsheet software?

• A.MS Word
• B.MS Excel
• C.MS PowerPoint
• D.MS Access