CHAPTER OBJECTIVES - Chapter 1 CHAPTER OBJECTIVES When students have...

Copyright © 2017 Pearson Education, Inc.Chapter 1

CHAPTER OBJECTIVES

When students have finished reading this chapter, they will be able to:

•Explore the Excel Window •Enter and Edit Cell Data •Create Formulas •Display Cell Formulas •Manage Columns and Rows •Select, Move, Copy, and Paste Data •Apply Cell Styles, Alignment, and Font Options •Apply Number Formats •Manage Worksheets •Select Page Setup Options •Preview and Print a Worksheet

CHAPTER OVERVIEW

Students will be introduced to the basic concepts in Excel that provide the foundation for understanding spreadsheets, worksheets, and workbooks. They will learn to create worksheets, work with formulas, apply styles, and print a worksheet.

The major sections in this chapter are:

1.Introduction to Spreadsheets. In this section, students will learn how to design spreadsheets.They will explore the Excel window and learn the name of each window element. Then, they will enter text, values, and dates in a spreadsheet, and navigate in and among worksheets.

2.Mathematical Operations and Formulas. In this section, students will learn how to use cell references in a formula, apply the order of operations, use semi-selection to create a formula, copy a formula down a row or across a column, and display cell formulas.

3.Worksheet Structure and Clipboard Tasks. In this section, students will learn how to manage the columns and rows in a worksheet. They will insert, delete, hide, and unhide cells, columns, or rows, as well as adjust the column width and row height. Although worksheets are generally planned before entering data, at times there is a need to move data to a different location in the same worksheet or even to a different worksheet. Therefore, students will also manage the worksheet by moving, copying, and using the Paste Options and Paste Special features.

4.Worksheet Formatting. In this section, students will learn how to create a professionally formatted worksheet by applying a cell style, merging and centering data, changing cell alignments, and using borders, fonts, and colors to make data stand out so that it is easier to find and analyze. They will also learn how to apply number formats and increase or decrease decimal places.

5.Worksheets, Page Setup, and Printing. In this section, students will learn how to insert, delete, copy, move, rename, and group worksheets. They will also learn how to prepare worksheets for printing in case they need to print or email the worksheets to others in a readable format.Therefore, they will learn how to set page orientation, select scaling options, set margin (Exploring Microsoft Office Excel 2016 Comprehensive, 1e Mary Anne Poatsy, Keith Mulbery et al) (Solution Manual, For Complete File, Download link at the end of this File) 1 / 2

Copyright © 2017 Pearson Education, Inc.options, create a header or footer, select sheet options, use Print Preview, and set the various print options.

CLASS RUN-DOWN

• Have students turn in homework assignments.
• Talk about the chapter using the discussion questions listed below.
• Use a PowerPoint Presentation to help students understand the chapter content.
• Demonstrate Excel 2016 basics and capabilities.
• Run through the Scripted Lectures for the chapter. Give special attention to areas in which

students might be challenged.

• Have students complete the Capstone Exercise for Excel Chapter 1.
• Use MyITLab for in-class work or to go over homework.
• Give students the homework handout for the next class period.

LEARNING OBJECTIVES

At the end of this lesson, students should be able to:

• Identify Excel Window Elements • Identify Columns, Rows, and Cells • Navigate in and Among Worksheets • Enter Text • Use Auto Fill to Complete a Sequence • Enter Values • Enter a Date • Clear Cell Contents • Use Cell References in Formulas • Apply the Order of Operations • Use Semi-Selection to Create a Formula • Copy Formulas • Display Cell Formulas • Insert Cells, Columns, and Rows • Delete Cells, Columns, and Rows • Hide and Unhide Columns or Rows • Adjust Column Width • Adjust Row Height • Select a Range • Move a Range • Copy and Paste a Range • Use Paste Options and Paste Special • Apply a Cell Style • Merge and Center Data • Change Cell Alignment • Wrap Text • Increase Indent • Apply a Border • Apply Fill Color

• / 2