Brainscape's Knowledge GenomeTM

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


See full index

Excel for Financial Professionals > Shortcut Keys > Flashcards

Shortcut Keys Flashcards

1
Q

Calculate

A

[F9]

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

Calculate Sheet

A

[Shift][F9]

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

Enter Current Date

A

[Ctrl][;]

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

Enter a space / Select item or checkbox

A

[Space]

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

Redo/Repeat

A

[Ctrl][Y]

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

Undo

A

[Ctrl][Z]

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

Copies formula into selected cells

A

[Ctrl][Enter]

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

Copy

A

[Ctrl][C]

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

Cut

A

[Ctrl][X]

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

Paste

A

[Ctrl][V]

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

Paste Values

A

[Ctrl][Alt][V]

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

Enter a new line in the cell

A

[Alt][Enter]

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

Repeat last Action / toggle through Absolute and relative reference

A

[F4]

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

Toggles Edit / Enter Mode

A

[F2]

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

Close

A

[Ctrl][F4]

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

Save

A

[Ctrl][S]

17
Q

Save as

A

[F12]

18
Q

Print

A

[Ctrl][P]

19
Q

Opens the format dialog box

A

[Ctrl][1]

20
Q

Wrap Text

A

[Shift][Ctrl][W]

21
Q

Bold

A

[Ctrl][B]

22
Q

Italics

A

[Ctrl][I]

23
Q

Underline

A

[Ctrl][U]

24
Q

Increase decimals

A

[Ctrl][,]

25
Q

Auto Sum

A

[Alt][=]

26
Q

Paste name

A

[F3]

27
Q

Open the context menu

A

[Shift][F10]

28
Q

Open Goto dialog box

A

[F5]

29
Q

Move up one cell or item

A

[up]

30
Q

Select visible cells

A

[Alt][;]

31
Q

Next pane or area

A

[F6]

32
Q

Enter a formula into a cell or moves to the next cell

A

[Enter]

33
Q

Escape out of edit mode etc.

A

[Esc]

34
Q

Help

A

[F1]

35
Q

Delete cell content

A

[DEL]

Excel for Financial Professionals (2 decks)

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