Unique Computer Education-Ronak Gupta

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 + '