2: The Basics of Spreadsheets

Overview

In this section, you will manipulate the look of a worksheet and discover how to select ranges of cells as well as navigate around the worksheet. You will begin entering information in the form of text, dates, and times and learn how to format information according to type and look.

In this section you will

• change the views of the worksheet
• hide and unhide worksheets
• zoom in and out of a worksheet
• navigate through a worksheet
• enter text, dates, and times
• find and replace data
• select cells
• determine and enter cell ranges

If you get stuck, remember that there are links to additional help and tutorials in 1: Introduction to Spreadsheets.

Instructions /6

Complete the following steps in order:

Step 1: Open Basics of Sheets. Save your copy as Basics of Sheets - Firstname Lastname in your Spreadsheet Skills folder.

Step 2: Change the Zoom control to 75% and then back to 100%.

Step 3: Use the scroll bars to move up and down one row at a time.

/1 Step 4: Using the most efficient method, go to row 143. Which method did you use? Write your answer in cell A150.

Step 5: Using a key combination, move to cell A1 (beginning of sheet). To find which combo to use, refer to the Help menu in Sheets, which has shortcuts listed at the bottom of the dropdown menu. Which keyboard shortcut did you use or, if you weren't able because you lack a key, which would you use? Write your answer in cell A1.

/1 Step 6: Using a key combination, move to the last cell (i.e., Z1000). Which keyboard shortcut did you use? Write your answer in the last cell.

/1 Step 7: Go to cell C132. What is in cell C132? Write what you see in A151.

Step 8: Using click and drag, Select cells B4:B6 and A8:C9. The ":" or colon in spreadsheets means "to" so, for example, when you see A8:C9, it includes these two cells plus all cells between them.

Step 9: Select columns B and D separately.

Step 10: Select rows 7, 10, and 14 altogether by holding down the CTRL key (or Command key for Macs).

/1 Step 11: Reformat the cells that contain dates to a format like January 1, 2010 (full month spelled out, day, year). Within the Format -> Number menu, you will need to select ‘More Formats’ to find what you need.

/1 Step 12: Use the “Find and Replace” feature to find all occurrences of 2010 and replace it with 2009.

Go to the Edit menu and select Find and replace. (You can also press Ctrl + H, or⌘ + Shift + H on a Mac.) Then, type the word in the text box next to 'Find,' and click Find.