MS Excel MCQs
What is the full form of MS Excel?
- A. Micromax Excel
- B. Microsoft Excel
- C. Micromax Excess
- D. Management Excel
Which definition best describes a cell in Excel?
- A. The crossing point of a row and column
- B. An input dialog box
- C. A rectangular marker
- D. All of these
Which zoom percentage is invalid in Excel?
- A. 500%
- B. 600%
- C. 700%
- D. None of the above
In which Microsoft program do you create slides?
- A. Word
- B. PowerPoint
- C. Excel
- D. None of these
Which feature allows you to wrap long text within a single cell?
- A. Wrap Text
- B. Click Next
- C. All
- D. None
Which of these cannot be used to enter edit mode in a cell?
- A. Double-clicking the cell
- B. Pressing the Alt key
- C. Pressing F2
- D. Clicking the formula bar
Which one is not classified as a word processor?
- A. WordPerfect
- B. Microsoft Excel
- C. WordStar
- D. Microsoft Word
To move a selected range to another sheet within the same workbook, which key do you hold while dragging?
- A. Shift
- B. Alt
- C. Tab
- D. Ctrl
Once a range is selected, how do you activate the previous cell?
- A. Press Tab
- B. Press Alt
- C. Press Enter
- D. None
Where are the tab scroll buttons located on the Excel interface?
- A. Bottom left corner
- B. Bottom right corner
- C. Top right corner
- D. None of these
In the Fill Series dialog, what is the default step value?
- A. 1
- B. 2
- C. 3
- D. 5
How many worksheets are open by default when you start Excel?
- A. 1
- B. 2
- C. 3
- D. 4
Which command breaks long text into multiple lines within a cell?
- A. Justify (Edit > Cells)
- B. Wrap Text (Format > Cells)
- C. None
- D. All of these
To clear everything from selected cells, which command do you use?
- A. Clear All
- B. Clear Delete
- C. Clear Contents
- D. All
What does Edit > Delete remove by default?
- A. Selected cells
- B. Cell formatting
- C. Cell comments
- D. All of these
Which formula type lets you perform multiple calculations in one expression?
- A. Complex Formulas
- B. Standard Formulas
- C. Array Formula
- D. All
What does the term 'workspace' refer to in Excel?
- A. A group of workbooks
- B. A group of rows
- C. A group of worksheets
- D. None
Which shortcut selects an entire column?
- A. Ctrl+R
- B. Ctrl+S
- C. Ctrl+C
- D. Ctrl+Space
Microsoft Excel is primarily a powerful __________.
- A. Spreadsheet package
- B. Word processing package
- C. DBMS package
- D. None
A number entry is stored as text if it is preceded by which character?
- A. =
- B. ’
- C. #
- D. None
Which pointer icon shows you can drag to fill a series?
- A. Large plus sign
- B. Thin plus sign
- C. Mouse pointer with anchor
- D. None
What is the shortcut to select the full column if you don’t use Ctrl+Space?
- A. Alt+Space
- B. Shift+Space
- C. Ctrl+Space
- D. None of these
Conditional formatting rules can test against which criteria?
- A. Cell value
- B. Formula
- C. Both
- D. None
Which shortcut inserts the AutoSum function?
- A. Alt+=
- B. Ctrl+Shift
- C. Alt+F1
- D. Ctrl+=
Which of these is not in the Paste Special menu?
- A. Subtract
- B. Divide
- C. SQRT
- D. None
Which feature lets you evaluate values and return an outcome?
- A. Formulas
- B. Formatting
- C. Filters
- D. None
Which series type cannot be used in the Fill Series dialog?
- A. Time
- B. AutoFill
- C. Growth
- D. All
Which method is invalid for editing cell contents?
- A. Press Alt
- B. Click formula bar
- C. Press F2
- D. None
Which zoom level is not allowed in Excel?
- A. 10%
- B. 100%
- C. 300%
- D. 500%
What indicates the active cell on the worksheet?
- A. Cell address
- B. Range
- C. Formula
- D. Highlighted cell
How do you split the Excel window into panes?
- A. Window > Split
- B. Review > Window
- C. View > Window > Split
- D. None
Which action is not performed by the Edit Clear command?
- A. Delete cells
- B. Delete notes
- C. Delete contents
- D. None
Which ways can you enter edit mode on a cell?
- A. Type directly in cell
- B. Use formula bar
- C. Use Edit mode
- D. All of these
A typical spreadsheet arranges data into:
- A. Documents
- B. Rows
- C. Rows and columns
- D. Columns
What term describes the color or pattern used to fill a shape?
- A. Shape
- B. WordArt
- C. Fill Style
- D. Fill Background
Organizing data in cells is referred to as:
- A. Sorting
- B. Deleting
- C. Arranging
- D. None
Excel would treat the entry “November 1, 2024” as a:
- A. Label
- B. Value
- C. Formula
- D. Text string
Which application displays data in rows and columns?
- A. Spreadsheet
- B. Register
- C. Form
- D. Box
The .xls extension is associated with which type of file?
- A. Windows system file
- B. Excel workbook
- C. PowerPoint presentation
- D. Access database
Which tool can help you create charts in Excel?
- A. Chart Wizard
- B. MS Word
- C. Excel itself
- D. None
Where do you find the AutoSum button?
- A. Formatting tab
- B. Formulas tab
- C. Standard tab
- D. None
Which program is best for entering and editing text?
- A. Spreadsheet
- B. PowerPoint
- C. Word processor
- D. None