Midlands Microsoft Office Provider

Module 4 – Intro to Excel 2016

Module 4
​4.1 Practice Exercise 1; Basic Navigation in an Excel Worksheet

4.2 Practice Exercise 2; Basic Data Entry & Editing in an Excel Worksheet

4.2.1 Practice Exercises 3 and 4; Column Width/Row Height Adjustments

​4.2.2 Practice Exercise 5 and 6; Inserting and Deleting Columns & Rows

4.3 Practice Exercise 7; Apply Formatting Controls to Worksheet Data

​4.4 Practice Exercise 8; Use Formulas with AutoFill & AutoSum Features

​4.4.1 Practice Exercise 9; Use Absolute Referencing to Calculate %

​
Module 4 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned practice exercise step and/or observing the instructor’s video(s), at the end of the section the student will be able to:

  • Imitate the instructor’s action in basic navigation movements among the columns, rows, and cells on an Excel worksheet using a keyboard and a mouse (Practice Ex. 1)
  • Imitate the instructor’s action in data entry into a worksheet cell using a keyboard and observe the cell interaction with the formula bar (Practice Ex. 2)
  • Imitate the instructor’s action in adjustments to the worksheet’s column widths and row heights using a mouse (Practice Ex. 3)
  • Imitate the instructor’s action in adjustments to the worksheet’s column widths and row heights using icons on the Ribbon (Practice Ex. 4)
  • Imitate the instructor’s action in changes to recent steps made using the Undo and Redo icons on the Quick Access Toolbar (Practice Ex. 5)
  • Imitate the instructor’s action in insertion and deletion of columns on a worksheet using icons on the Ribbon (Practice Ex. 6)
  • Imitate the instructor’s action in insertion and deletion of columns on a worksheet using a mouse (Practice Ex. 6)
  • Imitate the instructor’s action in various cell formatting changes to data in worksheet cells using the Ribbon Font and Alignment sections (Practice Ex. 7)
  • Imitate the instructor’s action in entering the SUM, AVERAGE, MAX, MIN formulas with AutoFill & AutoSum features (Practice Ex. 8)
  • Imitate the instructor’s action in entering absolute referencing with formulas to calculate salesperson % of total quarterly sales (Practice Ex. 9)