Microsoft Excel Fundamentals - Part 1 (PLAB-DIG-LIT)

Learning Outcomes

In this lab, you will complete the following exercise:

• Exercise 1 – Worksheet and Workbook Navigation
• Exercise 2 – Modifying Row Height and Column Width
• Exercise 3 – Configuring Print Settings
• Exercise 4 – Inserting and Deleting Cells
• Exercise 5 – Formatting Cells
• Exercise 6 – Formatting Cells Using Format Painter
• Exercise 7 – Working with Excel Tables
• Exercise 8 – Formatting Excel Tables

After completing this lab, you will be able to:

• Create a blank workbook and navigate around cells in a worksheet.
• Use the Go To feature and navigate to a named range.
• Adjust row height and column width.
• Print worksheet/s or an entire workbook.
• Change page orientation and page margins.
• Change scaling options and paper size of the printed page.
• Print copies of the worksheets/workbook.
• Insert and delete cells in a worksheet.
• Apply number formats.
• Apply cell formats from the format cells dialog box.
• Clear cell formatting.
• Apply cell styles.
• Paint a format from one range onto another.
• Paste formats or values.
• Convert a cell range to an Excel table.
• Apply a new table style and clear the existing formatting.
• Convert an Excel table to a cell range.
• Configure table style options.
• Add or remove table rows and columns.

Exam Objectives

The following exam objective are covered in this lab:

• Navigate Excel.
• Print a workbook.
• Adjust row height and column width.
• Insert and delete cells.
• Format cells.
• Clear cell formatting.
• Create a table.