Module 1 – Intermediate Excel 2016

Module 1
​1.1 Formatting Numbers
1.2 How Excel Processes Large Numbers
1.3 Format Cells – Number Tab
1.4 Format Cells – Alignment Tab
1.5 Format Cells – Font Tab
1.6 Format Cells – Border Tab
1.7 Format Cells – Fill Tab
​​1.8 Format Cells – Protection Tab
Module 1 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 video(s), at the end of the module the student will be able to:

  • Identify the major categories of data shown in the study guide and directed by the instructor
  • Identify the three categories of formatting; General, Number, and Text, as shown in the study guide and directed by the instructor
  • Imitate the instructor’s action in applying General, Number, and Text formatting to cells (Practice Ex 1)
  • Identify three ways to access the Format Cells dialog box as shown in the study guide and directed by the instructor
  • Identify the various tabs used in the Format Cells dialog box including: Number, Alignment, Font, Border, Fill, and Protection.
  • Imitate the instructor’s action in performing basic operations using the Format Cells tabs including: Number, Alignment, Font, Border, Fill, and Protection