Excel Shortcuts

Question 1

CTRL+SHIFT+&

Answer 1

Applies the outline border
to the selected cells.

Question 2

CTRL+SHIFT+$

Answer 2

Applies Currency

Question 3

CTRL+SHIFT+%

Answer 3

Applies the % format

Question 4

CTRL+`

Answer 4

Alternates between displaying cell values and displaying formulas in the worksheet

Question 5

CTRL+’

Answer 5

Copies a formula from the cell above the active cell into the cell of the Formula Bar

Question 6

CTRL+1

Answer 6

Displays the Format Cells dialog box

Question 7

CTRL+D

Answer 7

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

Question 8

ALT+I+M

Answer 8

Enters a Comment in a cell

Question 9

CTRL+SHIFT+O

Question 10

CTRL+R

Answer 10

Uses the Fill Right command to copy
the contents and format of the leftmost cell
of a selected range into the cells to the right.

Question 11

CTRL+Y

Question 12

CTRL+Z

Answer 12

Uses the Undo command to reverse
the last action

Question 13

ALT+F1

Answer 13

Creates a chart of the data in the cur-
rent range

Question 14

ALT+SHIFT+F1

Answer 14

Inserts a new worksheet

Question 15

F9

Answer 15

Calculates the entire workbook

Question 16

SHIFT+ARROW KEY

Answer 16

Extends the selection of
cells by one cell.

Question 17

CTRL+SHIFT+ARROW KEY

Answer 17

Extends the selec-
tion of cells to the last nonblank cell in the same
column or row as the active cell.

Question 18

DELETE

Answer 18

Removes the cell contents (data and
formulas) from selected cells without affecting cell
formats or comment

Question 19

CTRL+END

Answer 19

Moves to the last cell on a worksheet,
in the lowest used row of the rightmost used col-
umn

Question 20

ALT+ENTER

Answer 20

Starts a new line in the same cell

Question 21

CTRL+HOME

Answer 21

Moves to the beginning of a work-
sheet

Question 22

CTRL+SHIFT+HOME

Answer 22

Extends the selection of
cells to the beginning of the worksheet.

Question 23

CTRL+PAGE DOWN

Answer 23

Moves to the next sheet in a
workbook.

Question 24

CTRL+PAGE UP

Answer 24

Moves to the previous sheet in a
workbook

Question 25

CTRL+SPACEBAR

Answer 25

Selects an entire column in a
worksheet.

Question 26

SHIFT+SPACEBAR

Answer 26

Selects an entire row in a
worksheet

Question 27

ALT+E+S+T

Question 28

ALT+E+S+R

Answer 28

Pastes copied formulas and number
formats only

Question 29

ALT+E+S+U

Question 30

ALT+E+S+C

Answer 30

Pastes copied Comments only