Keyboard Shortcuts

Question 1

Expand or Collapse Ribbon

Answer 1

Ctrl + F1

Question 2

Go to Search Bar

Answer 2

Alt + Q

Question 3

Open File Menu

Answer 3

Alt + F

Question 4

Go to Home Tab

Answer 4

Alt + H

Question 5

Go to Insert Tab

Answer 5

Alt + N

Question 6

Go to Page Layout Tab

Answer 6

Alt + P

Question 7

Go to Formula Tab

Answer 7

Alt + M

Question 8

Go to Data Tab

Answer 8

Alt + A

Question 9

Go to Review Tab

Answer 9

Alt + R

Question 10

Go to View Tab

Answer 10

Alt + W

Question 11

Go to Help Tab

Answer 11

Alt + Y1

Question 12

Open “Format Cells” Dialog Box

Answer 12

Ctrl + 1

Question 13

Apply/Unapply Bold

Answer 13

Ctrl + B

Question 14

Apply/Unapply Italics

Answer 14

Ctrl + I

Question 15

Apply/Unapply Underline

Answer 15

Ctrl + U

Question 16

Apply/Unapply Strikethrough

Answer 16

Ctrl + 5

Question 17

Apply Currency Format

Answer 17

Ctrl + Shift + $

Question 18

Apply Percentage Format

Answer 18

Ctrl + Shift + %

Question 19

Apply Date Format

Answer 19

Ctrl + Shift + #

Question 20

Apply Time Format

Answer 20

Ctrl + Shift + @

Question 21

Apply Number Format

Answer 21

Ctrl + Shift + !

Question 22

Apply General Format

Answer 22

Ctrl + Shift + ~

Question 23

Center Align Cell Contents

Answer 23

Alt + H + A + C

Question 24

Left Align Cell Contents

Answer 24

Alt + H + A + L

Question 25

Right Align Cell Contents

Answer 25

Alt + H + A + R

Question 26

Autosum All Selected Cells

Answer 26

Alt + =

Question 27

Add Function Arguments

Answer 27

Ctrl + Shift + A

Question 28

Toggle Formula Bar

Answer 28

Ctrl + Shift + :

Question 29

Toggle Cell Formulas and Values

Answer 29

Ctrl + `

Question 30

Copy Selected Cells

Answer 30

Ctrl + C

Question 31

Paste Clipboard Contents

Answer 31

Ctrl + V

Question 32

Display “Paste Special”

Answer 32

Ctrl + Alt + V

Question 33

Cut Selection

Answer 33

Ctrl + X

Question 34

Undo Previous Action

Answer 34

Ctrl + Z

Question 35

Redo Previous Action

Answer 35

Ctrl + Y

Question 36

Display Find Dialog

Answer 36

Ctrl + F

Question 37

Display Replace Dialog

Answer 37

Ctrl + H

Question 38

Display Go To Dialog

Answer 38

Ctrl + G

Question 39

Insert or Edit Comment

Answer 39

Shift + F2

Question 40

Insert New Line in Cell

Answer 40

Alt + Enter

Question 41

Edit Contents of Active Cell

Answer 41

F2

Question 42

Enter the Same Data in Multiple Cells

Answer 42

Ctrl + Enter

Question 43

Insert Current Date Into Cell

Answer 43

Ctrl + ;

Question 44

Insert Current Time Into Cell

Answer 44

Ctrl + Shift + :

Question 45

Open Context Menu

Answer 45

Shift + F10

Question 46

Copy a Formula From Cell Above to Cell

Answer 46

Ctrl + ‘

Question 47

Open Insert Hyperlink Dialog Box

Answer 47

Ctrl + K

Question 48

Open Validation List on a Cell

Answer 48

Alt + Down Arrow

Question 49

Open a Workbook

Answer 49

Ctrl + O

Question 50

Create a New Workbook

Answer 50

Ctrl + N

Question 51

Save a Workbook

Answer 51

Ctrl + S

Question 52

Save “as”

Answer 52

F12

Question 53

Print a Workbook

Answer 53

Ctrl + P

Question 54

Open Print Preview

Answer 54

Ctrl + F2

Question 55

Navigate Forward Between Workbooks

Answer 55

Ctrl + Tab

Question 56

Navigate Back Between Workbooks

Answer 56

Ctrl + Shift + Tab

Question 57

Close a Workbook

Answer 57

Ctrl + W

Question 58

Move One Cell to the Right

Answer 58

Right Arrow or Tab

Question 59

Move One Cell to the Left

Answer 59

Left Arrow or Shift + Tab

Question 60

Move One Cell Up

Answer 60

Up Arrow

Question 61

Move One Cell Down

Answer 61

Down Arrow

Question 62

Move One Screen Right

Answer 62

Alt + PgDn

Question 63

Move one Screen Left

Answer 63

Alt + PgUp

Question 64

Move One Screen Up

Answer 64

PgUp

Question 65

Move One Screen Down

Answer 65

PgDn

Question 66

Move to Right Edge of Data Range

Answer 66

Ctrl + Right Arrow

Question 67

Move to Left Edge of Data Range

Answer 67

Ctrl + Left Arrow

Question 68

Move to Top Edge of Data Range

Answer 68

Ctrl + Up Arrow

Question 69

Move to Bottom Edge of Data Range

Answer 69

Ctrl + Down Arrow

Question 70

Navigate to Beginning of Row

Answer 70

Home

Question 71

Move to End Cell

Answer 71

Ctrl + End

Question 72

Insert New Worksheet

Answer 72

Shift + F11

Question 73

Go to Next Worksheet

Answer 73

Ctrl + PgDn

Question 74

Go to Previous Worksheet

Answer 74

Ctrl + PgUp

Question 75

Select Entire Worksheet

Answer 75

Ctrl + A

Question 76

Select Entire Row

Answer 76

Shift + Space

Question 77

Select Entire Column

Answer 77

Ctrl + Space

Question 78

Cancel Selection

Answer 78

Esc

Question 79

Extend Selection to the Right

Answer 79

Shift + Right Arrow

Question 80

Extend Selection to the Left

Answer 80

Shift + Left Arrow

Question 81

Extend Selection Down

Answer 81

Shift + Down Arrow

Question 82

Extend Selection Up

Answer 82

Shift + Up Arrow

Question 83

Extend Selection to the Last Right Cell

Answer 83

Ctrl + Shift + Right Arrow

Question 84

Extend Selection to the Last Left Cell

Answer 84

Ctrl + Shift + Left Arrow

Question 85

Extend Selection to the Last Bottom Cell

Answer 85

Ctrl + Shift + Down Arrow

Question 86

Extend Selection to the Last Upper Cell

Answer 86

Ctrl + Shift + Up Arrow

Question 87

Show Active Cell In Selection

Answer 87

Ctrl + Back Space

Question 88

Fill Down Cop to Selected Range

Answer 88

Ctrl + D

Question 89

Delete Rows or Columns

Answer 89

Ctrl + -

Question 90

Insert Rows or Columns

Answer 90

Ctrl + Shift + +

Question 91

Select All Objects On Worksheet

Answer 91

Ctrl + Shift + Space

Question 92

Hide Selected Columns

Answer 92

Ctrl + 0

Question 93

Hide Selected Rows

Answer 93

Ctrl + 9