MS Excel Keys - Shortmcqs.com

In MS Excel Ctrl + A is used for_________?
Select All
In MS Excel Ctrl + B is used for_________?
Bold text
In MS Excel Ctrl + C is used for_________?
Copy text
In MS Excel Ctrl + D is used for_________?
Fill down
In MS Excel Ctrl + F is used for_________?
Find text
In MS Excel Ctrl + G is used for_________?
Go To
In MS Excel Ctrl + H is used for_________?
Replace text with another text
In MS Excel Ctrl + I is used for_________?
Italicize text
In MS Excel Ctrl + K is used for_________?
Insert Hyperlink
In MS Excel Ctrl + N is used for_________?
New Workbook
In MS Excel Ctrl + O is used for_________?
Open an existing Excel document
In MS Excel Ctrl + P is used for_________?
Print
In MS Excel Ctrl + R is used for_________?
Fill right
In MS Excel Ctrl + S is used for_________?
Save workbook
In MS Excel Ctrl + U is used for_________?
Underline text
In MS Excel Ctrl + V is used for_________?
Paste text
In MS Excel Ctrl + W is used for_________?
Close Excel document
In MS Excel Ctrl + X is used for_________?
Cut text
In MS Excel Ctrl + Y is used for_________?
Redo previous action / Repeat previous action
In MS Excel Ctrl + Z is used for_________?
Undo previous action
In MS Excel F1 is used for_________?
Help
In MS Excel F2 is used for_________?
Edit cell
In MS Excel F3 is used for_________?
Paste name
In MS Excel F4 is used for_________?
Repeat last action / relative refs
In MS Excel F5 is used for_________?
Go to
In MS Excel F6 is used for_________?
Next pane
In MS Excel Shift + F6 is used for_________?
Previous pane
In MS Excel F7 is used for_________?
Spell check
In MS Excel F8 is used for_________?
Extend mode
In MS Excel F9 is used for_________?
Reclulculate all workbooks
In MS Excel F10 is used for_________?
Activate menubar
In MS Excel F11 is used for_________?
New chart
In MS Excel F12 is used for_________?
Save as
In MS Excel Ctrl+: is used for_________?
Insert current time
In MS Excel Ctrl + ; is used for_________?
Insert current date
In MS Excel Ctrl + ’ is used for_________?
Copy formula from cell above
In MS Excel Ctrl + F2 is used for_________?
Print preview
In MS Excel Ctrl + F4 is used for_________?
Close workbook
In MS Excel Alt + F4 is used for_________?
Close excel
In MS Excel Delete is used for_________?
Clear cell contents
In MS Excel Ctrl + A is used for_________?
Clear cell formatting
In MS Excel Alt + H + E + F is used for_________?
Clear all
In MS Excel Alt + H + E + A is used for_________?
Apply general
In MS Excel Ctrl + ! is used for_________?
Apply number format
In MS Excel Ctrl + Shift + @ is used for_________?
Apply time format
In MS Excel Ctrl + Shift + # is used for_________?
Apply date format
In MS Excel Ctrl + Shift + $ is used for_________?
Apply currency format
In MS Excel Ctrl + Shift + % is used for_________?
Apply percentage format
In MS Excel Ctrl + Shift + ^ is used for_________?
Apply scientific format
In MS Excel Ctrl + F4 is used for_________?
Close window
In MS Excel Ctrl + F5 is used for_________?
Restore window size
In MS Excel Ctrl + F6 is used for_________?
Next window
In MS Excel Ctrl + F7 is used for_________?
Move window
In MS Excel Ctrl + F8 is used for_________?
Resize window
In MS Excel Ctrl + F9 is used for_________?
Minimize window
In MS Excel Ctrl + F10 is used for_________?
Minimize / restore window
In MS Excel Alt + V + U is used for_________?
Full screen mode
In MS Excel Esc is used for_________?
Exit full screen
In MS Excel Ctrl + Alt + ? is used for_________?
Rotate or flip screen
In MS Excel Ptrscn is used for_________?
Take screenshot
In MS Excel Ctrl + ~ is used for_________?
Formula view mode
In MS Excel Ctrl + F1 is used for_________?
Expand or collapse ribbon
In MS Excel Ctrl + F2 is used for_________?
Print preview
In MS Excel Ctrl + Shift + U is used for_________?
Expand or collapse the formula bar
In MS Excel Ctrl + Alt + V is used for_________?
Paste special dialog box
In MS Excel Ctrl + Alt + V + V is used for_________?
Paste value
In MS Excel Ctrl + Alt + V + T is used for_________?
Paste format
In MS Excel Ctrl + Alt + V + E is used for_________?
Paste & transpose
In MS Excel Ctrl + Alt + V + B is used for_________?
Paste and skip blanks
In MS Excel Ctrl + Shift + & is used for_________?
Add outline border
In MS Excel Alt + H + B + T is used for_________?
Add or remove top border
In MS Excel Alt + H + B + B is used for_________?
Add or remove bottom border
In MS Excel Alt + H + B + R is used for_________?
Add or remove right border
In MS Excel Alt + H + B + L is used for_________?
Add or remove left border
In MS Excel Ctrl + Shift + – is used for_________?
Remove borders
In MS Excel Ctrl + 1 is used for_________?
Format cell dialog box
In MS Excel Alt + H + W is used for_________?
Wrap text
In MS Excel Alt + H + M is used for_________?
Merge cells
In MS Excel Alt + H + A + C is used for_________?
Align center
In MS Excel Alt + H + A + L is used for_________?
Align left
In MS Excel Alt + H + A + R is used for_________?
Align right
In MS Excel Alt + H + 6 is used for_________?
Indent
In MS Excel Alt + H + 5 is used for_________?
Remove indent
In MS Excel Alt + H + F + G is used for_________?
Increase font size
In MS Excel Alt + H + F + K is used for_________?
Decrease font size
In MS Excel Alt + H + L is used for_________?
Conditional formatting
In MS Excel Alt + H + F + P is used for_________?
Format painter
In MS Excel Alt + H + H is used for_________?
Highlight cell
In MS Excel Alt + H + H is used for_________?
Fill color
In MS Excel Alt + N + V is used for_________?
Pivot table
In MS Excel Alt + F1 is used for_________?
Chart on same worksheet
In MS Excel F11 is used for_________?
Chart on new worksheet
In MS Excel Alt + Shift + ? is used for_________?
Group pivot table items
In MS Excel Alt + Shift + ? is used for_________?
Ungroup pivot table items
In MS Excel Enter is used for_________?
Enter text and move down
In MS Excel Tab is used for_________?
Enter text and move right
In MS Excel Shift + Enter is used for_________?
Enter text and move up
In MS Excel Shift + Tab is used for_________?
Enter text and move left
In MS Excel Ctrl + Enter is used for_________?
Enter same data in multiple cells
In MS Excel Ctrl + E is used for_________?
Flash fill
In MS Excel Ctrl + D is used for_________?
Flash down
In MS Excel Ctrl + R is used for_________?
Flash right
In MS Excel Ctrl + Shift + = is used for_________?
Insert dialog box
In MS Excel Alt + Enter is used for_________?
Line break
In MS Excel Shift + F2 is used for_________?
Comment
In MS Excel Shift + F3 is used for_________?
Paste a function into a formula
In MS Excel Ctrl + Shift +F3 is used for_________?
Create names from row and column labels
In MS Excel Ctrl + Shift + 2is used for_________?
Time format
In MS Excel ? is used for_________?
Move one cell
In MS Excel Page up is used for_________?
Move one screen up
In MS Excel Page down is used for_________?
Move one screen down
In MS Excel Ctrl + A is used for_________?
Move one screen right
In MS Excel Home is used for_________?
Move to beginning of row
In MS Excel Ctrl + Home is used for_________?
Move to first cell in worksheet
In MS Excel Ctrl + End is used for_________?
Move to last used cell in worksheet
In MS Excel Alt + = is used for_________?
Sum selected cells
In MS Excel Ctrl + Shift + Enter is used for_________?
Create array formula
In MS Excel Ctrl + F3 is used for_________?
Name manager dialogbox
In MS Excel F9 is used for_________?
Refresh
In MS Excel Tab is used for_________?
Next control
In MS Excel Shift + Tab is used for_________?
Previous control
In MS Excel Alt + M + P is used for_________?
Trace precedents
In MS Excel Alt + M + D is used for_________?
Trace dependents
In MS Excel Home is used for_________?
Go to beginning of cell
In MS Excel End is used for_________?
Go to end of cell
In MS Excel Shift + ? is used for_________?
Select character
In MS Excel Ctrl + ? is used for_________?
Move one word right or left
In MS Excel Ctrl + Shift + ? is used for_________?
Select one word right or left
In MS Excel Backspace is used for_________?
Delete character to the left of cursor
In MS Excel Delete is used for_________?
Delete character to the right of cursor
In MS Excel Shift + F11 is used for_________?
Insert new worksheet
In MS Excel Ctrl + PgDn is used for_________?
Go to next worksheet
In MS Excel Ctrl + PgUp is used for_________?
Go to previous worksheet
In MS Excel Ctrl + Tab is used for_________?
Go to next workbook
In MS Excel Ctrl + Shift + Tab is used for_________?
Go to previous workbook
In MS Excel Ctrl + F9 is used for_________?
Minimize current workbook window
In MS Excel Ctrl + F10 is used for_________?
Maximize current workbook window
In MS Excel F11 is used for_________?
Insert chart in worksheet
In MS Excel Ctrl + Shift + L is used for_________?
Filter
In MS Excel Alt + ? is used for_________?
Activate filter
In MS Excel Ctrl + T is used for_________?
Crate table
In MS Excel Alt + F11 is used for_________?
Open visual basic (VBA) editor
In MS Excel Alt + F8 is used for_________?
Open macros
In MS Excel Ctrl + Pause is used for_________?
Stop running macro
In MS Excel Ctrl + + is used for_________?
Insert row
In MS Excel Ctrl + + is used for_________?
Insert column
In MS Excel Ctrl + – is used for_________?
Delete row
In MS Excel Ctrl + – is used for_________?
Delete column
In MS Excel Ctrl + – is used for_________?
Delete cell
In MS Excel Ctrl + 0 is used for_________?
Hide column
In MS Excel Ctrl + Shift + 0 is used for_________?
Unhide column
In MS Excel Ctrl + 9 is used for_________?
Hide row
In MS Excel Ctrl + Shift + 9 is used for_________?
Unhide row
In MS Excel Ctrl + + is used for_________?
Insert dialog box
In MS Excel Ctrl + – is used for_________?
Delete dialog box
In MS Excel Alt + Shift + ? is used for_________?
Group rows/columns
In MS Excel Alt + Shift + ? is used for_________?
Ungroup rows / columns
In MS Excel Shift + Space is used for_________?
Select entire row
In MS Excel Ctrl + Space is used for_________?
Select entire column
In MS Excel Ctrl + A is used for_________?
Select entire worksheet
In MS Excel Ctrl + Mouse is used for_________?
Zoom in / zoom out
In MS Excel Ctrl + Drag is used for_________?
Drag and copy
In MS Excel Drag is used for_________?
Drag and cut
In MS Excel Shift + Drag is used for_________?
Drag and insert
In MS Excel Ctrl + Shift + Drag is used for_________?
Drag and insert copy
In MS Excel Alt + H is used for_________?
Home tab
In MS Excel Alt + N is used for_________?
Insert tab
In MS Excel Alt + P is used for_________?
Page layout tab
In MS Excel Alt + M is used for_________?
Formulas tab
In MS Excel Alt + A is used for_________?
Data tab
In MS Excel Alt + R is used for_________?
Review tab
In MS Excel Alt + W is used for_________?
View tab
In MS Excel Ctrl + A is used for_________?
Hide / show objects
In MS Excel Shift + F7 is used for_________?
Thesaurus Dialog Box
In MS Excel Alt+Menu Key+I is used for_________?
Error checking menu
In MS Excel Ctrl + F3 is used for_________?
Name manager
In MS Excel Ctrl + Shift + – is used for_________?
Remove outline borders
In MS Excel Ctrl + Shift + ! is used for_________?
Number format
In MS Excel Ctrl + Shift + # is used for_________?
Date format
In MS Excel Ctrl + Shift + $ is used for_________?
Currency format
In MS Excel Ctrl + Shift + % is used for_________?
Percentage format
In MS Excel Ctrl + Shift + & is used for_________?
Border
In MS Excel Ctrl + ( is used for_________?
Insert Row
In MS Excel Ctrl + Shift + ) is used for_________?
Insert Column
In MS Excel Ctrl + Shift + ^ is used for_________?
Number