Day 9

Upon completion of this Google Sheets Lesson, you will be able to:

• Define the terms spreadsheet and worksheet.
• Identify the parts of a worksheet.
• Open an existing workbook.
• Rename a workbook.
• Move the active cell in a worksheet.
• Select cells and enter data in a worksheet.
• Edit data in cells.
• Find and replace data.
• Preview and print a worksheet.
• Close a workbook.

Activity 2-1

1. The purpose of a spreadsheet is to solve problems that involve numbers. Identify two numerical problems in each of the following categories that might be solved by using a spreadsheet.  Record your results in a Google Document titled Activity 2-1-(your initials).
   1. Career
   2. Personal
   3. School

Activity 2-2

1. You have selected a large range of adjacent cells that extends over several screens. You realize that you incorrectly included one additional column of cells in the range.  To reselect the range of cells, you must page up to the active cell (the first cell of the range) and drag through several screens to the last cell in the range. Is there a better way to remove the column from the range, without having to reselect the entire range? Also, is there a faster way to select such a large range—one that doesn’t include dragging through several screens?  Click the Google Spreadsheet Help menu to open the Sheets Help window. Research how to select fewer cells without canceling your original selection. Then research how to select a large range without dragging. In Google Document, write a brief explanation of the steps you would take to change the selected range and to select a large range without dragging. Name the file Activity 2-2-(your initials).

Activity 2-3

To be useful, worksheets must convey information clearly, both on-screen and on the printed page. Identify ways to accomplish the following:

1. Emphasize certain portions of a worksheet.
2. Make data in a worksheet easier to read.
3. Distinguish one part of a worksheet from another.
4. Format similar elements in a worksheet consistently.

Record your findings and thoughts in a new Google Document titled Information-(your initials).