Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Microsoft Excel > PC Shortcuts > Flashcards

PC Shortcuts Flashcards

(55 cards)

Start Studying
1
Q

Open a workbook

A

Ctrl+O

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

Go to the Home tab

A

Alt+H

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

Choose a fill color

A

Alt+H, H

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

Go to Insert tab

A

Alt+N

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

Center align cell contents

A

Alt+H, A, C

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

Go to Page Layout tab

A

Alt+P

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

Go to Data tab

A

Alt+A

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

Go to View tab

A

Alt+W

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

Open context menu

A

Shift+F10

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

Add borders

A

Alt+H, B

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

Delete column

A

Alt+H, D, C

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

Go to Formula tab

A

Alt+M

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

Hide the selected rows

A

Ctrl+9

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

Hide the selected columns

A

Ctrl+0

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

Move to the previous cell in a worksheet or the previous option in a dialog

A

Shift+Tab

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

Move to the next sheet in a workbook

A

Ctrl+Page Down

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

Open the list of validation choices on a cell that has data validation option applied to it

A

Alt+Down arrow key

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

Open the Format Cells dialog

A

Ctrl+1

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

Format fonts in the Format Cells dialog

A

Ctrl+Shift+F

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

Insert a note

A

Shift+F2

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

Insert a threaded comment

A

Ctrl+Shift+F2

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

Enter the current time

A

Ctrl+Shift+colon

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

Enter the current date

Study These Flashcards
A

Ctrl+semi-colon

24
Q

Switch between displaying cell values or formulas in the worksheet

Study These Flashcards
A

Ctrl+grave accent(`)

25
Copy a formula from the cell above the active cell into the cell
Ctrl+apostrophe
26
Move the selected cells
Ctrl+X
27
Open the Paste Special dialog
Ctrl+Alt+V
28
Apply or remove strikethrough formatting
Ctrl+5
29
Switch between hiding objects, displaying objects, and displaying placeholders for objects
Ctrl+6
30
Apply an outline border to the selected cells
Ctrl+Shift+&
31
Remove the outline border from the selected cells
Ctrl+Shift+_
32
Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl+D
33
Apply the General number format
Ctrl+Shift+~
34
Apply the Currency format with two decimal places
Ctrl+Shift+$
35
Apply the Percentage format with no decimal places
Ctrl+Shift+%
36
Apply the Date format with the day the month and the year
Ctrl+Shift+#
37
Apply the Time format with the hour and minute, and AM or PM
Ctrl+Shift+@
38
Apply the Number format with two decimal places
Ctrl+Shift+!
39
Open the Insert hyperlink dialog
Ctrl+K
40
Check spelling in the active worksheet or selected range
F7
41
Display the Create Table dialog
Ctrl+T
42
Open the Workbook Statistics dialog
Ctrl+Shift+G
43
Expand or collapse the Formula Bar
Ctrl+Shift+U
44
Check dependent formulas and then calculate all cells in all open workbooks
Ctrl+Alt+Shift+F9
45
Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula
Ctrl+A
46
Insert argument names and parentheses when the insertion point is to the right of a function name in a formula
Ctrl+Shift+A
47
Insert the AutoSum formula
Alt+=
48
Flash Fill
Ctrl+E
49
Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected
F4
50
Insert a function
Shift+F3
51
Define a name to use in references
Alt+M, M, D
52
Create, run, edit, or delete a macro
Alt+F8
53
Open the Microsoft VBA Editor
Alt+F11
54
Refresh data in the current worksheet
Ctrl+F5
55
Refresh all data in the workbook
Ctrl+Alt+F5

Microsoft Excel (1 decks)

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