MS Excel MCQs with Answers

Which action should you take to delete a column in MS Excel using the shortcut menu?

• A.Double-click the column heading and choose Remove
• B.Select the column and press Ctrl + D
• C.Right-click the column heading and select Delete
• D.Click the Home tab and select Erase Column

What is a spreadsheet?

• A.A database management system for storing records
• B.A program used exclusively for creating text documents
• C.A tool designed only for making presentations
• D.An application for arranging and calculating data in grids

What are user-developed instructions for automating tasks in Microsoft Excel called?

• A.Scripts
• B.Templates
• C.Add-ins
• D.Macros

In an Excel worksheet, cells function similarly to which graphical element in the Windows interface?

• A.Text boxes
• B.Check boxes
• C.Radio buttons
• D.Scroll bars

Which software application is most suitable for recording and analyzing monthly expenses on a computer?

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

Past Paper MCQ

In a spreadsheet, what do letters represent?

• A.Rows
• B.Columns
• C.Cells
• D.Sheets

In MS Excel, what is the function of the thin black cross-shaped pointer?

• A.To select a range of cells
• B.To move the contents of a cell
• C.Complete lists and fill patterns
• D.To resize rows and columns

In MS Excel, what term is used to describe a selection that is identified by the cells at the diagonally opposite corners?

• A.Block
• B.Array
• C.Range
• D.Segment

Which software would you recommend to the Accounts Department for calculating monthly salaries and managing expenditures?

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

In MS Excel, which alignment option allows the content to spread evenly across the width of the cell?

• A.Center
• B.Justify
• C.Distributed
• D.Fill