Excel

Question 1

Pasting down and pasting right

Answer 1

Ctrl + D
Ctrl + R

Question 2

Sum shortcut

Answer 2

Alt=

Question 3

Special paste

Answer 3

Ctrl+Alt+V

Question 4

Select row

Answer 4

Shift+Space

Question 5

Selecting column

Answer 5

Ctrl+Space

Question 6

Font Options

Answer 6

Alt H F

Question 7

Quickly moving entire row or column

Answer 7

Shift+Ctrl to select, then Ctrl+X and Ctrl+V to put it back

Question 8

Select whole table

Answer 8

Go to corner and press Ctrl+A, then Ctrl+X

Question 9

Adjusting column and row width

Answer 9

Alt HOI

Question 10

Selecting block of cells

Answer 10

Shift+Ctrl then Up or Down to select block of column or row

Question 11

Identifying Hard coded cells vs Formula cells

Answer 11

F5, Alt+S, O, X
This highlights all hard-coded numbers

Alt+H+J
to open style menu, then can select a coloured style to highlight them

Question 12

Editing a cell shortcut

Answer 12

Function+F2

Question 13

Open style menu shortcut

Answer 13

Alt H J

Question 14

How to split window
(Allows you to see two parts of the same sheet at the same time)

Answer 14

Alt W S

Question 15

How to lock onto a cell when copying right

Answer 15

F4

$$

Question 16

Undo

Answer 16

Ctrl Z

Question 17

Go to where cell reference is from and how to go back afterwards

Answer 17

Ctrl [
F5+Enter to go back

Question 18

CapIQ cheatsheet

Answer 18

In FE Training folder

Question 19

$ shortcut

Answer 19

F4