Intermediate+Spreadsheet+Applications

Start by opening a new blank workbook in your spreadsheet application.
 * You should see something that looks similar to the following: || [[image:http://www.saskschools.ca/curr_content/info10/module11/images/ip10ss1.GIF width="422" height="409" align="center" caption="An example of a spreadsheet"]] ||

The first thing that you will notice that this sheet or workbook is made up of several horizontal and vertical lines different lines. These lines make up __vertical columns__, and __horizontal rows__. The image at the right show the "A" column has been selected. You select a column by clicking on the letter "A". Go back to your spread sheet, and select the "A" column so that its looks like the image on the right. To insert a column before column C, select column C, then click Insert on the pull down menu, and then click Insert cells.

To insert a row before row 3, select row three, then click Insert on the pull down menu, and then click Insert cells. ||
 * [[image:http://www.saskschools.ca/curr_content/info10/module11/images/ip10ss2.gif width="400" height="189"]] || The image to the left shows an example of the selected row 3. Go back to your spread sheet and select row 3 by clicking on the number 3.

You can move between cells by tabbing over, and pressing return, or by using your arrow keys. The Formula Bar is circled in green on the image at the right. You can enter data into a cell in two methods you can click on the cell itself, and type the data in, or you can click on the cell once, then click on the formula bar and input the information up there. When you press return, your data will be entered into the cell. ||
 * Just like each of the little students in the school, each of the little squares (or __cells__) on a spread sheet has a name. If you examine the image at the right of the page, you will see that I have named provided names for three of the cells. You name a cell by looking at the column it is in, and the row it is in. (Always column then row example C42 not 42C)
 * [[image:http://www.saskschools.ca/curr_content/info10/module11/images/ip10ss3.GIF width="291" height="316" align="right" caption="The formula bar"]] ||

In several of the activities in this module you will again be asked to use your imagination. In this lesson, we will be pretending that you have been hired by a popular car dealership to count the numbers and colors of cars that pass by during a week (it is just a summer job, not a career). The dealership will then use this data to determine the most popular colors for their 2003 order. After a week of careful observation, you are ready to report your results. Unfortunately you spilled coffee on the napkin you were using as a tally sheet. Enter the following data into a spreadsheet and then use a formula to find the sum for each day and for each color.
 * Mini-Assignment** ~
 * Colour || Monday || Tuesday || Wednesday || Thursday || Friday || Total ||
 * Red || 3 || 6 || 2 || 1 || 11 ||  ||
 * Green || 14 || 18 || 15 || 16 || 12 ||  ||
 * Blue || 32 || 11 || 14 || 19 || 6 ||  ||
 * Yellow || 0 || 4 || 2 || 5 || 3 ||  ||
 * Black || 24 || 19 || 16 || 24 || 12 ||  ||
 * White || 144 || 62 || 179 || 328 || 11 ||  ||
 * Total ||
 * Total ||