Brainscape's Knowledge GenomeTM

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


See full index

ShortCuts > Excel > Flashcards

Excel Flashcards

1
Q

Select All

A

Ctrl+A

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

Bold

A

Ctrl+B

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

Copy

A

Ctrl+C

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

Fill Down

A

Ctrl+D

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

Find

A

Ctrl+F

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

Goto

A

Ctrl+G

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

Replace

A

Ctrl+H

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

Italic

A

Ctrl+I

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

New Workbook

A

Ctrl+N

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

Open

A

Ctrl+O

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

Print

A

Ctrl+P

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

Fill Right

A

Ctrl+R

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

Save

A

Ctrl+S

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

Underline

A

Ctrl+U

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

Paste

A

Ctrl+V

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

Cut

A

Ctrl+X

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

Repeat

A

Ctrl+Y

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

Undo

A

Ctrl+Z

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

Help

A

F1

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

Edit

A

F2

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

Paste Name

A

F3

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

Repeat last action

A

F4

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

While typing a formula, switch between absolute/relative refs

A

F4

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

Goto

A

F5

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

Next Pane

A

F6

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

Spell check

A

F7

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

Extend mode

A

F8

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

Recalculate all workbooks

A

F9

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

Activate Menubar

A

F10

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

New Chart

A

F11

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

Save As

A

F12

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

Insert Current Time

A

Ctrl+:

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

Insert Current Date

A

Ctrl+;

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

Copy Value from Cell Above

A

Ctrl+”

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

Copy Formula from Cell Above

A

Ctrl+’

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

What’s This?

A

Shift+F1

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

Edit cell comment

A

Shift+F2

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

Paste function into formula

A

Shift+F3

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

Find Next

A

Shift+F4

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

Find

A

Shift+F5

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

Previous Pane

A

Shift+F6

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

Add to selection

A

Shift+F8

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

Calculate active worksheet

A

Shift+F9

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

Display shortcut menu

A

Shift+F10

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

New worksheet

A

Shift+F11

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

Save

A

Shift+F12

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

Define name

A

Ctrl+F3

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

Close

A

Ctrl+F4

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

XL, Restore window size

A

Ctrl+F5

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

Next workbook window

A

Ctrl+F6

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

Previous workbook window

A

Shift+Ctrl+F6

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

Move window

A

Ctrl+F7

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

Resize window

A

Ctrl+F8

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

Minimize workbook

A

Ctrl+F9

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

Maximize or restore window

A

Ctrl+F10

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

Inset 4.0 Macro sheet

A

Ctrl+F11

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

File Open

A

Ctrl+F12

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

Insert Chart

A

Alt+F1

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

Save As

A

Alt+F2

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

Exit

A

Alt+F4

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

Create name by using names of row and column labels

A

Ctrl+Shift+F3

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

Previous Window

A

Ctrl+Shift+F6

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

Print

A

Ctrl+Shift+F12

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

New worksheet

A

Alt+Shift+F1

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

Save

A

Alt+Shift+F2

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

AutoSum

A

Alt+=

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

Toggle Value/Formula display

A

Ctrl+`

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

Insert argument names into formula

A

Ctrl+Shift+A

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

Format Style dialog box

A

Alt+’

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

General format

A

Ctrl+Shift+~

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

Comma format

A

Ctrl+Shift+!

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

Time format

A

Ctrl+Shift+@

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

Date format

A

Ctrl+Shift+#

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

Currency format

A

Ctrl+Shift+$

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

Percent format

A

Ctrl+Shift+%

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

Exponential format

A

Ctrl+Shift+^

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

Place outline border around selected cells

A

Ctrl+Shift+&

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

Remove outline border

A

Ctrl+Shift+_

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

Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.

A

Ctrl+Shift+*

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

Insert

A

Ctrl++

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

Delete

A

Ctrl+-

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

Format cells dialog box

A

Ctrl+1

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

Bold

A

Ctrl+2

84
Q

Italic

A

Ctrl+3

85
Q

Underline

A

Ctrl+4

86
Q

Strikethrough

A

Ctrl+5

87
Q

Show/Hide objects

A

Ctrl+6

88
Q

Show/Hide Standard toolbar

A

Ctrl+7

89
Q

Toggle Outline symbols

A

Ctrl+8

90
Q

Hide rows

A

Ctrl+9

91
Q

Hide columns

A

Ctrl+0

92
Q

Unhide rows

A

Ctrl+Shift+(

93
Q

Unhide columns

A

Ctrl+Shift+)

94
Q

Activate the menu

A

Alt or F10

95
Q

Font Drop Down List

A

Shift+Ctrl+F

96
Q

Point size Drop Down List

A

Shift+Ctrl+P

97
Q

Select the array containing the active cell.

A

CTRL+/

98
Q

Select all cells that contain comments.

A

CTRL+SHIFT+O

99
Q

In a selected row, select the cells that don’t match the formula or static value in the active cell.

A

CTRL+\

100
Q

In a selected column, select the cells that don’t match the formula or static value in the active cell.

A

CTRL+SHIFT+|

101
Q

Select all cells directly referenced by formulas in the selection.

A

CTRL+[

102
Q

Select all cells directly or indirectly referenced by formulas in the selection.

A

CTRL+SHIFT+{

103
Q

Select cells that contain formulas that directly reference the active cell.

A

CTRL+]

104
Q

Select cells that contain formulas that directly or indirectly reference the active cell.

A

CTRL+SHIFT+}

105
Q

Select the visible cells in the current selection.

A

ALT+;

106
Q

With multiple cells selected, select only the active cell.

A

SHIFT+BACKSPACE

107
Q

Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a

A

CTRL+SHIFT+SPACEBAR

108
Q

Action

A

Shortcut key

109
Q

Select All

A

Ctrl+A

110
Q

Bold

A

Ctrl+B

111
Q

Copy

A

Ctrl+C

112
Q

Fill Down

A

Ctrl+D

113
Q

Find

A

Ctrl+F

114
Q

Goto

A

Ctrl+G

115
Q

Replace

A

Ctrl+H

116
Q

Italic

A

Ctrl+I

117
Q

New Workbook

A

Ctrl+N

118
Q

Open

A

Ctrl+O

119
Q

Print

A

Ctrl+P

120
Q

Fill Right

A

Ctrl+R

121
Q

Save

A

Ctrl+S

122
Q

Underline

A

Ctrl+U

123
Q

Paste

A

Ctrl+V

124
Q

Cut

A

Ctrl+X

125
Q

Repeat

A

Ctrl+Y

126
Q

Undo

A

Ctrl+Z

127
Q

Help

A

F1

128
Q

Edit

A

F2

129
Q

Paste Name

A

F3

130
Q

Repeat last action

A

F4

131
Q

While typing a formula, switch between absolute/relative refs

A

F4

132
Q

Goto

A

F5

133
Q

Next Pane

A

F6

134
Q

Spell check

A

F7

135
Q

Extend mode

A

F8

136
Q

Recalculate all workbooks

A

F9

137
Q

Activate Menubar

A

F10

138
Q

New Chart

A

F11

139
Q

Save As

A

F12

140
Q

Insert Current Time

A

Ctrl+:

141
Q

Insert Current Date

A

Ctrl+;

142
Q

Copy Value from Cell Above

A

Ctrl+”

143
Q

Copy Formula from Cell Above

A

Ctrl+’

144
Q

What’s This?

A

Shift+F1

145
Q

Edit cell comment

A

Shift+F2

146
Q

Paste function into formula

A

Shift+F3

147
Q

Find Next

A

Shift+F4

148
Q

Find

A

Shift+F5

149
Q

Previous Pane

A

Shift+F6

150
Q

Add to selection

A

Shift+F8

151
Q

Calculate active worksheet

A

Shift+F9

152
Q

Display shortcut menu

A

Shift+F10

153
Q

New worksheet

A

Shift+F11

154
Q

Save

A

Shift+F12

155
Q

Define name

A

Ctrl+F3

156
Q

Close

A

Ctrl+F4

157
Q

XL, Restore window size

A

Ctrl+F5

158
Q

Next workbook window

A

Ctrl+F6

159
Q

Previous workbook window

A

Shift+Ctrl+F6

160
Q

Move window

A

Ctrl+F7

161
Q

Resize window

A

Ctrl+F8

162
Q

Minimize workbook

A

Ctrl+F9

163
Q

Maximize or restore window

A

Ctrl+F10

164
Q

Inset 4.0 Macro sheet

A

Ctrl+F11

165
Q

File Open

A

Ctrl+F12

166
Q

Insert Chart

A

Alt+F1

167
Q

Save As

A

Alt+F2

168
Q

Exit

A

Alt+F4

169
Q

Create name by using names of row and column labels

A

Ctrl+Shift+F3

170
Q

Previous Window

A

Ctrl+Shift+F6

171
Q

Print

A

Ctrl+Shift+F12

172
Q

New worksheet

A

Alt+Shift+F1

173
Q

Save

A

Alt+Shift+F2

174
Q

AutoSum

A

Alt+=

175
Q

Toggle Value/Formula display

A

Ctrl+`

176
Q

Insert argument names into formula

A

Ctrl+Shift+A

177
Q

Format Style dialog box

A

Alt+’

178
Q

General format

A

Ctrl+Shift+~

179
Q

Comma format

A

Ctrl+Shift+!

180
Q

Time format

A

Ctrl+Shift+@

181
Q

Date format

A

Ctrl+Shift+#

182
Q

Currency format

A

Ctrl+Shift+$

183
Q

Percent format

A

Ctrl+Shift+%

184
Q

Exponential format

A

Ctrl+Shift+^

185
Q

Place outline border around selected cells

A

Ctrl+Shift+&

186
Q

Remove outline border

A

Ctrl+Shift+_

187
Q

Select current region

A

Ctrl+Shift+*

188
Q

Insert

A

Ctrl++

189
Q

Delete

A

Ctrl+-

190
Q

Format cells dialog box

A

Ctrl+1

191
Q

Bold

A

Ctrl+2

192
Q

Italic

A

Ctrl+3

193
Q

Underline

A

Ctrl+4

194
Q

Strikethrough

A

Ctrl+5

195
Q

Show/Hide objects

A

Ctrl+6

196
Q

Show/Hide Standard toolbar

A

Ctrl+7

197
Q

Toggle Outline symbols

A

Ctrl+8

198
Q

Hide rows

A

Ctrl+9

199
Q

Hide columns

A

Ctrl+0

200
Q

Unhide rows

A

Ctrl+Shift+(

201
Q

Unhide columns

A

Ctrl+Shift+)

202
Q

Activate the menu

A

Alt or F10

203
Q

Font Drop Down List

A

Shift+Ctrl+F

204
Q

Point size Drop Down List

A

Shift+Ctrl+P

205
Q

Delete current Workbook

A

Alt+e then L

206
Q

Rename Current worksheet

A

Alt+o then h r

207
Q

Move curren worksheet

A

Alt+e then m

ShortCuts (4 decks)

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