Editing / Formulas

Question 1

Inserts a new Worksheet

Answer 1

Shift + F11

Question 2

Inserts new cell(s) / row(s) / column(s)

Answer 2

Ctrl + Shift + Plus

Question 3

Deletes cell(s) / row(s) / column(s)

Answer 3

Ctrl + Minus

Question 4

Fill cells ‘Down’ in a Column

Answer 4

Ctrl + D

Question 5

Fill cells ‘Right’ in a Row

Answer 5

Ctrl + R

Question 6

‘Format Cell’ dialogue box (Use Tab, Space to navigate inside the box)

Answer 6

Ctrl + 1

Question 7

Activates Cell Edit mode, allows to walk inside the cell

Answer 7

F2

Question 8

Inserts a Row Above

Answer 8

Alt&raquo_space; I&raquo_space; R

Question 9

Inserts a Column to the Left

Answer 9

Alt&raquo_space; I&raquo_space; C

Question 10

‘Paste Special’ dialogue box

Answer 10

Alt&raquo_space; E&raquo_space; S

Question 11

‘Find / Replace’ dialogue box

Answer 11

Alt&raquo_space; E&raquo_space; F

Question 12

‘Conditional Formatting’ dialogue box

Answer 12

Alt&raquo_space; O&raquo_space; D

Question 13

Calculate all worksheets

Answer 13

F9

Question 14

Toggle between Absolute / Mixed / Relative Cell Referencing (Four times Sequential Key Presses)

Answer 14

F4

Question 15

Auto Sum

Answer 15

Alt + =

Question 16

Enters current date in cell

Answer 16

Ctrl + ;

Question 17

Flash Fill

Answer 17

Ctrl + E

Question 18

Transpose

Answer 18

Alt&raquo_space; E&raquo_space; S&raquo_space; E

Question 19

Display Formula Window after typing formula name

Answer 19

Ctrl + a