Grid

Question 1

group selected rows/columns OR display “group” dialog box

Answer 1

Alt + A + G + G

Question 2

hide grouped rows/columns

Answer 2

Alt + A + H

Question 3

show grouped rows/columns

Answer 3

Alt + A + J

Question 4

ungroup selected rows/columns OR display “ungroup” dialog box

Answer 4

Alt + A + U + U

Question 5

merge and center cells

Answer 5

Alt + H + M + C

Question 6

wrap text

Answer 6

Alt + H + W

Question 7

delete selected rows/columns OR display the “delete” dialog box

Answer 7

Ctrl + -

Question 8

delete worksheet rows

Answer 8

Alt + H + D + R

Question 9

delete worksheet columns

Answer 9

Alt + H + D + C

Question 10

delete table rows

Answer 10

Alt + H + D + L

Question 11

delete table columns

Answer 11

Alt + H + D + M

Question 12

display the “row height” dialog box

Answer 12

Alt + H + O + H

Question 13

autofit row height

Answer 13

Alt + H + O + A

Question 14

display the “column width” dialog box

Answer 14

Alt + H + O + W

Question 15

autofit column width

Answer 15

Alt + H + O + I

Question 16

display the “standard width” dialog box to change the default column width

Answer 16

Alt + H + O + D

Question 17

lock active cells

Answer 17

Alt + H + O + L

Question 18

hide active columns

Answer 18

Ctrl + 0

Question 19

alternate between hiding/displaying outline symbols for grouped rows/columns

Answer 19

Ctrl + 8

Question 20

hide active rows

Answer 20

Ctrl + 9

Question 21

insert rows/columns above/to the left of the selected row/column OR display the “insert” dialog box

Answer 21

Ctrl + Shift + +

Question 22

insert table rows above the active cell

Answer 22

Alt + H + I + A

Question 23

insert table columns to the left of the active cell

Answer 23

Alt + H + I + L

Question 24

insert worksheet rows above the active cell

Answer 24

Alt + H + I + R

Question 25

insert worksheet columns to the left of the active cell

Answer 25

Alt + H + I + C

Question 26

unhide any hidden columns within selection

Answer 26

Ctrl + Shift + 0

Question 27

unhide any hidden rows within selection

Answer 27

Ctrl + Shift + 9