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

Chapter 9Working with Tables and Table Data

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Manage tables and table data
  • Create and format tables
    • Create Excel tables from cell ranges
    • Apply table styles
    • Convert tables to cell ranges
  • Modify tables
    • Add or remove table rows and columns
    • Configure table style options
    • Insert and configure total rows
  • Filter and sort table data
    • Filter records
    • Sort data by multiple columns

It may sound strange to talk about tables in an Excel spreadsheet. After all, isn't a worksheet just one giant table? Actually, a table in Excel is a specific object that contains a number of additional features ...