Make Spreadsheets Your Friend: Step-by-Step Guide

What you'll need:

• Use this guide as a reference while watching the video.
• Choose a spreadsheet tool and open a blank sheet if you want to follow along.

Example 1: Get Started

1. Begin with a new spreadsheet.
2. Select cell A2.
3. Enter your first name.
4. Select cell B2.
5. Enter your last name.
6. Adjust the size of rows and columns:
   • If needed, drag the right edge of the column to fit your name.
   • To wrap text, select cells, columns, or rows, go to Format > Wrapping > Wrap.

Example 2: Add Labels

1. Select cell A1.
2. Enter "First Name."
3. Select cell B1.
4. Enter "Last Name."
5. Select cells A1 and B1, then click the bold icon on the toolbar.

Example 3: Add More Attributes and Data

1. Select cell C1 and enter "Siblings."
2. Select cell D1 and enter "Favorite Color."
3. Select cell E1 and enter "Favorite Dessert."
4. Bold the labels (select cells and click the bold icon).
5. Adjust columns to fit the new text.
6. Enter corresponding data in cells C2, D2, and E2 (your info).
7. Add data about two more people in rows 3 and 4.

Example 4: Organize Your Data

1. Select all columns with data.
2. Various ways to select multiple cells:
   • Hold Command (Mac) or Ctrl (PC) key for nonadjacent cells.
   • Hold Shift key and drag/select with cursor.
   • Drag cursor over cells.
3. Go to Data > Sort range > Advanced range sorting options.
4. Check "Data has header row" and ensure "A to Z" is selected.
5. Choose "Siblings" in the Sort by drop-down menu.
6. Click Sort to organize by the number of siblings.

Example 5: Use a Formula

1. Select the next empty cell in the "Siblings" column (C5).
2. Enter the formula "=C2+C3+C4."
3. Press Enter to calculate the total number of siblings.

Feel free to follow along and use this guide as a reference for additional context or clarification during the video. This activity is not graded, but it's a great way to practice the demonstrated skills. Enjoy the learning experience!