Workbooks and Worksheets

Question 1

delete current active sheet/worksheet

Answer 1

Alt + H + D + S

Question 2

display the “move or copy sheet” dialog box

Answer 2

Alt + H + O + M

Question 3

display the “protect sheet” dialog box

Answer 3

Alt + H + O + P

Question 4

rename current active sheet/worksheet

Answer 4

Alt + H + O + R

Question 5

expand the “tab color” drop-down menu

Answer 5

Alt + H + O + T

Question 6

set current worksheet tab to have no color

Answer 6

Alt + H + O + T + N

Question 7

display the “unhide” dialog box to unhide a sheet/worksheet

Answer 7

Alt + H + O + U + H

Question 8

hide current active sheet/worksheet

Answer 8

Alt + H + O + U + S

Question 9

insert new worksheet

Answer 9

Alt + Shift + F1

Question 10

new macro sheet

Answer 10

Ctrl + F11

Question 11

display the “open” dialog box

Answer 11

Ctrl + F12

Question 12

close current selected workbook window

Answer 12

Ctrl + F4

Question 13

apply “move” command to active workbook window when not maximized

Answer 13

Ctrl + F7

Question 14

apply “resize” command to active workbook window when not maximized

Answer 14

Ctrl + F8

Question 15

minimize current selected workbook window

Answer 15

Ctrl + F9

Question 16

create a new blank workbook

Answer 16

Ctrl + N

Question 17

display “open” tab of backstage view to open a workbook

Answer 17

Ctrl + O

Question 18

save active file using current file name and format and in current file location

Answer 18

Ctrl + S

Question 19

close the selected workbook

Answer 19

Ctrl + W

Question 20

display the “save as” dialog box

Answer 20

F12

Question 21

insert a new worksheet in the current workbook

Answer 21

Shift + F11