Introduction

Over the last lessons in this unit, you have learned how to create formulas in different types of formats.

At the end of the lesson, you will be able to create formulas by using the AutoSum button and copy those formulas to other cells by using the fill handle.

Editing tools in Excel with Auto Sum button highlighted

You will also insert new columns and rows and see how the formulas will automatically adjust the cell reference name.

Lesson Objectives

Following successful completion of this lesson, students will be able to...

  • Utilize spreadsheet features, including formulas and functions, in creating, editing, and printing workbooks
  • Demonstrate programming logic used to create a product
  • Utilize interactive models and digital sources to address real-world problems

Enduring Understandings

  • Spreadsheets and their unique abilities can be very useful in organizing and calculating various types of data.

The above objectives correspond with the Alabama Course of Study: Business Technology Applications standards: 6, 19, 21.