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 Part 2 > Flashcards

Shortcut Keys Part 2 Flashcards

1
Q

Insert Table

A

[Ctrl][T]

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

Open the Quick Analysis Tool

A

[Ctrl][Q]

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

Enter the current time

A

[Shift][Ctrl][;}

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

Copy formula from cell above

A

[Ctrl][’]

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

Fill Down

A

[Ctrl][D]

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

Fill Right

A

[Ctrl][R]

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

Flash Fill

A

[Ctrl][E]

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

Find

A

[Ctrl][F]

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

Replace

A

[Ctrl][H]

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

Delete the selected Cells / Rows / Columns

A

[Ctrl][-]

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

New workbook

A

[Ctrl][N]

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

Hide columns

A

[Ctrl][0]

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

Hide rows

A

[Ctrl][9]

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

Show and Hide objects

A

[Ctrl][6]

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

Apply comma format

A

Alt, H, K

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

Select all

A

[Ctrl][A]

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

Open Name Manager

A

[Ctrl][F3]

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

Insert new worksheet

A

[Shift][F11]

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

Switches between worksheet tabs, from left-to-right

A

[Ctrl][Page Down]

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

Switches between worksheet tabs, from right-to-left

A

[Ctrl][Page Up]

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

Moves between open windows

A

[Alt][Esc]

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

Switch between application

A

[Alt][Tab]

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

Switch between workbooks

A

[Ctrl][Tab]

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

Tab to next Cell, tool, tab stop or object

A

[Tab]

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

Tab to previous Cell, tool, tab stop or object

A

[Shift][Tab]

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

Enter and move up

A

[Shift][Enter]

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

Jumps one page down

A

[Pg Dn]

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

Jumps one page up

A

[Pg Up]

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

Move down one cell

A

[Down]

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

move left one cell / Move one character to the left

A

[Left]

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

move right one cell / moves one character to right

A

[Right]

32
Q

Move to the next worksheet in the workbook

A

[Ctrl][Pg Dn]

33
Q

Move to the previous worksheet in the workbook

A

[Ctrl][Pg Up]

34
Q

Moves left to the next blank cell

A

[Shift][Ctrl][F4]

35
Q

Moves one screen to the left in a worksheet

A

[Alt][Pg Up]

36
Q

Moves one screen to the right in a worksheet.

A

[Alt][Pg Dn]

37
Q

moves right to the next blank cell

A

[Shift][F4]

38
Q

Moves to the bottom of the active area

A

[Ctrl][End]

39
Q

Moves to the bottom of the region or next region

A

[Ctrl][Down]

40
Q

Moves to the front of the row

A

[Home]

41
Q

Moves to the left of the region or next region

A

[Ctrl][Left]

42
Q

Moves to the right of the region or next region

A

[Ctrl][Right]

43
Q

Moves to the top of the current region or next region

A

[Ctrl][Up]

44
Q

Moves to the top of the spreadsheet

A

[Ctrl][Home]

45
Q

Puts excel in end mode (same as ctr arrow)

A

[End]

46
Q

Hide ribbons

A

[Ctrl][F1]

47
Q

Open a Menu or list

A

[Alt][Down]

48
Q

Select the menu bar

A

[F10]

49
Q

Add to selection

A

[Shift][F8]

50
Q

Extended Selection Mode

A

[F8]

51
Q

Select cells to the next page

A

[Shift][Pg Dn]

52
Q

Select cells to the previous page

A

[Shift][Pg Up]

53
Q

Select cells while moving down

A

[Shift][Down]

54
Q

Select cells while moving left

A

[Shift][Left]

55
Q

Select cells while moving right

A

[Shift][Right]

56
Q

Select cells while moving up

A

[Shift][Up]

57
Q

Select in end mode

A

[Shift][End]

58
Q

Select the active column

A

[Shift][Space]

59
Q

Select the cells to the beginning of the row

A

[Shift][Home]

60
Q

Select the current and next sheet in a workbook.

A

[Shift][Ctrl][Pg Dn]

61
Q

Select the current and previous sheet in a workbook.

A

[Shift][Crtl][Pg Up]

62
Q

Select the current column

A

[Ctrl][Space]

63
Q

Select the current region

A

[Shift][Ctrl][8]

64
Q

Select to the bottom of the region or next region

A

[Shift][Ctrl][Down]

65
Q

Select to the left of the region or next region

A

[Shift][Ctrl][Left]

66
Q

Select to the right of the region or next region

A

[Shift][Ctrl][Right]

67
Q

Select to the top of the current region or next region

A

[Shift][Ctrl][Up]

68
Q

Expands and collapse the formula bar

A

[Shift][Ctrl][U]

69
Q

Hide ribbons, tabs and status bar

A

[Shift][Ctrl][F1]

70
Q

Opens the selection pane

A

[Alt][F10]

71
Q

Previous pane or Area

A

[Shift][F6]

72
Q

Open Thesaurus

A

[Shift][F7]

73
Q

Spell Check

A

[F7]

74
Q

Minimize / Maximize Window

A

[Ctrl][F10]

75
Q

Minimize workbook

A

[Ctrl][F9]

76
Q

Next Workbook Window

A

[Ctrl][F6]

Excel for Financial Professionals (3 decks)

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