HW 6.2GD EXER Split Amperand
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRS
1
NAMESCHOOLCITYSTATECHALLENGE ONE -- USE SPLIT FORMULA TO SEPARATE FIRST AND LAST NAMES INTO COLUMNS F AND G. Do just one and then magic spot fill down.
2
Amanda AbrahamSt. Francis Episcopal Day SchoolHoustonTXAmanda AbrahamAmandaAbraham
3
Carrie FowlerSt. John's Parish Episcopal Day SchoolTampaFLCarrie FowlerCarrieFowler
4
Dick PellerNorthfield Mount Hermon SchoolGillMADick PellerDickPeller
5
Jenny ZagarielloPingry SchoolBernardsNJJenny ZagarielloJennyZagariello
6
Joanna ShermanRodoph Sholom SchoolNew YorkNYJoanna ShermanJoannaSherman
7
Rachel DelcambreAscension Episcopal SchoolLafayetteLARachel DelcambreRachelDelcambre
8
Sandra YoungAscension Episcopal SchoolLafayetteLASandra YoungSandraYoung
9
COPY AND PASTE my worksheet named STEVE into a new worksheet that you will name after yourself. If you are stumped and want to see solutions, I have created a worksheet named LB with the answers. Good luck!CHALLENGE TWO -- use the & command to generate the sentence "Amanda Abraham works in Houston in the state of TX." without the quotes of course. Don't forget the period and make sure you do just ONE and then magic spot fill down.
10
HoustonTXAmanda AbrahamAmanda Abraham works in Houston in the state of TX
11
TampaFLCarrie FowlerAmanda Abraham works in Houston in the state of TX
12
GillMADick PellerDon't use this worksheet but COPY and PASTE into your own!
13
BernardsNJJenny Zagariello
14
New YorkNYJoanna Sherman
15
LafayetteLARachel Delcambre
16
LafayetteLASandra Young
17
NAMESCHOOLCITYSTATETEAMCHALLENGE THREE -- use the MERGE feature to make your sentence span 3 columns like my instructions in yellow.
18
Amanda AbrahamSt. Francis Episcopal Day SchoolBernardsNJturquoise
19
Carrie FowlerSt. John's Parish Episcopal Day SchoolGillMAturquoise
20
Dick PellerNorthfield Mount Hermon SchoolHoustonTXpurpleDon't use this worksheet but COPY and PASTE into your own!
21
Jenny ZagarielloPingry SchoolLafayetteLAturquoise-[
22
Joanna ShermanRodoph Sholom SchoolLafayetteLApurple
23
Rachel DelcambreAscension Episcopal SchoolNew YorkNYgreen
24
Sandra YoungAscension Episcopal SchoolTampaFLgreen
25
CHALLENGE FOUR -- HIGHLIGHT JUST ROWS 18-24 in your own worksheet and SORT BY COLUMN E so that partners are next to each other.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu