loader image
Skip to main content
If you continue browsing this website, you agree to our policies:
x

Topic outline

  • 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.

    • Upon successful completion of this unit, you will be able to:

      • open Microsoft Excel and Google Sheets and create a new spreadsheet;
      • identify the rows, columns, and cells in a Microsoft Excel or Google Sheets spreadsheet;
      • enter data in a Microsoft Excel or Google Sheets spreadsheet;
      • edit and delete data in a Microsoft Excel or Google Sheets spreadsheet; and
      • save data in a Microsoft Excel or Google Sheets spreadsheet.
    • 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.

      • 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.

    • 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.

      • 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.

    • Unit 1 Assessment

      • Take this assessment to see how well you understood this unit.

        • This assessment does not count towards your grade. It is just for practice!
        • You will see the correct answers when you submit your answers. Use this to help you study for the final exam!
        • You can take this assessment as many times as you want, whenever you want.