Brainscape's Knowledge GenomeTM

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


See full index

Microsoft Excel > PC Shortcuts > Flashcards

PC Shortcuts Flashcards

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

A

Ctrl+semi-colon

24
Q

Switch between displaying cell values or formulas in the worksheet

A

Ctrl+grave accent(`)

25
Q

Copy a formula from the cell above the active cell into the cell

A

Ctrl+apostrophe

26
Q

Move the selected cells

A

Ctrl+X

27
Q

Open the Paste Special dialog

A

Ctrl+Alt+V

28
Q

Apply or remove strikethrough formatting

A

Ctrl+5

29
Q

Switch between hiding objects, displaying objects, and displaying placeholders for objects

A

Ctrl+6

30
Q

Apply an outline border to the selected cells

A

Ctrl+Shift+&

31
Q

Remove the outline border from the selected cells

A

Ctrl+Shift+_

32
Q

Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below

A

Ctrl+D

33
Q

Apply the General number format

A

Ctrl+Shift+~

34
Q

Apply the Currency format with two decimal places

A

Ctrl+Shift+$

35
Q

Apply the Percentage format with no decimal places

A

Ctrl+Shift+%

36
Q

Apply the Date format with the day the month and the year

A

Ctrl+Shift+#

37
Q

Apply the Time format with the hour and minute, and AM or PM

A

Ctrl+Shift+@

38
Q

Apply the Number format with two decimal places

A

Ctrl+Shift+!

39
Q

Open the Insert hyperlink dialog

A

Ctrl+K

40
Q

Check spelling in the active worksheet or selected range

A

F7

41
Q

Display the Create Table dialog

A

Ctrl+T

42
Q

Open the Workbook Statistics dialog

A

Ctrl+Shift+G

43
Q

Expand or collapse the Formula Bar

A

Ctrl+Shift+U

44
Q

Check dependent formulas and then calculate all cells in all open workbooks

A

Ctrl+Alt+Shift+F9

45
Q

Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula

A

Ctrl+A

46
Q

Insert argument names and parentheses when the insertion point is to the right of a function name in a formula

A

Ctrl+Shift+A

47
Q

Insert the AutoSum formula

A

Alt+=

48
Q

Flash Fill

A

Ctrl+E

49
Q

Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected

A

F4

50
Q

Insert a function

A

Shift+F3

51
Q

Define a name to use in references

A

Alt+M, M, D

52
Q

Create, run, edit, or delete a macro

A

Alt+F8

53
Q

Open the Microsoft VBA Editor

A

Alt+F11

54
Q

Refresh data in the current worksheet

A

Ctrl+F5

55
Q

Refresh all data in the workbook

A

Ctrl+Alt+F5

Microsoft Excel (1 decks)

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