Unit 1: Getting Started with Spreadsheets
Spreadsheets allow us to organize and manipulate sets of data. Using spreadsheets, we can enter large amounts of numerical data, organize it, and perform calculations using the data. Later in the course, we will use spreadsheets to create personal budgets and business invoices. In this unit, we will describe the primary components of a spreadsheet and how to enter and edit data.
Completing this unit should take you approximately 1 hour.
1.1: Identifying Parts of a Spreadsheet
In this section, we identify the important features of a spreadsheet. When we open a spreadsheet program, we see a worksheet. A worksheet is simply the spreadsheet you use to enter and manipulate your data. A spreadsheet is a grid of rows and columns. Across the top of the spreadsheet, you will see letters to mark the columns. Down the left hand side of the spreadsheet, you will see numbers to mark the rows.
Each block in the spreadsheet is called a cell. The cell is defined by its column letter and row number. For example, the cell in the top left hand corner of a spreadsheet is A1, because it is in column A and row 1 of the spreadsheet.
1.2: Entering and Editing Data in Spreadsheets
Now that we understand the parts of the spreadsheet, we can begin inputting data. Because spreadsheets often contain large amounts of numerical data, it is important to organize your spreadsheet by using headings to label your data. This prevents confusion if you or someone else needs to use your spreadsheet later.
Unit 1 Assessment
- Receive a grade