MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide

Table of Exercises

• Exercise 1.1 Importing Text and CSV Format Files
• Exercise 1.2 Navigating in a Workbook
• Exercise 1.3 Formatting a Workbook
• Exercise 1.4 Changing Workbook Properties and Views
• Exercise 1.5 Changing Print Settings and Inspecting a Workbook
• Exercise 2.1 Manipulating Data
• Exercise 2.2 Formatting Cells and Ranges
• Exercise 2.3 Define and Reference Named Ranges
• Exercise 2.4 Summarizing Data Visually
• Exercise 3.1 Creating a Table
• Exercise 3.2 Modifying a Table
• Exercise 3.3 Filtering and Sorting Your Table Data
• Exercise 4.1 Inserting References
• Exercise 4.2 Calculate and Transform Datas
• Exercise 4.3 Formatting and Modifying Text
• Exercise 5.1 Creating Charts
• Exercise 5.2 Modifying Charts
• Exercise 5.3 Formatting Charts