SHORTCUT KEYS FOR MS EXCEL

SHORTCUT KEYS FOR MS EXCEL MCQS
- Which shortcut key is used to save a workbook in MS Excel?
a) Ctrl + O
b) Ctrl + S
c) Ctrl + P
d) Ctrl + W - What is the shortcut to create a new workbook in MS Excel?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + P
d) Ctrl + Shift + N - Which shortcut key will open an existing workbook?
a) Ctrl + S
b) Ctrl + P
c) Ctrl + O
d) Ctrl + Shift + O - What is the shortcut key to close the current workbook?
a) Alt + F4
b) Ctrl + W
c) Ctrl + F4
d) Ctrl + Q - Which shortcut is used to cut the selected cells in MS Excel?
a) Ctrl + C
b) Ctrl + X
c) Ctrl + V
d) Ctrl + A - Which shortcut key is used to copy the selected cells?
a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z - Which shortcut key pastes the copied data in Excel?
a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + S - What is the shortcut key to undo an action in MS Excel?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + U
d) Ctrl + R - Which shortcut key will redo the last action in Excel?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + U
d) Ctrl + R - Which shortcut key selects the entire worksheet?
a) Ctrl + Shift + A
b) Alt + A
c) Ctrl + A
d) Ctrl + E - Which shortcut is used to apply bold formatting to the selected text?
a) Ctrl + B
b) Ctrl + I
c) Ctrl + U
d) Ctrl + P - What is the shortcut to insert a new row or column in MS Excel?
a) Ctrl + Shift + –
b) Ctrl + Shift + +
c) Ctrl + Shift + =
d) Ctrl + Alt + R - Which shortcut key will delete a row or column in MS Excel?
a) Ctrl + Shift + +
b) Ctrl + –
c) Alt + Shift + –
d) Shift + Delete - Which shortcut key is used to select an entire column?
a) Shift + Space
b) Ctrl + Space
c) Alt + Space
d) Ctrl + Shift + Space - What is the shortcut to select an entire row in Excel?
a) Shift + Space
b) Ctrl + Space
c) Alt + Space
d) Ctrl + Shift + Space - What is the shortcut to apply AutoSum in Excel?
a) Ctrl + A
b) Ctrl + Shift + S
c) Alt + =
d) Alt + S - Which shortcut key opens the “Find” dialog box?
a) Ctrl + H
b) Ctrl + F
c) Ctrl + D
d) Alt + F - What is the shortcut to open the “Replace” dialog box?
a) Ctrl + F
b) Ctrl + R
c) Ctrl + H
d) Alt + R - Which shortcut key opens the Format Cells dialog box?
a) Ctrl + Shift + F
b) Ctrl + 1
c) Alt + Enter
d) Shift + F3 - What is the shortcut key to show or hide formulas in Excel?
a) Ctrl + F3
b) Alt + F3
c) Ctrl + ` (Grave accent)
d) Ctrl + Shift + F
SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL
TYPES OF SHORTCUT KEYS FOR MS EXCEL
GENERAL KEYS
Ctrl + N Create a new workbook
Ctrl + O Open existing workbook
Ctrl + S Save the workbook
Ctrl + P Print the workbook
Ctrl + W Close the workbook
Ctrl + F Find
Ctrl + H Find and replace
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + A Select all
Ctrl + B Bold
Ctrl + I Italic
FROMATTING KEYS
Ctrl + 1 Format cells
Ctrl + Shift + $ Apply currency format
Ctrl + Shift + % Apply percentage format
Ctrl + Shift + ^ Apply exponential format
Ctrl + Shift + # Apply date format
Ctrl + Shift + @ Apply time format
Ctrl + Shift + & Apply borders
Ctrl + Shift + _ Remove borders
Alt + H + O + I AutoFit column width
NAVIGATIONAL KEYS
Arrow Keys Move between cells
Ctrl + Arrow Keys Move to the edge of data region
Ctrl + Home Go to the beginning of the worksheet
Ctrl + End Go to the last cell with data
Page Up/Page Down Move the screen up or down one page
Alt + Page Down/Page Up Move one screen to the right or left
FORMULAS KEYS
Alt + = Auto sum
Ctrl + Shift + Enter Enter an array formula
Ctrl + ` (Grave accent) Show formulas
F2 Edit the active cell
F4 Repeat the last action or toggle references in a formula
Shift + F3 Open the Insert Function dialog box
ROWS AND COLUMN
Ctrl + Space Select the entire column
Shift + Space Select the entire row
Ctrl + Shift + + Insert a row or column
Ctrl + – Delete a row or column
OTHER KEYS
Ctrl + K Insert a hyperlink
Alt + Enter Insert a line break within a cell
Ctrl + Shift + L Toggle filters
Ctrl + ; Insert the current date
Ctrl + Shift + : Insert the current time
SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL SHORTCUT KEYS FOR MS EXCEL