Data Analytics Exam 2

Unhide hidden rows within section

CTRL + Shift + 9

Hide selected Rows

CTRL + 9

Hide selected Columns

CTRL + 0

Select entire worksheet (1x - Data Region; 2x - entire worksheet)

CTRL + A

Bold

CTRL + B

Copy

CTRL + C

CTRL + D

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

Display the Find dialog box

CTRL + F

Italics

CTRL + I

Create a new, blank file

CTRL + N

Print

CTRL + P

Save

CTRL + S

Underline

CTRL + U

Paste

CTRL + V

Close selected worksheet

CTRL + W

Cut the selected cells

CTRL+X

Undo an “Undo”

CTRL + Y

Undo

CTRL + Z

F2

Edits the 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.

Move to edge of current data region

CTRL + Arrow Key

Extend the selection of cells by one

SHIFT + Arrow Key

Extend selection to the last nonblank cell

CTRL + SHIFT + Arrow Key

Move to the last cell on a worksheet (farthest right, lowest)

CTRL + End

Extend the selection of cells to the last used cell

CTRL + SHIFT + End

Start a new line in the same cell

ALT + ENTER

Fill the selected range with current entry

CTRL + ENTER

Move to the beginning of a row

HOME

Move to the beginning of a worksheet

CTRL + HOME

Extend the selection of cells to the beginning of the worksheet

CTRL + SHIFT + HOME

Move to the next sheet in a workbook

CTRL + PAGE DOWN

Move to the previous sheet in a workbook

CTRL + PAGE UP

SPACEBAR

• In a dialog box, performs the action for the selected button OR

• Selects or clears a checkbox

Select entire column

CTRL + SPACEBAR

Select entire row

SHIFT + SPACEBAR

Move one cell to the right

TAB

Move to previous cell OR previous option in a dialog box

SHIFT + TAB

Freeze Panes

ALT + W, then F

Delete Column

1. CTRL + “-”, then “c”

   OR

2. CTRL + SPACEBAR, then “-”

Delete Row

1. CTRL + “-”, then “r”

   OR

2. SHIFT + SPACEBAR, then CTRL + “-”