The first thing we’re going to do with this spreadsheet is create a new worksheet where all our work will be done. In order to do that simply click on the plus symbol “+” at the bottom of the spreadsheet:
You will then notice you have two tabs, one called “Sheet” and one called “Sheet 2“. You can click between them and they can also interact with each other. The first interaction we’ll get happening is to have the student’s name from our original “Sheet” replicate in “Sheet 2“. To do that, move over to “Sheet 2” and click on Cell C8:
Notice at the top of the program you have the cell reference listed and you also have a long blank text area…that text area is called the “Formula Bar” and lets you know what is inside the selected cell. In our case we want the name of the first student from “Sheet“.