MS Excel MCQs with Answers

What is the default alignment for text and numbers in a cell in MS Excel?

• A.Text left aligned and numbers right aligned
• B.Text right aligned and numbers left aligned
• C.Both text and numbers are center aligned
• D.Both text and numbers are left aligned

When will a smart tag be removed from a cell in MS Excel?

• A.When the cell is formatted
• B.When the worksheet is saved
• C.When the data in the cell is changed or deleted
• D.When Excel is closed

What does 'locking the cells' in a worksheet mean?

• A.Protecting the worksheet
• B.Hiding the formulas in cells
• C.Deleting the contents of cells
• D.Merging multiple cells together

In MS Excel, which pointer indicates that you can drag the cell content to another cell?

• A.Mouse Pointer with anchor at the tip
• B.Four-headed arrow pointer
• C.I-beam pointer
• D.Fill handle (thin cross) pointer

Past Paper MCQ

Which of the following formulas is NOT correctly entered in Excel?

• A.=SUM(A1:A5)
• B.=AVERAGE(B1:B10)
• C.C1+15
• D.=IF(A1>10,"Yes","No")

In MS Excel, how can a numeric value be treated as a label value?

• A.By prefixing it with an equal sign (=)
• B.By enclosing it in double quotes
• C.By prefixing it with an apostrophe (')
• D.By enclosing it in parentheses

Which of the following represents the correct syntax for an IF function in MS Excel?

• A.=IF(LogicalTest, TrueResult, FalseResult)
• B.=IF(TrueResult, FalseResult, LogicalTest)
• C.=IF(LogicalTest; TrueResult; FalseResult)
• D.=IF(LogicalTest, FalseResult, TrueResult)

When is it acceptable to allow text to extend into adjacent cells in an Excel worksheet?

• A.When adjacent cells are empty
• B.When adjacent cells contain numbers only
• C.When the worksheet is protected
• D.When text is formatted as bold

In MS Excel, if cell F7 contains the value 12 and cell H12 contains the value 30, what is the result of the formula =F7*H12?

• A.360
• B.42
• C.330
• D.312

Which type of software application is most suitable for performing numerical and statistical calculations?

• A.Word Processor
• B.Spreadsheet
• C.Presentation Software
• D.Database Management System