info@uceagra.com
Student Enquery: +91 79005 25060
Franchise Enquery: +91 80771 91427
Work With Us
Home
(current)
Exam Portal
Online Test
Downloads
CCC Admit Card
CCC Form Apply
CCC Certificate
CCC Result
Typing Test
English Typing
Hindi Typing
Gallery
Videos
Contact us
Join us
About Us
Feedback
FAQ's
MS Excel Shortcut Keys
Question 1
What is the shortcut key of insert a new Row, Column & one Cell ?
(A) Ctrl + R
(B) Alt + (+) Plus sign
(C) Ctrl + (+) Plus sign
(D) None of these
Question 2
What is the shortcut key of Create a Dollar sign ?
(A) F5
(B) F8
(C) F7
(D) F4
Question 3
What is the shortcut key of Spelling and Grammar ?
(A) F3
(B) F4
(C) F7
(D) F8
Question 4
What is the shortcut key of Hide of Row ?
(A) Ctrl + 2
(B) Ctrl + 9
(C) Ctrl + 8
(D) Alt + 9
Question 5
What is the shortcut key of Undo ?
(A) Alt +3
(B)Ctrl + 3
(C) Ctrl + 2
(D) Alt + 2
Question 6
What is the shortcut key of Redo ?
(A) Alt + 8
(B) Alt + 3
(C) Alt + 2
(D) None of these
Question 7
What is the shortcut key of Save document ?
(A) Ctrl + Shift + 1
(B) Alt + Shift + 1
(C) Ctrl + 3
(D) None of these
Question 8
What is the shortcut key of Go to ?
(A) Alt + G
(B) Ctrl +D
(C) Ctrl +G
(D) None of these
Question 9
What is the shortcut key of Prepare a Chart ?
(A) F1
(B) F3
(C) F12
(D) F11
Question 10
What is the shortcut key of Replace ?
(A) Ctrl + R
(B) Ctrl + H
(C) Alt + R
(D) Alt + H
Question 11
What is the shortcut key of Find ?
(A) Ctrl + I
(B) Alt + F
(C) Ctrl + H
(D) Ctrl + F
Question 12
What is the shortcut key of Selected all Cell Address ?
(A) Ctrl + Space Bar
(B) Ctrl + Shift + (+) Plus Sign
(C) Ctrl + Shift + Space Bar
(D) Alt + Space Bar
Question 13
What is the shortcut key of Delete a new Row, Column & Cell ?
(A) Alt + (-) Minus sign
(B) Ctrl + (-) Minus sign
(C) Alt + (+) Plus sign
(D) None of these
Question 14
What is the shortcut key of Insert a new Sheet ?
(A) Alt + Shift + F1
(B) Shift + F1
(C) Ctrl + Shift + F1
(D) Both B & A
Question 15
What is the shortcut key of Format Cell ?
(A) Ctrl + Shift + F
(B) Ctrl + Shift + P
(C) Ctrl + 1
(D) All of the above
Question 16
What is the shortcut key of Bold of Font Style ?
(A) Ctrl + B
(B) Ctrl + 2
(C) Both A & B
(D) None of these
Question 17
What is the shortcut key of Time Format ?
(A) Ctrl + @
(B) Ctrl + Shift + @
(C) Alt + @
(D) Alt + Shift + @
Question 18
What is the shortcut key of Date Format ?
(A) Ctrl + #
(B) Alt + #
(C) Ctrl + Shift + #
(D) Alt + Shift + #
Question 19
What is the shortcut key of Hyperlink in Excel ?
(A) Alt + K
(B) Ctrl + K
(C) Shift + K
(D) None of these
Question 20
What is the shortcut key of Current Date ?
(A) Alt + ;
(B) Ctrl + :
(C) Ctrl + ;
(D) Alt + :
Question 21
What is the shortcut key of Close any Folder ?
(A) Alt + F4
(B) Ctrl + W
(C) Ctrl + F4
(D) All of the above
Question 22
What is the shortcut key of Insert a Chart in Excel
(A) Ctrl + F1
(B) Shift + F1
(C) Alt + F1
(D) None of these
Question 23
What is the shortcut key of Insert a Function ?
(A) Alt + F3
(B) Ctrl + F3
(C) Alt + Shift + F3
(D) Shift + F3
Question 24
What is the shortcut key of Return to any Sheet ?
(A) Alt + Page Up
(B) Ctrl + Page Up
(C) Shift + Page Up
(D) None of these
Question 25
What is the shortcut key of Shift any Sheet ?
(A) Alt + Page Down
(B) Shift + Page Down
(C) Ctrl +Page Down
(D) None of these
Question 26
What is the shortcut key of Wrap Text ?
(A) Ctrl + Enter
(B) Alt + Enter
(C) Shift + Enter
(D) None of these
Question 27
What is the shortcut key of Insert a Filter ?
(A) Ctrl + Shift + F
(B) Alt + Shift + F
(C) Ctrl + Shift + L
(D) Alt + Shift + L
Question 28
What is the shortcut key of Hide of Column ?
(A) Ctrl + 0
(B) Alt + 0
(C) Shift + 0
(D) None of these
Question 29
What is the shortcut key of Research any word ?
(A) Alt + Mouse click
(B) Ctrl + Mouse click
(C) Shift + Mouse click
(D) None of these
Question 30
What is the shortcut key of Thesaurus ?
(A) Alt + F7
(B) Ctrl + F7
(C) Shift + F7
(D) None of these
Question 31
What is the shortcut key of Insert a Comment in selected Cell Address ?
(A) Alt + F2
(B) Ctrl + F2
(C) Ctrl + Shift + F2
(D) Shift + F2
Question 32
What is the shortcut key of Zoom in ?
(A) Ctrl + Scroll Up
(B) Ctrl + Scroll Down
(C) Alt + Scroll Down
(D) Alt + Scroll Up
Question 33
What is the shortcut key of Auto sum ?
(A) Alt + (=) Equal 2
(B) Ctrl + (=) Equal 2
(C) Shift + (=) Equal 2
(D) None of these
Question 34
What is the shortcut key of Record Macros ?
(A) Alt + T + M
(B) Ctrl + T + M
(C) Alt + T + M + M
(D) None of these
Question 35
What is the shortcut key of Zoom on Data ?
(A) Ctrl + W + G
(B) Alt + G + W
(C) Both B & A
(D) Alt + W + G
Question 36
What is the shortcut key of Split Screen ?
(A) Ctrl + E + S
(B) Alt + E + S
(C) Shift + E + S
(D) None of these
Question 37
What is the shortcut key of Cut ?
(A) Ctrl + X
(B) Alt + E + T
(C) Both A & B
(D) None of these
Question 38
What is the shortcut key of Find & Replace ?
(A) Ctrl + E + E
(B) Alt + E + E
(C) Shift + E + E
(D) None of these
Question 39
What is the shortcut key of Page Break Preview ?
(A) Ctrl + V + P
(B) Shift + V + P
(C) Alt + V + P
(D) None of these
Question 40
What is the shortcut key of Permanently Delete the Data with Sheet ?
(A) Alt + E + L
(B) Ctrl + E + L
(C) Shift + E + L
(D) None of these
Question 41
What is the shortcut key of Insert a Symbols ?
(A) Ctrl + I + S
(B) Alt + S + I
(C) Ctrl + S + I
(D) Alt + I + S
Question 42
What is the shortcut key of Hide Upper Portion ?
(A) Ctrl + V + U
(B) Alt + V + U
(C) Shift + V + U
(D) None of these
Question 43
What is the shortcut key of Normal Preview ?
(A) Alt + V + N
(B) Ctrl + V + N
(C) Alt + V + C
(D) Ctrl + V + C
Question 44
What is the shortcut key of Zoom Percentage ?
(A) Alt + Z + V
(B) Ctrl + Z + V
(C) Alt + V + Z
(D) Ctrl + V + Z
Question 45
What is the shortcut key of Scenarios Manager ?
(A) Ctrl + T + E
(B) Alt + T + E
(C) Shift + T + E
(D) None of these
Question 46
What is the shortcut key of Auto correct Dialog Box ?
(A) Ctrl + T + A
(B) Shift + T + A
(C) Alt + Shift + T + A
(D) Alt + T + A
Question 47
What is the shortcut key of Protect Sheet ?
(A) Alt + T + P + T
(B) Ctrl + T + P + P
(C) Alt + T + P + P
(D) None of these
Question 48
What is the shortcut key of Excel Option ?
(A) Alt + T + O
(B) Ctrl + T + O
(C) Shift + T + O
(D) None of these
Question 49
What is the shortcut key of Insert Hyperlink ?
(A) Ctrl + I + I
(B) Shift + I + I
(D) Alt + I + I
(D) None of these
Question 50
What is the shortcut key of Select object ?
(A) Alt + O + I
(B) Alt + I + O
(C) Ctrl + I + O
(D) None of these
Question 51
What is the shortcut key of Insert a one Cell ?
(A) Alt + E + I
(B) Alt + I
(C) Ctrl + I
(D) Alt + I + E
Question 52
What is the shortcut key of Insert a new Sheet ?
(A) Alt + W + I
(B) Alt + I + W
(C) Ctrl + W + I
(D) Ctrl + W + I
Question 53
What is the shortcut key of Copy & Move Data ?
(A) Ctrl + M
(B) Alt + M
(C) Ctrl + E + M
(D) Alt + E + M
Question 54
What is the shortcut key of Set column Width ?
(A) Alt + O + C + W
(B) Ctrl + O + C + W
(C) Ctrl + O + W
(D) Alt + O + W
Question 55
What is the shortcut key of Insert a Pivot Table ?
(A) Alt + D + E
(B) Alt + D + D
(C) Alt + D + P
(D) None of these
Question 56
What is the shortcut key of Sort cells ?
(A) Alt + D + S
(B) Alt + A + S
(C) Ctrl + D + S
(D) None of these
Question 57
What is the shortcut key of Minimise Window ?
(A) Alt + N
(B) Alt + N + C
(C) Alt + Space bar + N
(D) None of these
Question 58
What is the shortcut key of Activate Filter ?
(A) Ctrl + Down arrow
(B) Alt + Down arrow
(C) Ctrl + Up arrow
(D) None of these
Question 59
What is the shortcut key of Set Row Hight ?
(A) Ctrl + O + R + E
(B) Alt + O + R + E
(C) Shift + O + R + E
(D) None of these
Question 60
What is the shortcut key of Clear all ?
(A) Ctrl + E + A + A
(B) Alt + E + A
(C) Alt + E + A + A
(D) None of these
Question 61
What is the shortcut key of Remove Track arrows ?
(A) Alt + T + U + A
(B) Ctrl + T + U + A
(C) Shift + T + U + A
(D) None of these
Question 62
What is the shortcut key of Calculate the current sheet now ?
(A) Shift + F3
(B) Shift + F4
(C) Shift + F9
(D) Shift + F8
Question 63
What is the shortcut key of Paste Special ?
(A) Ctrl + Alt + V
(B) Alt + E + S
(C) Both A & B
(D) None of these
Question 64
What is the shortcut key of Paste of Format Painter ?
(A) Alt + V
(B) Ctrl + Shift + V
(C) Alt + Shift + V
(D) None of these
Question 65
What is the shortcut key of Paste Name in Formula ?
(A) F3
(B) F2
(C) F4
(D) F5
Question 66
What is the shortcut key of Show Name Manager ?
(A) Ctrl + Shift + F3
(B) Ctrl + F3
(C) Alt + F3
(D) None of these
Question 67
What is the shortcut key of Insert Name a Range ?
(A) Alt + I + D + N
(B) Alt + I + N + D
(C) Ctrl + I + D + N
(D) None of these
Question 68
What is the shortcut key of Consolidate of Data ?
(A) Ctrl + D + N
(B) Shift + D + N
(C) Alt + D + N
(D) None of these
Question 69
What is the shortcut key of Custom View ?
(A) Alt + V + A
(B) Alt + V + V
(C) Ctrl + V + V
(D) None of these
Question 70
What is the shortcut key of Goal Seek Function ?
(A) Ctrl + T + G
(B) Alt + G + T
(C) Ctrl + G + T
(D) Alt + T + G
Question 71
What is the shortcut key of Increase of Columns ?
(A) Shift + F3
(B) Ctrl + F4
(D) Shift + F4
(D) None of these
Question 72
What is the shortcut key of Decrease of Columns ?
(A) Ctrl + F4
(B) Shift + F4
(C) Ctrl + Shift + F3
(D) Ctrl + Shift + F4
Question 73
What is the shortcut key of Accept Function with auto Complete ?
(A) Shift
(B) Ctrl
(C) Tab
(D) Alt
Question 74
What is the shortcut key of Display control menu ?
(A) Ctrl + Space Bar
(B) Alt + Space Bar
(C) Ctrl + Shift + Space Bar
(D) None of these
Question 75
What is the shortcut key of Starting Posting of Letter or Formula ?
(A) End Button
(B) Page Up
(C) Home Button
(D) None of these
Question 76
What is the shortcut key of Ending Posting of Letter or Formula ?
(A) Home Button
(B) End Button
(C) Page Up
(D) None of these
Question 77
What is the shortcut key of Shift to all letter or formula ?
(A) Ctrl + Right arrow
(B) Alt + Right arrow
(C) Shift + Right Arrow
(D) None of these
Question 78
What is the shortcut key of Show and hide object ?
(A) Ctrl + 4
(B) Alt + 4
(C) Shift + 6
(D) Ctrl + 6
Question 79
What is the shortcut key of Next workbook Window ?
(A) Ctrl + F6
(B) Alt + F6
(C) Shift + F6
(D) Alt +F7
Question 80
What is the shortcut key of show of formula bar ?
(A) Ctrl + U
(B) Ctrl + Shift + U
(C) Shift + U
(D) None of these
Question 81
What is the shortcut key of Create Outside Border ?
(A) Ctrl + &
(B) Alt + &
(C) Ctrl + Shift + &
(D) None of these
Question 82
What is the shortcut key of Remove Outside Border ?
(A) Ctrl + _
(B) Ctrl + Shift + _
(C) Alt + Shift + _
(D) None of these
Question 83
What is the shortcut key of General Cell address?
(A) Shift + ~
(B) Ctrl + ~
(C) Alt + Shift + ~
(D) Ctrl + Shift + ~
Question 84
What is the shortcut key of Number cell address ?
(A) Shift + !
(B) Ctrl + Shift + !
(C) Alt + !
(D) None of these
Question 85
What is the shortcut key of currency cell address ?
(A) Ctrl + $
(B) Alt + Shift + $
(C) Ctrl + Shift + $
(D) None of these
Question 86
What is the shortcut key of Percentage cell address ?
(A) Ctrl + %
(B) Alt + %
(C) Ctrl + Shift + %
(D) None of these
Question 87
What is the shortcut key of Scientific cell address ?
(A) Ctrl + ^
(B) Ctrl + Shift + ^
(C) Alt + Shift + ^
(D) None of these
Question 88
What is the shortcut key of Insert a table format ?
(A) Alt + T
(B) Ctrl + T
(C) Shift + T
(D) None of these
Question 89
What is the shortcut key of Strike through ?
(A) Alt + 5
(B) Shift + 5
(C) Ctrl + 5
(D) None of these
Question 90
What is the shortcut key of Minimise of worksheet ?
(A) Ctrl + F9
(B) Alt + F10
(C) Ctrl + F2
(D) None of these
Question 91
What is the shortcut key of maximise of worksheet ?
(A) Alt + F10
(B) Ctrl + F10
(C) Alt + F9
(D) None of these
Question 92
What is the shortcut key of Help centre ?
(A) F2
(B) F3
(C) F1
(D) F5
Question 93
What is the shortcut key of Edit in any cell ?
(A) F3
(B) F2
(C) F5
(D) F1
Question 94
What is the shortcut key of Copy ?
(A) Ctrl + O
(B) Alt + C
(C) Ctrl + C
(D) None of these
Question 95
What is the shortcut key of Paste ?
(A) Alt + V
(B) Shift + P
(C) Ctrl + X
(D) Ctrl + V
Question 96
What is the shortcut key of Copy format in format painter ?
(A) Ctrl + V
(B) Alt + V
(C) Alt + Shift + C
(D) Ctrl + Shift + C
Question 97
What is the shortcut key of Italic of font style ?
(A) Alt + I
(B) Shift + I
(C) Ctrl + I
(D) None of these
Question 98
What is the shortcut key of Bold of font style ?
(A) Alt + B
(B) Shift + B
(C) Both B & A
(D) Ctrl + B
Question 99
What is the shortcut key of Underline of font style ?
(A) Shift + U
(B) Alt + U
(C) Ctrl + U
(D) None of these
Question 100
What is the shortcut key of Display Modify Cell Style ?
(A) Alt + "
(B) Alt + :
(C) Alt + ~
(D) Alt + '