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

Chapter 1Managing Worksheets and Workbooks

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Manage worksheets and workbooks
  • Import data into workbooks
    • Import data from .txt files
    • Import data from .csv files
  • Navigate within workbooks
    • Search for data within a workbook
    • Navigate to named cells, ranges, or workbook elements
    • Insert and remove hyperlinks
  • Format worksheets and workbooks
    • Modify page setup
    • Adjust row height and column width
    • Customize headers and footers
  • Customize options and views
    • Customize the Quick Access toolbar
    • Display and modify workbook content in different views
    • Freeze worksheet rows and columns
    • Change window views
    • Modify basic workbook properties
    • Display formulas
  • Configure content for collaboration
    • Set a print ...