MS Excel Shortcut Keys

Total Questions: 26

1 - What is the shortcut key to quickly insert a new workbook in Excel?

A ) Control
B ) Shift+Enter
C ) Alt+Enter ✅
D ) Shift+A

2 - If you press the ------- cell accepts your typing as its content.

A ) Ctrl+Enter
B ) Tab
C ) Alt+Enter
D ) Space ✅

3 - New line small cell shortcut key in Excel?

A ) Ctrl+Enter
B ) Alt+Enter ✅
C ) Alt+shift
D ) Shift+Enter

4 - Which is an example of formula?

A ) SUM(A1:A2)
B ) =A1+A2 ✅
C ) Add(A1:A2)
D ) A1+A2

5 - Which key is used to copy the formula from above cell?

A ) Ctrl+:
B ) Ctrl+' ✅
C ) Ctrl+D
D ) Ctrl+;

6 - Which key is used to copy the formula result from above cell?

A ) Ctrl+:
B ) Ctrl+D ✅
C ) Ctrl+;
D ) Ctrl+'

8 - Which is used for rename?

A ) F1
B ) F2 ✅
C ) F7
D ) F9

9 - Which is used to minimize Excel Worksheet?

A ) Ctrl+F5
B ) Ctrl+F7
C ) Ctrl+F9 ✅
D ) Ctrl+F11

10 - Shift+F11 is used to minimize Excel Worksheet?

A ) Ctrl+F5
B ) Ctrl+F7
C ) Ctrl+F9 ✅
D ) Ctrl+F11

11 - Shift+F11 is used to add new ------ in excel

A ) Sheet ✅
B ) Row
C ) Column
D ) Cell

13 - In MS Excel a comment is inserted by using the ------ command.

A ) Shift+F2 ✅
B ) Alt+F2
C ) Ctrl+F2
D ) Ctrl+V

14 - How do you display current date and time in MS Excel?

A ) Date ()
B ) Year()
C ) Now () ✅
D ) Time ()

15 - In Excel the function "Today ()" is used to display.

A ) The current year
B ) The current date ✅
C ) The current time
D ) The current weather

16 - Which of these keys are used in MS Excel to insert the current time in workbook?

A ) Ctrl+
B ) Ctrl+1
C ) Ctrl+shift
D ) None of these (CTRL shift+;) ✅

17 - Which shortcut key highlights an entire column in Excel?

A ) CTRL+A
B ) CTRL+C
C ) CTRL+space ✅
D ) None of these

18 - Which of the following is not a valid data type in Excel?

A ) Label
B ) Character ✅
C ) Number
D ) Date/time

19 - Which type of data you can enter in worksheet cell?

A ) Label, value, not formula
B ) Label, value, formula ✅
C ) Formula, label, value
D ) Only formula

20 - To move to the previous cell in a table inserted in a document press:

A ) Ctrl+Tab
B ) Shift+Tab ✅
C ) Alt+Tab
D ) Backspace

21 - To move to the next cell in a table inserted in a document press:

A ) Ctrl+Tab
B ) Shift+Tab
C ) Tab ✅
D ) Backspace

22 - Shortcut to switch to the next worksheet tab in excel is:

A ) Ctrl+Home
B ) Ctrl+PG up
C ) Ctrl+PG down ✅
D ) SHIFT+RIGHT ARROW

24 - You can edit existing Excel data by pressing the------key.

A ) F1 key
B ) F2 key ✅
C ) F3 key
D ) None of these

25 - What is the shortcut key for clearing all formatting of selected text in MS Word?

A ) Ctrl + Enter
B ) Ctrl+Spacebar ✅
C ) Ctrl+Del
D ) Shift+F3