Beginning Flashcards by Lucas Michael

Q

Format for input

A

blue and yellow box

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format for number from external source

A

green

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

what does the concatenate function do

A

assemble multiple cells together

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

how to select entire column

A

control + spacebar

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

autofit column

A

Alt + H + O + i

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

look at formula

A

F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Background colour change

A

Alt + H + H

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Text colour change

A

Alt + H + F + C

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

formatting

A

F1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Anchor cell

A

F4, hit again to make it just the row

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

fill out selection in hihglighted column

A

Control + D

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Fill out selction in row

A

Control + R

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Centre cells

A

Alt + H + A +C

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

enter date

A

CONTROL + ;

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

APPLY % FORMAT

A

CONTORL + SHIFT + 5

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SELECT ROW

A

SHIFT + SPACEBAR

Q

DELETE SELECTION

A

ALT + E + D

Q

SHOW ALL FORMULAS

A

CONTROL + ~

Q

REPEAT ACTION

A

F4

Q

How to combine multiple sums

A

Subtotal , objective, eliminate double counting

Q

Indent items

A

ALT + H + G 6?

Q

Border

A

Alt + H +B

Q

move the end of selection

A

control + arrow

Q

highlight and select everything

A

Control + shift + arrow

begiing of work sheet

Control + home

move to new tab

Control + page down page up moves you to new sheet in the other direction

track cell reference

Control+ [

return to cell

F5

recalculate workbook

F9

Spell check work book

F7

sort data

ALT + D + S

Open pivot table wizard

ALT + D + P

Toggle between sheets

CNTRL + PAGE DOWN

Show macro

ALT + T+ M+ M

Set up sensitivy table

Alt + D + T