# Module 2 – Intermediate Excel 2016

Module 2
2.1 How a Table Differs from a Range of Cells
2.2 Creating a Table Using a Range of Data – Practice Exercise 9
2.3 Customizing a Table – Using the Total Row feature – Practice Exercise 10
2.4 Customizing a Table – Using Formulas in Tables – Practice Exercise 11
2.5 Customizing a Table – Creating Names Using Name Box – Practice Exercise 12
2.6 Customizing a Table – Assigning Names to Ranges – Practice Exercise 13
2.7 Customizing a Table – Using the Name Manager – Practice Exercise 14
2.8 Sorting a Table
2.9 Sorting a Table – Using Filter Buttons to Sort a Table – Practice Exercise 15
2.10 Sorting a Table – Using a Custom Sort to Sort a Table – Practice Exercise 16
2.11 Filtering a Table – Practice Exercise 17

Module 2 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of describing the subject matter on video(s), at the end of the module the student will be able to:

• Identify differences between a range of cells and an Excel table as shown in the study guide and directed by the instructor
• Imitate the instructor’s action in performing basic operations used in creating an Excel table
• Imitate the instructor’s action in performing basic operations used in customizing an Excel table using table-specific formulas
• Imitate the instructor’s action used in customizing an Excel table using a Name Box
• Imitate the instructor’s action used in customizing an Excel table by assigning names to ranges
• Imitate the instructor’s action used in customizing an Excel table by using the Name Manager
• Identify the ways to prevent scrambling of data while performing a sort on an Excel table
• Imitate the instructor’s action in performing basic sorting operations on an Excel table
• Imitate the instructor’s action in performing basic sorting operations using filter buttons
• Imitate the instructor’s action in performing basic sorting operations using a custom sort
• Imitate the instructor’s action in performing basic filtering operations