Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

rtws > excel + NPV/IRR > Flashcards

excel + NPV/IRR Flashcards

1
Q

Alt

A

Opens up menu toolbar (top), shows letters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Ctrl + Home

A

Home saving - ensures every sheet saved

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Saving

A

SAVE NEW every 15 mins - do NOT autosave

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Reiterate/recalculate model

A

F9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Erase a cell

A

Hit DELETE , never hit SPACEBAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Merging

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Navigate between tabs

A

Ctrl pgup, ctrl pgdown

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Navigate between workbooks

A

Ctrl tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Open/close workbook

A

Open: Ctrl N
Close: Alt F C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Highlight cells

A

SHIFT (hold) + arrows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Highlight entire row

A

Shift (hold) + SPACEBAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Highlight entire column

A

CTRL (hold) + SPACEBAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

“Go to” a cell

A

CTRL (hold) + G

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Check links

A

CTRL (hold) [

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Ctrl C vs. Ctrl X

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Fill right/fill down

A

Ctrl R + Ctrl D

17
Q

Paste formula

A

Alt, E S F

18
Q

Paste formatting

A

Alt, E S T

19
Q

Paste value

A

Alt, E S V

20
Q

Paste link

A

Alt, E S L

21
Q

Insert worksheet

A

Alt i W

22
Q

Edit/delete worksheet

A

Alt E L

23
Q

Window freeze panes

A

Alt W F F

24
Q

Group/ungroup data

A

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

25
Q

Format column width/autofit column width

A

Width: Alt OCW
Autofit: Alt OCA

26
Q

Format row height/autofit row height

A

Height: Alt ORE
Autofit: Alt ORA

27
Q

Insert row/insert column

A

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

28
Q

Conditional formatting (create new rule)

A

Alt H L N

29
Q

Enter edit mode/activate cell

A

F2

30
Q

Lock cells

A

F4

31
Q
A

rtws (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions