MS Excel MCQs with Answers

Past Paper MCQ

Which function in Excel is used to return the remainder after a number is divided by a divisor?

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

Past Paper MCQ

How can comments be added to cells in MS Excel?

• A.Review > New Comment
• B.Insert > Comment
• C.Format > Comment
• D.Data > Add Comment

Past Paper MCQ

What is the term used for obtaining data from a cell in a different sheet in MS Excel?

• A.Merging
• B.Linking
• C.Importing
• D.Referencing

Past Paper MCQ

What is the correct formula to calculate the sum of cells A1 and A2 in MS Excel?

• A.=TOTAL(A1:A2)
• B.=ADD(A1,A2)
• C.=SUM(A1+A2)
• D.=SUM(A1:A2)

Past Paper MCQ

In Excel, what is the process of transferring data to the next worksheet called?

• A.Linking
• B.Embedding
• C.Referencing
• D.Consolidating

Past Paper MCQ

What is the graphical representation of data commonly called?

• A.Bar graph
• B.Pie chart
• C.Line graph
• D.Histogram

Which function is not included in the 'Edit, Clear' command in MS Excel?

• A.Clear All
• B.Clear Formats
• C.Clear Contents
• D.Delete cells

In MS Excel, which of the following represents a correct cell reference format?

• A.6-A
• B.6A
• C.A-6
• D.A6

What type of list is used to arrange items in a specific user-defined order?

• A.Bulleted List
• B.Numbered List
• C.Custom List
• D.Multilevel List

Which function in Excel returns both the current date and time?

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