MS Excel Shortcut Keys Question Answers MCQs Test

 If you want to learn online Objective type Microsoft Excel Shortcut Keys and Question Answers for Entry Tests and Competitive Exams Preparations you are here on right page. All of here solved MCQs are important for preparations of MS Excel Multiple choice Quiz Test for PPSC, NTS, FPSC, KPPSC, BPSC, SPSC, computer operator job tests, Data Entry Job tests and other IT jobs tests preparations. MS Excel Question Answers for Preparations of Computer Interview and Viva Online here.

MS Excel Past Papers Competitive Exams MCQs With Answers

Q.1: Which shortcut key is used to remove all borders?

1. Shift + _ (Underline)
2. Shift + F1
3. Ctrl +Right Arrow key
4. Ctrl + Shift + _ (Underline)

D

Q.2: In MS-Excel 2019 which shortcut key is used to insert a hard return?

1. Shift+Enter
2. Ctrl+E
3. Alt+Enter
4. Ctrl+Enter

C

Q.3: Which key is used for strikethrough selection?

1. Ctrl + 5
2. Ctrl + Right Arrow key
3. Shift + F2
4. Ctrl + F5

A

Q.4: Which shortcut key is used to apply outline borders?

1. Ctrl + Shift + 7
2. Shift + F1
3. Ctrl +Right Arrow key
4. Shift + 7

A

Q.5: Which shortcut key is used to add new worksheet?

1. Shift + F1
2. Ctrl + Shift
3. Shift + F11
4. Ctrl +Right Arrow key

C

Q.6: Which shortcut key is used to change the font size?

1. Shift + F1
2. Shift + P
3. Ctrl + Shift + P
4. Ctrl +Right Arrow key

C

Q.7: In Excel which shortcut key is used to hide the selected columns?

1. Ctrl+0
2. Ctrl+1
3. Alt+0
4. Ctrl+A

A

Q.8: In MS-Excel which shortcut key is used to move at the beginning of the worksheet?

1. Ctrl+H
2. Ctrl+Shift
3. Alt+Home
4. Ctrl+Home

C

Q.9: Which shortcut key is used to open format cells dialog box in MS Excel 2019?

1. Ctrl+0
2. Ctrl+1
3. Ctrl+A
4. Alt+0

B

Q.10: Which key is used to select the entire row?

1. Ctrl +Right Arrow key
2. Ctrl + Shift
3. Shift + Spacebar
4. Ctrl + Spacebar

C

Q.11: Which shortcut key is used to format number in time format?

1. Shift + @
2. Ctrl + Shift + @
3. Shift + F1
4. Ctrl +Right Arrow key

B

Q.12: Which shortcut key is used format number in date format?

1. Shift + #
2. Ctrl + Shift + #
3. Ctrl +Right Arrow key
4. Shift + F1

B

Q.13: Which shortcut key is used to edit a comment?

1. Ctrl +Right Arrow key
2. Shift + F1
3. Shift + F2
4. Ctrl + Shift

C

Q.14: Which key is used to delete one character from the right?

1. Delete
2. End
3. Erase
4. Ctrl+Shift

A

Q.15: Which key is used to insert rows or columns?

1. Shift + Spacebar
2. Ctrl +Right Arrow key
3. Ctrl + Shift
4. Ctrl + Shift +

D

Q.16: Which key is used to select the entire column?

1. Spacebar
2. Ctrl + Shift
3. Ctrl +Right Arrow key
4. Ctrl + Spacebar

D

Q.17: Which shortcut key is for auto sum?

1. Alt + =
2. Ctrl + Shift
3. Alt + F1
4. Ctrl + =

A

Q.18: In Excel which shortcut key is used to hide the selected rows?

1. Alt+9
2. Ctrl+9
3. Ctrl+A
4. Ctrl+J

B

Q.19: Shortcut key to change the font in MS Excel is?

1. Shift + F
2. Ctrl +Right Arrow key
3. Ctrl + Shift + F
4. Shift + F1

C

Q.20: Which shortcut key is used to format number in currency format?

1. Ctrl +Right Arrow key
2. Ctrl + Shift + $
3. Shift + F1
4. Shift + $/li>

B

Q.21: Which shortcut key is used to insert new worksheet?

1. Ctrl+Shift+F3
2. Ctrl+Shift+F6
3. Ctrl+Shift+F9
4. Alt+Shift+F1

D

Q.22: Which key is used to open help window?

1. F1
2. F4
3. F2
4. F3

A

Q.23: Which key is used to go to a specific cell?

1. F2
2. F1
3. F5
4. F3

C

Q.24: Which key is used to insert the current time?

1. Shift+F7
2. Shift+Alt+D
3. Ctrl+Shift+;
4. Shift+F12

C

Q.25: Which key is used to create chart in MS Excel?

1. Shift+F4
2. F11
3. Shift+End
4. F12

B

Q.26: In MS-Excel 2019 which shortcut key is used to insert a function?

1. Ctrl+F
2. Shift+F3
3. Ctrl+F3
4. Shift+F

B

Q.27: Which key is used to insert the current date?

1. Shift+F7
2. Shift+Alt+T
3. Shift+F12
4. Ctrl+;

D

Q.28: Which key is used to paste the selected text from cell?

1. Ctrl+V
2. Shift+F7
3. Shift+F12
4. Shift+End

A

Q.29: Ctrl + --------is used to underline the selected text?

1. Z
2. Y
3. X
4. U

D

Q.30: Which key is used to check spelling and grammar?

1. F3
2. F7
3. F5
4. F2

B

Q.31: In Excel which shortcut key is used to go to the data tab?

1. Ctrl+S
2. Ctrl+A
3. Ctrl+B
4. Alt+A

D

Q.32: Which key is used to open the view tab in MS Excel 2019?

1. Ctrl+W
2. Ctrl+A
3. Ctrl+C
4. Alt+W

D

Q.33: Which key is used to save as the document?

1. F5
2. F11
3. F3
4. F12

D

Q.34: Ctrl + --------is used to undo the last action?

1. X
2. Y
3. Q
4. Z

D

Q.35: In Microsoft Excel 2019 which key is used to open the review tab?

1. Ctrl+R
2. Alt+R
3. Ctrl+T
4. Ctrl+W

B

Q.36: Which key is used to run the Thesaurus on selected word?

1. Shift+End
2. Shift+F7
3. Shift+Insert
4. Shift+F12

B

Q.37: In MS-Excel which shortcut key is used to open the macro dialog box?

1. Ctrl+F8
2. Alt+F8
3. Ctrl+F
4. Alt+F

B

Q.38: Which key is used to edit the highlighted cell?

1. F6
2. F3
3. F2
4. F9

C

Q.39: Ctrl + ------- is used to redo the last action?

1. Y
2. B
3. C
4. A

A

Q.40: Ctrl + ------- is used to close the currently opened document?

1. P
2. A
3. O
4. W/li>

D

Q.41: Which key is used with CTRL to paste the copied text?

1. T
2. B
3. V
4. B

C

Q.42: Which key is used with CTRL to select all content of a worksheet?

1. A
2. C
3. X
4. V

A

Q.43: Ctrl + ------- is used to open the print window?

1. B
2. A
3. P
4. D

C

Q.44: In MS-Excel 2019 which shortcut key is used to open the insert tab?

1. Alt+I
2. Alt+B
3. Ctrl+N
4. Alt+N

D

Q.45: In Excel which shortcut key is used to go to the formulas tab?

1. Alt+M
2. Ctrl+M
3. Ctrl+C
4. Ctrl+B

A

Q.46: Which key is used with CTRL to open a new workbook in MS Excel?

1. N
2. L
3. J
4. A

A

Q.47: Which key is used with CTRL to find and replace text?

1. G
2. J
3. H
4. A

C

Q.48: In MS-Excel which shortcut key is used to open the page layout tab?

1. Alt+P
2. Alt+T
3. Ctrl+P
4. Ctrl+S

A

Q.49: Which key is used with CTRL to bold the highlighted cells?

1. A
2. D
3. B
4. C

C

Q.50: Which key is used with CTRL to cut selected text?

1. A
2. H
3. X
4. G

C

Q.51: Which key applies italic effect on highlighted cells?

1. Ctrl+I
2. Ctrl+A
3. Ctrl+X
4. Ctrl+C

A

Q.52: Which key is used with CTRL to search the current sheet?

1. A
2. C
3. B
4. F

D

Q.53: In Microsoft Excel 2019 which key is used to open the file tab menu?

1. Ctrl+F
2. Ctrl+D
3. Alt+F
4. Ctrl+B

C

Q.54: Which key is used with CTRL to save the opened workbook?

1. S
2. A
3. G
4. D

A

Q.55: Which key is used with CTRL to fill down the beneath cells with the content of the selected cells?

1. A
2. B
3. C
4. D

D

Q.56: Which key is used with CTRL to insert a hyperlink?

1. K
2. H
3. D
4. F

A

Q.57: Ctrl + --------is used to open a file from the directory?

1. A
2. V
3. X
4. O

D

Q.58: Which key is used to open the home tab in MS Excel 2019?

1. Ctrl+H
2. Ctrl+A
3. Ctrl+B
4. Alt+H

D

Q.59: Which key is used with CTRL to display the go to dialog box?

1. B
2. G
3. C
4. X

B

Q.60: Which key is used with CTRL to copy selected cells?

1. D
2. A
3. C
4. B

C