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 Command	Action in MS Excel Sheet
F1	Opens the Help menu
F2	Edit the selected cell
F4	Repeat the last action
F5	Find a specific cell
F7	Spell checker for text
F11	Create a chart
F12	Save as Option
Ctrl + D	Fill down the cell in selection
Ctrl + H	Find and Replace
Ctrl + K	Insert Hyperlinks
Ctrl + P	Print the Excel Sheet
Ctrl + S	Save the Sheet
Ctrl + W	Close the open Workbook
Ctrl + Y	Repeat the last done action
Ctrl + Z	Undo the last done action
Ctrl + 0	Hide Selected Columns
Ctrl + 9	Hide Selected Rows
Ctrl + Shift + (	Unhide the rows
Ctrl + Shift + )	Unhide the Columns
Alt + Shift + F1	Insert new worksheet
Shift + F3	Open the formula box
Shift + F5	Open the search box
Ctrl + F9	Minimize current window
Ctrl + F10	Maximize the selected window
Ctrl + F6	Switch between open workbooks
Ctrl + Tab	Move between open Excel® files
Ctrl + Shift + ;	Enter the current time
Ctrl + ;	Enter the current date
Ctrl + Spacebar	Selects the entire column
Shift + F2	Edit a cell comment
Alt + F4	Exit 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