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

AppendixAnswers to Review Questions

Chapter 1: Managing Worksheets and Workbooks

1. A, C. A text file uses a tab character as the delimiter, and a comma‐separated value file uses a comma as the delimiter.
2. B. Type the tilde (~) before the question mark to ensure that Excel finds text in cells with a question mark.
3. C. When you double‐click the right edge of the column within the header, such as to the right of the B column, Excel automatically adjusts the width to the text in a cell that has the greatest width.
4. B, D. You can only add tools and commands to the Quick Access Toolbar.
5. A, B, D. You can save to PDF format, text format, and HTML, which is the language used to create web pages.
6. A, D. The Quick Access Toolbar is in the title bar by default, ...