excel + NPV/IRR

Question 1

Alt

Answer 1

Opens up menu toolbar (top), shows letters

Question 2

Ctrl + Home

Answer 2

Home saving - ensures every sheet saved

Question 3

Saving

Answer 3

SAVE NEW every 15 mins - do NOT autosave

Question 4

Reiterate/recalculate model

Answer 4

F9

Question 5

Erase a cell

Answer 5

Hit DELETE , never hit SPACEBAR

Question 6

Merging

Answer 6

DO NOT merge cells, use merge across selection instead (Ctrl + 1)

Question 7

Navigate between tabs

Answer 7

Ctrl pgup, ctrl pgdown

Question 8

Navigate between workbooks

Answer 8

Ctrl tab

Question 9

Open/close workbook

Answer 9

Open: Ctrl N
Close: Alt F C

Question 10

Highlight cells

Answer 10

SHIFT (hold) + arrows

Question 11

Highlight entire row

Answer 11

Shift (hold) + SPACEBAR

Question 12

Highlight entire column

Answer 12

CTRL (hold) + SPACEBAR

Question 13

“Go to” a cell

Answer 13

CTRL (hold) + G

Question 14

Check links

Answer 14

CTRL (hold) [

Question 15

Ctrl C vs. Ctrl X

Answer 15

Ctrl C: copies existing cells and pastes a duplicate of these copied cells. LEAVES original cells.

Ctrl X: removes a group of cells and places them in another area of the worksheet.

Question 16

Fill right/fill down

Answer 16

Ctrl R + Ctrl D

Question 17

Paste formula

Answer 17

Alt, E S F

Question 18

Paste formatting

Answer 18

Alt, E S T

Question 19

Paste value

Answer 19

Alt, E S V

Question 20

Paste link

Answer 20

Alt, E S L

Question 21

Insert worksheet

Answer 21

Alt i W

Question 22

Edit/delete worksheet

Answer 22

Alt E L

Question 23

Window freeze panes

Answer 23

Alt W F F

Question 24

Group/ungroup data

Answer 24

HIGHLIGHT DATA FIRST
Group: Alt D G G
Ungroup: Alt D G U

Question 25

Format column width/autofit column width

Answer 25

Width: Alt OCW Autofit: Alt OCA

Question 26

Format row height/autofit row height

Answer 26

Height: Alt ORE Autofit: Alt ORA

Question 27

Insert row/insert column

Answer 27

Insert row: Alt i R Insert column: Alt i C

Question 28

Conditional formatting (create new rule)

Answer 28

Alt H L N

Question 29

Enter edit mode/activate cell

Answer 29

F2

Question 30

Lock cells

Answer 30

F4