MS Excel MCQs

The most repeated MS Excel MCQs and essential shortcut keys from past competitive exams for effective computer mcq tests preparation online.

Basic Shortcut keys of ms excel

Input CommandAction in MS Excel Sheet
F1Opens the Help menu
F2Edit the selected cell
F4Repeat the last action
F5Find a specific cell
F7Spell checker for text
F11Create a chart
F12Save as Option
Ctrl + DFill down the cell in selection
Ctrl + HFind and Replace
Ctrl + KInsert Hyperlinks
Ctrl + PPrint the Excel Sheet
Ctrl + SSave the Sheet
Ctrl + WClose the open Workbook
Ctrl + YRepeat the last done action
Ctrl + ZUndo the last done action
Ctrl + 0Hide Selected Columns
Ctrl + 9Hide Selected Rows
Ctrl + Shift + (Unhide the rows
Ctrl + Shift + )Unhide the Columns
Alt + Shift + F1Insert new worksheet
Shift + F3Open the formula box
Shift + F5Open the search box
Ctrl + F9Minimize current window
Ctrl + F10Maximize the selected window
Ctrl + F6Switch between open workbooks
Ctrl + TabMove between open Excel® files
Ctrl + Shift + ;Enter the current time
Ctrl + ;Enter the current date
Ctrl + SpacebarSelects the entire column
Shift + F2Edit a cell comment
Alt + F4Exit from Excel

Basic MS Excel MCQs

MS Excel stands for_______
  1. Micromax Excel
  2. Microsoft Excel
  3. Micromax Excess
  4. Management Excel
  5. All of these

A cell is defined as :

  1. The intersection of a column and a row
  2. An input box
  3. a rectangular marker
  4. All of the above
Which of the following is not valid zoom percentage in Excel:
  1. 500%
  2. 600%
  3. 700
  4. None of the above

In which software slide have?

  1. Word
  2. PowerPoint
  3. Excel
  4. None

What is used to split long text in excel within the cell?

  1. Wrap text
  2. Click next
  3. All
  4. None
Which of the following methods can not be used to edit the contents of a cell?
  1. Double clicking the cell
  2. Press the Alt key
  3. Pressing the F2 key
  4. Clicking the formula bar
Which of the following is not a word processor?
  1. Word Perfect
  2. Microsoft Excel
  3. Word Star
  4. Microsoft Word
To drag a selected range of data to another worksheet in the same workbook, use the?
  1. Shift key
  2. Alt key
  3. Tab key
  4. Ctrl key

When a range is selected, how can you activate the previous?

  1. Press Tab
  2. Press the Alt key
  3. Press Enter
  4. none
Tab scroll buttons are place on excel screen
  1. Towards the bottom left corner
  2. Towards the bottom right corner
  3. Towards the bottom top right corner
  4. None

Leave a Comment

error: Content is protected !!