Google Spreadsheets

L8: Getting Started with Google Spreadsheets

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

L9: Modifying Columns, Rows, and Cells

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

L10: Formatting Cells

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

L11: Working with Multiple Sheets

  1. Create two new sheets.
  2. Rename one of the new sheets "May" and the other sheet "June".
  3. Try moving the new sheets so they are in the correct month order.
  4. Create a duplicate of the January sheet.
  5. The June sheet will not be needed yet. Delete the June sheet.

L12: Creating Simple Formulas

  1. In cell B23, use cell references to calculate the remaining funds by subtracting B22 from B21.
  2. Try seeing how cell references work by changing the nonreimbursed number in B22 to another number. Notice how the formula in B23 recalculates.
  3. 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.
  4. 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

  1. In cell F6, write a complex formula that first adds the values in C6 and D6, then multiples by the value in E6.
  2. 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

  1. 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.
  2. Use the fill handle to fill in the formula across row 6, from cell B6 through M6.
  3. 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.
  4. 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.
  5. 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.
  6. In cell H14, enter 0.07 as the new sales tax. Observe how the cells in column G recalculate.

L15: Working with Functions

  1. In cell E28, create a function that adds the range of cells E21 through E27.
  2. 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.
  3. 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

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

Comment Stream