MS Excel MCQs with Answers

What type of chart is most suitable for tracking stock market progress on a daily basis?

• A.Pie chart
• B.Bar chart
• C.Line chart
• D.Scatter chart

Past Paper MCQ

In MS Excel, a cell is defined as what?

• A.A formula bar for entering data
• B.A rectangular box that contains a worksheet
• C.A collection of multiple workbooks
• D.The intersection of a column and a row

In MS Excel window the menu system is how user navigates through Excel and access the various Excel commands.

• A.Formula Bar
• B.Toolbar
• C.Status Bar
• D.Ribbon

Past Paper MCQ

Function to transpose rows/columns:

• A.Merge
• B.Concatenate
• C.Pivot
• D.Transpose

Past Paper MCQ

Excel workbook collection of:

• A.Worksheets
• B.Charts
• C.Macros
• D.Both B & C

Past Paper MCQ

Function of IF in Excel:

• A.Sort data alphabetically
• B.Sum a range of cells
• C.Count number of cells
• D.Logical test & return value

Past Paper MCQ

VLOOKUP function does:

• A.Perform vertical lookup & return value
• B.Perform horizontal lookup & return value
• C.Perform both vertical and horizontal lookup
• D.Create a pivot table

Past Paper MCQ

Basic unit in worksheet:

• A.Cell
• B.Row
• C.Column
• D.Sheet

Past Paper MCQ

Invalid Excel formula:

• A.=SUM(sales)/(10-5)
• B.=SUM(A1:A10)/(10-5)
• C.=A1+B1/(10-5)
• D.=(A1+B1)/(10-5)

Past Paper MCQ

Highest function in Excel:

• A.MAX()
• B.HIGH()
• C.TOP()
• D.LARGEST()