Editing / Formulas Flashcards

1
Q

Inserts a new Worksheet

A

Shift + F11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Inserts new cell(s) / row(s) / column(s)

A

Ctrl + Shift + Plus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Deletes cell(s) / row(s) / column(s)

A

Ctrl + Minus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Fill cells ‘Down’ in a Column

A

Ctrl + D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Fill cells ‘Right’ in a Row

A

Ctrl + R

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

‘Format Cell’ dialogue box (Use Tab, Space to navigate inside the box)

A

Ctrl + 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Activates Cell Edit mode, allows to walk inside the cell

A

F2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Inserts a Row Above

A

Alt&raquo_space; I&raquo_space; R

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Inserts a Column to the Left

A

Alt&raquo_space; I&raquo_space; C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

‘Paste Special’ dialogue box

A

Alt&raquo_space; E&raquo_space; S

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

‘Find / Replace’ dialogue box

A

Alt&raquo_space; E&raquo_space; F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

‘Conditional Formatting’ dialogue box

A

Alt&raquo_space; O&raquo_space; D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Calculate all worksheets

A

F9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Toggle between Absolute / Mixed / Relative Cell Referencing (Four times Sequential Key Presses)

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Auto Sum

A

Alt + =

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Enters current date in cell

A

Ctrl + ;

17
Q

Flash Fill

A

Ctrl + E

18
Q

Transpose

A

Alt&raquo_space; E&raquo_space; S&raquo_space; E

19
Q

Display Formula Window after typing formula name

A

Ctrl + a