Select Special

Question 1

Display ‘Go To’ dialog box

Answer 1

CTRL + G OR F5

Question 2

Select cells with comments

Answer 2

CTRL + SHIFT + O

Question 3

Select current region around active cell

Answer 3

CTRL + SHIFT + *

Question 4

Select current region

Answer 4

CTRL + A

Question 5

Select direct precedents

Answer 5

CTRL + [

Question 6

Select all precedents

Answer 6

CTRL + SHIFT + {

Question 7

Select direct dependents

Answer 7

CTRL + ]

Question 8

Select all dependents

Answer 8

CTRL + SHIFT + }

Question 9

Select visible cells only

Answer 9

ALT + ;