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

Learning Outcomes

In this lab, you will complete the following exercise:

• Exercise 1 – Finding Data in a Workbook
• Exercise 2 – Filtering Records in a Table
• Exercise 3 – Paste Data
• Exercise 4 – Working with Formulas
• Exercise 5 – Working with Cell References
• Exercise 6 – Using Mathematical Functions
• Exercise 7 – Count Cells Using the COUNT(), COUNTA() and COUNTBLANK() Functions
• Exercise 8 – Performing Conditional Operations Using the IF() Function
• Exercise 9 – Formatting Text by Using Text Functions
• Exercise 10 – Creating Charts and Chart Sheets

After completing this lab, you will be able to:

• Use find and replace feature.
• Use AutoFilter.
• Filter a table using complex criteria.
• Paste data using Paste Special options.
• Perform calculations with formulas.
• Control the order of operations.
• Insert relative references.
• Use an absolute reference in a formula.
• Use functions to calculate sums and averages.
• Insert a function.
• Use the COUNT(), COUNTA(), and COUNTBLANK() functions.
• Use IF() function to determine sales commissions.
• Format text by Using RIGHT(), LEFT(), LEN(), and MID() functions.
• Format text by Using CONCATENATE() and TEXTJOIN() functions.
• Create a pie chart.
• Create a line chart.
• Create a chart sheet.

Exam Objectives

The following exam objectives are covered in this lab:

• Search for data in a workbook
• Use filters
• Paste data into a workbook
• Manipulate data using basic formulas and functions
• Create charts