7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

1/11

Microsoft Excel: Exercise 2 Basic

1. Click on START.

2. Click on PROGRAMS.

3. Click on MICROSOFT EXCEL.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

2/11

4. Type Training for Employable

Computer Skills.

6. Type te !o"#$May-July 2001.

%. P"e$$ te E&TER key.

'. Type te !o"#$Last Name.

(#on)t typeyourl*$t n*+e,

-. P"e$$ te E&TER key.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

3/11

'. Type: L*$t &*+e.

(#on)t typeyourl*$t n*+e,

. P"e$$ te TA/ key.

10. Type te !o"#$First Name

(donttypeyouri"$t n*+e,

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

4/11

13. Click in Cell A4.

14. Type !ar"ner.

1%. P"e$$ te TA/ key.

16. TypeLeslie.

1-. P"e$$ te TA/ key.

11. P"e$$ te TA/ key.

12. TypeE-Mail.

1'. Type leslie.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

5/11

20. Typegar"ner.

1. ol# te SIFT key *n# P"e$$

te n#e"line key once.

21. ol# te SIFT key *n# p"e$$

te 2 key once.

yo !ill $ee ti$ $y+ol5 @

22. Type#otmail$om

o *7e type# Le$lie)$ e8+*il *##"e$$5le$lie9:*"#ne";ot+*il.co+

M*ke $"e *ll o te ino"+*tion i$ incell C4.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

6/11

2%. Type te ino"+*tion o" te$e $t#ent$5

$$ein R*i+* R*i+*$$ein1;ot+*il.co+

$$ein A#l

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

7/11

2-. Clickon Le$lie)$ e8+*il *##"e$$.

2. Right-Click on Le$lie)$

e8+*il *##"e$$.

2'. Ti$ i$ * p"o:"*+ o" $en#in:

e8+*il +e$$*:e$ on te

Inte"net.

Click on te X. ?e #o not

!*nt to $en# *n e8+*il "i:t

no!.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

8/11

30. Click on

REMO@E PERLI&>.

31. Re+o7e te ype"link$ on *ll

o te e8+*il *##"e$$e$.

32. A"e *ll o te le line$ :one

34. Click on cell A1.

3%. Click on te / tton.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

9/11

36. Click on te little *""o!

neBt to te ont $ie.

3-. Click on 20.

3'. i:li:t cell$ A1 to G1.

3. Click on te MERGE *n#

CE&TER tton.

40. Click on cell A2.

41. Click on te little *""o!

42. Click on 14.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

10/11

43. Dole click et!een te

col+n$.

44. Dole8click e"e.

4%. Dole8click e"e.

46. Click on cell A2.

4-. Click on te / tton.

7/24/2019 Excel Exercise 2 SIMPLIFIED -Making Lists

11/11

%2. Sae ti$ eBe"ci$e on yo" #i$k.

&*+e it E!CE" 2.

4'. i:li:t cell$ A4 to C.

4. Click on te SORT

ASCE&DI&G tton.

%0. Right -Clickon te n+e"neBt to R*celle >ee")$

n*+e.

%1. Clickon DELETE.