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.
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.
Watch this video to learn how to input data into the cells of a spreadsheet. The presenter also mentions why you should consistently save your work.
This video discusses the structure of spreadsheets. The presenter also describes how to use formulas to perform calculations, which we explore in more detail in Unit 2.
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.
As you read this article, open up your spreadsheet program and follow along with the text. This will help you learn how to enter headings and data. This tutorial also explains some special functions of Excel, which we will discuss in more detail in the next unit. We use functions to perform simple calculations, and we can use autofill to make it easier to input large amounts of information. You will also learn how to format your spreadsheet to make it easier to read.
Take this assessment to see how well you understood this unit.