Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel > Data > Flashcards

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
Q

fill left

A

Alt + H + FI + L

26
Q

display the “series” dialog box

A

Alt + H + FI + S

27
Q

fill up

A

Alt + H + FI + U

28
Q

display the “clipboard” task pane

A

Alt + H + FO

29
Q

paste values, keeping source formatting

A

Alt + H + V + E

30
Q

paste linked picture

A

Alt + H + V + I

31
Q

paste picture

A

Alt + H + V + U

32
Q

show all comments

A

Alt + R + A

33
Q

delete comment

A

Alt + R + D

34
Q

copy formula/text from cell above into active cell or formula bar

A

Ctrl + ‘

35
Q

copy values/text from cell above into active cell or formula bar

A

Ctrl + “

36
Q

enter current date

A

Ctrl + ;

37
Q

display the “paste special” dialog box

A

Ctrl + Alt + V

38
Q

copy

A

Ctrl + C

39
Q

fill down

A

Ctrl + D

40
Q

delete to the end of current line

A

Ctrl + Delete

41
Q

flash fill

A

Ctrl + E

42
Q

enter current entry in selected range and stay in same active cell

A

Ctrl + Enter

43
Q

display the “insert hyperlink” dialog box

A

Ctrl + K

44
Q

expand the “quick analysis” tool

A

Ctrl + Q

45
Q

fill right

A

Ctrl + R

46
Q

enter current time

A

Ctrl + Shift + :

47
Q

paste

A

Ctrl + V

48
Q

cut

A

Ctrl + X

49
Q

edit active cell

A

F2

50
Q

display the “spelling” dialog box

A

F7

51
Q

insert cut or copied cells across a row or column

A

select row or column; right mouse button + E

52
Q

complete cell entry and go to the cell above

A

Shift + Enter

53
Q

insert or delete cell comment

A

Shift + F10 + m

54
Q

insert or edit a cell comment

A

Shift + F2

55
Q

display the “thesaurus” dialog box

A

Shift + F7

56
Q

complete cell entry and move one cell tot he left in the same worksheet or to a previous unlocked cell in another sheet

A

Shift + Tab

Excel (14 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions