A. Create a new spreadsheet

B. Enter rows 1-3 below.

A

B

C

D

1

Hello

Amy

Tom

2

Goodbye

Karen

Bob

3

Good to see you

Mary

Harry

4

C. Enter a formula to create cell A5 as Hello Amy, using A1 and B1.

D. Change the formula in A5 so that you can copy it to A6 & A7 to say everything possible to Amy. It should look like the following:

5

Hello Amy

6

Goodbye Amy

7

Good to see you Amy

E. Enter a formula to create cell A9 as Hello Amy, using A1 and B1.

F. Change that formula in A9 so that you can copy it to A10, A11, B9, B10 & B11 to say Hello to Amy and Tom, Goodbye to Karen and Bog and "Good to See you" to Mary and Harry. It should look like the following:

9

Hello Amy

Hello Tom

10

Goodbye Karen

Goodbye Bob

11

Good to see you Mary

Good to see you Harry