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

Chapter 3Working 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 that make your data easier to work with.

I start this chapter by showing you how to create a table and how ...