Excel

Question 1

CTRL+PgUp

Answer 1

Switches between worksheet tabs, from left-to-right.

Question 2

CTRL+PgDn

Answer 2

Switches between worksheet tabs, from right-to-left.

Question 3

CTRL+;

Answer 3

Enters the current date.

Question 4

CTRL+’

Answer 4

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

Question 5

CTRL+A

Answer 5

Selects the entire worksheet.

Question 6

CTRL+C

Answer 6

Copies the selected cells.

Question 7

CTRL+F

Answer 7

Displays the Find and Replace dialog box, with the Find tab selected.

Question 8

CTRL+G

Answer 8

Displays the Go To dialog box.

Question 9

CTRL+K

Answer 9

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

Question 10

CTRL+N

Answer 10

Creates a new, blank workbook.

Question 11

CTRL+O

Answer 11

Displays the Open dialog box to open or find a file.

Question 12

CTRL+P

Answer 12

Displays the Print dialog box.

Question 13

CTRL+S

Answer 13

Saves the active file with its current file name, location, and file format.

Question 14

CTRL+U

Answer 14

Applies or removes underlining.

Question 15

CTRL+V

Answer 15

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.

Question 16

CTRL+W

Answer 16

Closes the selected workbook window.

Question 17

CTRL+X

Answer 17

Cuts the selected cells.

Question 18

F1

Answer 18

Displays the Microsoft Office Excel Help task pane.

Question 19

F2

Answer 19

Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.

Question 20

F3

Answer 20

Displays the Paste Name dialog box.

Question 21

F4

Answer 21

Repeats the last command or action, if possible.

Question 22

F5

Answer 22

Displays the Go To dialog box.

Question 23

F6

Answer 23

Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.

Question 24

F7

Answer 24

Displays the Spelling dialog box to check spelling in the active worksheet or selected range.

Question 25

F8

Answer 25

Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.

Question 26

F9

Answer 26

Calculates all worksheets in all open workbooks.

Question 27

F10

Answer 27

Turns key tips on or off.

Question 28

F11

Answer 28

Creates a chart of the data in the current range.

Question 29

F12

Answer 29

Displays the Save As dialog box.

Question 30

PAGE DOWN

Answer 30

Moves one screen down in a worksheet. ALT+PAGE DOWN moves one screen to the right in a worksheet. CTRL+PAGE DOWN moves to the next sheet in a workbook. CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.

Question 31

PAGE UP

Answer 31

Moves one screen up in a worksheet. ALT+PAGE UP moves one screen to the left in a worksheet. CTRL+PAGE UP moves to the previous sheet in a workbook. CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.

Question 32

SPACEBAR

Answer 32

In a dialog box, performs the action for the selected button, or selects or clears a check box. CTRL+SPACEBAR selects an entire column in a worksheet. SHIFT+SPACEBAR selects an entire row in a worksheet. CTRL+SHIFT+SPACEBAR selects the entire worksheet.

Question 33

TAB

Answer 33

Moves one cell to the right in a worksheet. SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box. CTRL+TAB switches to the next tab in dialog box. CTRL+SHIFT+TAB switches to the previous tab in a dialog box.