• Unit 2: Basic Commands and Functions

    We use spreadsheets to organize large amounts of data to perform calculations, and we often need to present our data in tables or graphs. In this unit, we will explore how to enter data and format it, and how to create and use formulas to manipulate data. 

    You should think about your spreadsheet as a presentation for an audience, whether that audience is your boss, your colleagues, or even yourself. Your data will often be more understandable and easier to manipulate with formulas when the data is organized and makes sense.

    Completing this unit should take you approximately 2 hours.

    • 2.1: Formatting Data

      We use spreadsheets to organize large amounts of data, to perform calculations, and to present data in the form of tables or graphs. Because of this, it is important to format the data in a spreadsheet clearly and for its intended purpose. This can involve sorting and editing data that is organized in columns and rows.

    • 2.2: Using Spreadsheets to Create Simple Formulas

      We use formulas to perform calculations on our data, such as addition, subtraction, multiplication, and division.

    • 2.3: Creating Tables and Graphs of Data

      One of the benefits of using spreadsheet software is that you can use tables and graphs to present large amounts of data. Tables and graphs communicate information better than a simple spreadsheet of data. When you think about how to present data, you must first determine the appropriate type of graph or table for the specific data you want to communicate. For example, a pie graph may be a good way to show demographics of a group of voters, but it would not be a good way to show a weather forecast.

    • Unit 2 Assessment