# Google Spreadsheets

# L8: Getting Started with Google Spreadsheets

**Select**cell B13 and insert an "x" to mark that student as attending.**Cut and paste**the contents of cell C7 to cell B7.**Drag and drop**cells C11:C13 to B11:B13.- Use the
**fill handle**to copy the content of cell D9 to other cells in the same column.

# L9: Modifying Columns, Rows, and Cells

- Change the
**width**of column B using the horizontal arrow. - Double-click a column border to
**autosize**column D. **Insert**a column between columns A and B.**Move**row 5 above row 3.- Select the cell range A3:A10 and use the
**wrap text**feature. - Select the cell range A1:D1 and
**merge**these cells into a single cell. - Try
**freezing**a row or column in place.

# L10: Formatting Cells

- Increase the
**font size**of cell G1 to**14pt**. - Change the
**font style**of cells B3:B8 to**Verdana**. - Select a new
**font color**for cell G1. - Modify the horizontal alignment of cells B3:B8 to
**center align.** - Add
**borders**to cells B1:G8. - Set a different
**text background color**for each day in cells G3:G8.

# L11: Working with Multiple Sheets

- Create two new
**sheets**. **Rename**one of the new sheets "May" and the other sheet "June".- Try
**m****oving**the new sheets so they are in the correct month order. - Create a
**duplicate**of the January sheet. - The June sheet will not be needed yet.
**Delete**the June sheet.

# L12: Creating Simple Formulas

- In cell B23, use
**cell references**to calculate the remaining funds by**subtracting**B22 from B21. - Try seeing how cell references work by changing the nonreimbursed number in B22 to another number. Notice how the formula in B23 recalculates.
- In cell E18, try using the
**point-and-click method**to write a simple formula that multiplies the price of the easels by the number of students. - There is a mistake in cell E24.
**Edit**the formula in E24 to change the multiplication sign to a division sign.

# L13: Creating Complex Formulas

- In cell F6, write a
**complex formula**that first adds the values in C6 and D6, then multiples by the value in E6. - The formula in cell F9 has been written incorrectly. It multiplies first and then adds. Correct the formula by adding parentheses so it adds first and then multiplies.

# L14: Types of Cell References

- Using the sheet labeled Expenses, in cell B6 create a formula that uses
**relative cell references**to add the values for groceries, utilities, rent, and car. - Use the
**fill handle**to fill in the formula across row 6, from cell B6 through M6. - Double-click on cell M6 to view the formula and the relative cell references. Enter a different value in cell M2. Observe how cell M6 recalculates the value.
- Click the sheet labeled Order Form. In cell G5, create a formula that will add the value in cell F5 to the value in cell H14. Use an
**absolute cell reference**to H14 in the formula. - Use the fill handle to drag the formula down column G to fill in the cells from G5 through G12. Double-click on cell G12 to view the formula for accuracy. H14 should be referenced in the formula.
- In cell H14, enter 0.07 as the new sales tax. Observe how the cells in column G recalculate.

# L15: Working with Functions

- In cell E28, create a
**function**that adds the range of cells E21 through E27. - In cell L15, use the
**Functions button**to insert a function that will find the average number of reps for the range of cells L5 through L14. - In cell Q1, create a function that counts the number of exercises performed in the cell ranges A5 through A14, J5 through J14, and cell C19.

# L16: Sorting and Filtering Data

- Using the Books on Loan sheet,
**sort****the sheet**so the books are alphabetized by title. **Filter**the Due Date column to display only the books that are due on July 14, 2012 (7/14/2012).- Try applying a
**second filter**to the sheet. - Using the Workout Log sheet,
**sort the range**of cells L21:N27 to display the stationary bike Distance column in descending order.