MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide. Eric Butow
Читать онлайн книгу.
rel="nofollow" href="#ue0492e88-bdbf-5a24-9e96-54e7aed0fc0b">Chapter 1 for more information.
10 C. You need to add the source to a document so that Word can find it and cite it. See Chapter 4 for more information.
11 B. You can sort by text, number, and date in a table column. See Chapter 3 for more information.
12 D. Track Changes adds information to your document so that you can see the changes that reviewers have made. See Chapter 6 for more information.
13 B. Word allows you to convert a Word document after you click File ➢ Share ➢ Send Adobe PDF For Review. See Chapter 1 for more information.
14 B, C. You can scroll through the document, or you can click the Previous and Next icons in the Review menu ribbon. See Chapter 6 for more information.
15 C. SmartArt is a set of custom diagrams, including organizational charts, which you can add and edit quickly. See Chapter 5 for more information.
16 C. You can add bulleted and numbered lists in a variety of styles. See Chapter 3 for more information.
17 B. You select all text in a document quickly by pressing Ctrl+A. See Chapter 2 for more information.
18 D. Word adds text with Heading styles as entries in a table of contents. See Chapter 4 for more information.
19 A, D. Text Fill and Text Outline are two WordArt styles that you can apply. See Chapter 5 for more information.
20 B. You may need to have the numbered list continue from the entry in the previous list, or you may need the second numbered list reset to 1. You can do both in Word. See Chapter 3 for more information.
21 C. When you wrap an object in line with text, the object is added to the document at the cursor point. See Chapter 5 for more information.
22 C. The Document Inspector checks your document to ensure that people of all abilities and Word versions can open and read your document. See Chapter 1 for more information.
23 A. Word assigns colors to each reviewer automatically. See Chapter 6 for more information.
24 D. A next page break ends the current section and creates a new section on the next page. See Chapter 2 for more information.
25 B. Alt text attaches descriptive information that appears when the user moves the mouse over the object. See Chapter 5 for more information.
26 B, D. Each cell in the header row contains a button that allows you to sort and filter data in the column. See Chapter 9 for more information.
27 C. Press Ctrl+C to copy all the information in one cell into an empty cell. See Chapter 8 for more information.
28 B, C. You can add a legend, a data table, as well as data labels to a chart to help you and others understand what the chart represents. See Chapter 11 for more information.
29 A, B, D. Excel can create relative, absolute, and mixed reference types in a cell formula. See Chapter 10 for more information.
30 B, C. You can import files with the TXT and CSV formats into an Excel workbook. See Chapter 7 for more information.
31 A, C. You can click on various elements within the chart. When you click the down arrow next to the Chart Area box in the Format ribbon, you see a drop‐down list with all of the chart elements so that you can select an element easily. See Chapter 11 for more information.
32 C. When you click Vertical Text in the Orientation drop‐down menu in the Home ribbon, Excel makes the text vertical, but it does not change the orientation so that each letter in the text appears in a separate line. See Chapter 8 for more information.
33 B. The SUM() function summarizes all selected cells that have numbers in them. See Chapter 10 for more information.
34 C. When you click the Within box, which shows the default Sheet option, a drop‐down list appears so that you can select the Workbook option. See Chapter 7 for more information.
35 D. The LEFT() function tells Excel to read the first few characters of text and show that text in a new cell. See Chapter 10 for more information.
36 A, C. You can hide and show the header row in a table as well as filter buttons within a header row. See Chapter 9 for more information.
37 D. Naming a range of cells helps you find groups of cells in the same worksheet or a different worksheet in a workbook. See Chapter 8 for more information.
38 B. The default row height is 15 points. See Chapter 7 for more information.
39 D. The COUNTA() function counts cells in the selected range that are not empty, and the COUNT() function tells you how many cells have numbers. See Chapter 10 for more information.
40 A. You can move a chart to a separate worksheet, which Excel calls a chart sheet. See Chapter 11 for more information.
41 C. You need to create a custom sort so that you can decide if you want to sort first by text or by number. See Chapter 9 for more information.
42 B. A Sparkline chart summarizes all of the numerical data in other columns within a row. See Chapter 8 for more information.
43 C. The TEXTJOIN() function adds a delimiter of your choosing, including a space, between text in two or more cells that you combine with TEXTJOIN() . See Chapter 10 for more information.
44 B, C. An error bar can show both a margin of error and standard deviation. See Chapter 11 for more information.
45 A, C, D. You can change the font, border, and the fill color and/or pattern in the style. See Chapter 9 for more information.
46 C. Two of the built‐in