Data

Question 1

paste special, skipping blanks

Answer 1

(Ctrl + Alt + V) + B

Question 2

paste cell comments

Answer 2

(Ctrl + Alt + V) + C

Question 3

paste special, performing an addition

Answer 3

(Ctrl + Alt + V) + D

Question 4

transpose when pasting

Answer 4

(Ctrl + Alt + V) + E

Question 5

paste all, keeping source formatting

Answer 5

(Ctrl + Alt + V) + H

Question 6

paste special, performing a division

Answer 6

(Ctrl + Alt + V) + I

Question 7

paste special, performing a multiplication

Answer 7

(Ctrl + Alt + V) + M

Question 8

paste data validation

Answer 8

(Ctrl + Alt + V) + N

Question 9

paste special, performing a subtraction

Answer 9

(Ctrl + Alt + V) + S

Question 10

paste values and number formatting

Answer 10

(Ctrl + Alt + V) + U

Question 11

paste values

Answer 11

(Ctrl + Alt + V) + V

Question 12

paste all, except borders

Answer 12

(Ctrl + Alt + V) + X

Question 13

display the “remove duplicates” dialog box

Answer 13

Alt + A + M

Question 14

display the “goal seek” dialog box

Answer 14

Alt + A + W + G

Question 15

display the “scenario manager” dialog box

Answer 15

Alt + A + W + S

Question 16

display the “data table” dialog box

Answer 16

Alt + A + W + T

Question 17

start new line within cell

Answer 17

Alt + Enter

Question 18

display the “copy as picture” dialog

Answer 18

Alt + H + C + P

Question 19

clear all

Answer 19

Alt + H + E + A

Question 20

clear hyperlinks

Answer 20

Alt + H + E + L

Question 21

clear comments

Answer 21

Alt + H + E + M

Question 22

remove hyperlinks

Answer 22

Alt + H + E + R

Question 23

display the “fill across worksheets” dialog box

Answer 23

Alt + H + FI + A

Question 24

fill justify

Answer 24

Alt + H + FI + J

Question 25

fill left

Answer 25

Alt + H + FI + L

Question 26

display the “series” dialog box

Answer 26

Alt + H + FI + S

Question 27

fill up

Answer 27

Alt + H + FI + U

Question 28

display the “clipboard” task pane

Answer 28

Alt + H + FO

Question 29

paste values, keeping source formatting

Answer 29

Alt + H + V + E

Question 30

paste linked picture

Answer 30

Alt + H + V + I

Question 31

paste picture

Answer 31

Alt + H + V + U

Question 32

show all comments

Answer 32

Alt + R + A

Question 33

delete comment

Answer 33

Alt + R + D

Question 34

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

Answer 34

Ctrl + ‘

Question 35

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

Answer 35

Ctrl + “

Question 36

enter current date

Answer 36

Ctrl + ;

Question 37

display the “paste special” dialog box

Answer 37

Ctrl + Alt + V

Question 38

copy

Answer 38

Ctrl + C

Question 39

fill down

Answer 39

Ctrl + D

Question 40

delete to the end of current line

Answer 40

Ctrl + Delete

Question 41

flash fill

Answer 41

Ctrl + E

Question 42

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

Answer 42

Ctrl + Enter

Question 43

display the “insert hyperlink” dialog box

Answer 43

Ctrl + K

Question 44

expand the “quick analysis” tool

Answer 44

Ctrl + Q

Question 45

fill right

Answer 45

Ctrl + R

Question 46

enter current time

Answer 46

Ctrl + Shift + :

Question 47

paste

Answer 47

Ctrl + V

Question 48

cut

Answer 48

Ctrl + X

Question 49

edit active cell

Answer 49

F2

Question 50

display the “spelling” dialog box

Answer 50

F7

Question 51

insert cut or copied cells across a row or column

Answer 51

select row or column; right mouse button + E

Question 52

complete cell entry and go to the cell above

Answer 52

Shift + Enter

Question 53

insert or delete cell comment

Answer 53

Shift + F10 + m

Question 54

insert or edit a cell comment

Answer 54

Shift + F2

Question 55

display the “thesaurus” dialog box

Answer 55

Shift + F7

Question 56

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

Answer 56

Shift + Tab