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.
- 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 moving 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.