Excel Flashcards by Drew S.

Q

Add Worksheet

A

ALT I W

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Delete Worksheet

A

ALT H D S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move Back and Forth between worksheets

A

CTRL page up or CTRL page down

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move Around Workbook

A

ALT

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

New Workbook

A

CTRL N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Open a File

A

CTRL O

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save a File

A

CTRL S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Print a File

A

CTRL P

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Use after ALT to get inside an area

A

TAB

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select

A

Spacebar

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Opens Options

A

ALT F T

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Sum Equation

A

ALT and “+/=”

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Opens Office Button Menu

A

ALT F

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Brings up Save as

A

ALT A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Autofit column width

A

ALT H O I

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Manually adjust column width for multiple columns

A

ALT H O W

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Highlight a column

A

CTRL and Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Highlight a row

A

Shift and Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Manually adjust rows

A

ALT H O H

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Paste Special

A

ALT E S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

New Workbook

A

CTRL N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move between workbooks

A

CTRL Tab

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Change Zoom level

A

ALT V Z

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select and move

A

Shift and arrows

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format Cell dialogue box

A

CTRL 1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Go in

A

TAB

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Go out

A

Shift TAB

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Goes right to it

A

ALT “underlined letter”

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Toggle Checkboxes

A

spacebar

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Highlight a specific range

A

CTRL SHIFT Arrow keys

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Freeze Panes

A

Alt WFF

Q

Split Panes

A

Alt + WS

Q

Jump from pane to pane

A

F6

Q

Goes Backwards

A

Shift + F6

Q

Undo

A

Ctrl z

Q

Redo

A

Ctrl y

Q

Enter a cell

A

F2

Q

Exit a cell

A

F2

Q

Clear Things

A

Alt HE

Q

Add comments

A

Shift F2

Q

Right Fill

A

Ctrl R

Q

Down fill

A

Ctrl D

Q

New row

A

Alt I R

Q

New Column

A

Alt I C

Q

Delete Row

A

Alt HDR

Q

Delete column

A

Alt HDC

Q

Paste Special

A

Alt ES

Q

Multiply

A

Alt ESM

Q

Subtract

A

Alt ESS

Q

Divide

A

Alt ESI

Q

Transpose

A

Alt ESE

Q

Number Format

A

Ctrl Shift !

Q

Current Format

A

Ctrl Shift $

Q

Percentage format

A

Ctrl shift %

Q

Date format

A

Ctrl shift #

Q

Remove all borders

A

Ctrl shift _

Q

Name Manager

A

Ctrl F3

Q

New cell name

A

Alt N

Q

Anchor Cells

A

F4

Q

Name Worksheet

A

Alt HOR

Q

New Worksheet

A

Alt HIS

Q

Delete worksheet

A

Alt EL

Q

Grouping Columns

A

Ctrl Spacebar

Shift Alt right arrow create group

Alt AH Hide

Alt AJ Unhide

Shift Alt Left Arrow remove group

Q

Grouping Rows

A

Same thing just Shift spacebar at the beginning

Q

Grouping worksheets

A

Ctrl shift

Page up or down

Q

Highlight precedent cells

A

Ctrl Left bracket

Alt MP

Q

Highlight dependent cells

A

Ctrl right bracket

Alt MD

Q

Clear Audit

A

Alt MAA

Q

Highlight specifics

A

F5 go to

Alt special

Q

Create own conditional format

A

Alt OD

Q

Conditional Formatting

A

Alt HL

Q

Create breaks if a lot of text

A

Alt enter

Q

Find and replace

A

Ctrl F

Q

Print

A

Ctrl P

Q

Data Table

A

Alt DT

Q

Data Validation

A

Alt DL