Data Flashcards

1
Q

paste special, skipping blanks

A

(Ctrl + Alt + V) + B

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

paste cell comments

A

(Ctrl + Alt + V) + C

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

paste special, performing an addition

A

(Ctrl + Alt + V) + D

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

transpose when pasting

A

(Ctrl + Alt + V) + E

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

paste all, keeping source formatting

A

(Ctrl + Alt + V) + H

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

paste special, performing a division

A

(Ctrl + Alt + V) + I

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

paste special, performing a multiplication

A

(Ctrl + Alt + V) + M

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

paste data validation

A

(Ctrl + Alt + V) + N

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

paste special, performing a subtraction

A

(Ctrl + Alt + V) + S

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

paste values and number formatting

A

(Ctrl + Alt + V) + U

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

paste values

A

(Ctrl + Alt + V) + V

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

paste all, except borders

A

(Ctrl + Alt + V) + X

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

display the “remove duplicates” dialog box

A

Alt + A + M

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

display the “goal seek” dialog box

A

Alt + A + W + G

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

display the “scenario manager” dialog box

A

Alt + A + W + S

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

display the “data table” dialog box

A

Alt + A + W + T

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

start new line within cell

A

Alt + Enter

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

display the “copy as picture” dialog

A

Alt + H + C + P

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

clear all

A

Alt + H + E + A

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

clear hyperlinks

A

Alt + H + E + L

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

clear comments

A

Alt + H + E + M

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

remove hyperlinks

A

Alt + H + E + R

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

display the “fill across worksheets” dialog box

A

Alt + H + FI + A

24
Q

fill justify

A

Alt + H + FI + J

25
fill left
Alt + H + FI + L
26
display the "series" dialog box
Alt + H + FI + S
27
fill up
Alt + H + FI + U
28
display the "clipboard" task pane
Alt + H + FO
29
paste values, keeping source formatting
Alt + H + V + E
30
paste linked picture
Alt + H + V + I
31
paste picture
Alt + H + V + U
32
show all comments
Alt + R + A
33
delete comment
Alt + R + D
34
copy formula/text from cell above into active cell or formula bar
Ctrl + '
35
copy values/text from cell above into active cell or formula bar
Ctrl + "
36
enter current date
Ctrl + ;
37
display the "paste special" dialog box
Ctrl + Alt + V
38
copy
Ctrl + C
39
fill down
Ctrl + D
40
delete to the end of current line
Ctrl + Delete
41
flash fill
Ctrl + E
42
enter current entry in selected range and stay in same active cell
Ctrl + Enter
43
display the "insert hyperlink" dialog box
Ctrl + K
44
expand the "quick analysis" tool
Ctrl + Q
45
fill right
Ctrl + R
46
enter current time
Ctrl + Shift + :
47
paste
Ctrl + V
48
cut
Ctrl + X
49
edit active cell
F2
50
display the "spelling" dialog box
F7
51
insert cut or copied cells across a row or column
select row or column; right mouse button + E
52
complete cell entry and go to the cell above
Shift + Enter
53
insert or delete cell comment
Shift + F10 + m
54
insert or edit a cell comment
Shift + F2
55
display the "thesaurus" dialog box
Shift + F7
56
complete cell entry and move one cell tot he left in the same worksheet or to a previous unlocked cell in another sheet
Shift + Tab