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

Chapter 2Using Data Cells and Ranges

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Manage data cells and ranges
  • Manipulate data in worksheets
    • Paste data by using special paste options
    • Fill cells by using Auto Fill
    • Insert and delete multiple columns or rows
    • Insert and delete cells
  • Format cells and ranges
    • Merge and unmerge cells
    • Modify cell alignment, orientation, and indentation
    • Format cells by using Format Painter
    • Wrap text within cells
    • Apply number formats
    • Apply cell formats from the Format Cells dialog box
    • Apply cell styles
    • Clear cell formatting
  • Define and reference named ranges
    • Define a named range
    • Name a table
  • Summarize data visually
    • Insert Sparklines
    • Apply built‐in conditional formatting
    • Remove conditional formatting