Читать книгу MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide - Eric Butow - Страница 3

List of Illustrations

1 Chapter 1FIGURE 1.1 Navigation pane FIGURE 1.2 List of search results FIGURE 1.3 Find And Replace dialog box FIGURE 1.4 The Navigation Pane check box FIGURE 1.5 Hyperlink dialog box FIGURE 1.6 Go To tab FIGURE 1.7 Show/Hide ¶ icon FIGURE 1.8 Font dialog box FIGURE 1.9 Word Options dialog box FIGURE 1.10 Page Setup section FIGURE 1.11 Design ribbon theme tiles FIGURE 1.12 Styles pane FIGURE 1.13 Header & Footer menu FIGURE 1.14 Page Background section FIGURE 1.15 Save As screen FIGURE 1.16 Document properties list FIGURE 1.17 Print screen FIGURE 1.18 Share screen FIGURE 1.19 Document Inspector dialog box FIGURE 1.20 Accessibility panel FIGURE 1.21 Microsoft Word Compatibility Checker dialog box
2 Chapter 2FIGURE 2.1 First instance of the word “AutoFit” highlighted FIGURE 2.2 Find And Replace dialog box FIGURE 2.3 Symbol window FIGURE 2.4 Text Effects menu FIGURE 2.5 Format Painter icon FIGURE 2.6 Line And Paragraph Spacing menu FIGURE 2.7 Down arrow FIGURE 2.8 Menu with all style tiles FIGURE 2.9 Clear Formatting option FIGURE 2.10 More icon FIGURE 2.11 Columns menu FIGURE 2.12 Breaks icon FIGURE 2.13 Page Setup options FIGURE 2.14 Page Number menu FIGURE 2.15 Borders And Shading dialog box FIGURE 2.16 Built‐in footer style
3 Chapter 3FIGURE 3.1 The selected table cells FIGURE 3.2 Convert Text To Table dialog boxFIGURE 3.3 Insert Table menu optionFIGURE 3.4 Insert Table dialog boxFIGURE 3.5 Sort iconFIGURE 3.6 Sort dialog boxFIGURE 3.7 The reordered table rowsFIGURE 3.8 Double‐headed arrow iconFIGURE 3.9 Table Options dialog boxFIGURE 3.10 Merge Cells menu optionFIGURE 3.11 Split Cells dialog boxFIGURE 3.12 Table Row Height boxFIGURE 3.13 AutoFit drop‐down listFIGURE 3.14 Double‐headed arrow cursorFIGURE 3.15 Selected columnsFIGURE 3.16 Distribute Columns iconFIGURE 3.17 Cursor on third rowFIGURE 3.18 Split Table iconFIGURE 3.19 Repeat Header Rows iconFIGURE 3.20 Repeat At Header RowFIGURE 3.21 Bullets and Numbering iconsFIGURE 3.22 Bullet style tilesFIGURE 3.23 Number style tilesFIGURE 3.24 Define New Bullet dialog boxFIGURE 3.25 Define New Number Format dialog boxFIGURE 3.26 Change List Level menuFIGURE 3.27 Set Numbering Value menu optionFIGURE 3.28 Set Numbering Value dialog boxFIGURE 3.29 Continue Numbering optionFIGURE 3.30 Restart At 1 menu option
4 Chapter 4FIGURE 4.1 Insert Footnote optionFIGURE 4.2 Insert Endnote iconFIGURE 4.3 Pop‐up menu for changing the footnote styleFIGURE 4.4 Writing styles listFIGURE 4.5 Create Source dialog boxFIGURE 4.6 Citation drop‐down menuFIGURE 4.7 Added citation in drop‐down listFIGURE 4.8 TOC styles menuFIGURE 4.9 TOC styles in the Built‐In menuFIGURE 4.10 Bibliography styles
5 Chapter 5FIGURE 5.1 The shapes drop‐down listFIGURE 5.2 Pictures drop‐down menuFIGURE 5.3 Category tilesFIGURE 5.4 3D model category listFIGURE 5.5 SmartArt categoriesFIGURE 5.6 Screenshots drop‐down listFIGURE 5.7 Capture areaFIGURE 5.8 Text box stylesFIGURE 5.9 The effects tilesFIGURE 5.10 Offset: Center shadow style applied to the pictureFIGURE 5.11 Picture Styles sectionFIGURE 5.12 Removed backgroundFIGURE 5.13 Shape Format ribbonFIGURE 5.14 Picture Format ribbonFIGURE 5.15 Picture Format ribbonFIGURE 5.16 Designing an organizational chart using SmartArtFIGURE 5.17 The Rotate iconFIGURE 5.18 Text effects options in the WordArt Styles sectionFIGURE 5.19 Text appearance options in the Text sectionFIGURE 5.20 Shape Format ribbonFIGURE 5.21 Text in an organizational chartFIGURE 5.22 Layout Options menuFIGURE 5.23 Text Wrapping tab in Layout dialog boxFIGURE 5.24 Alt Text pane
6 Chapter 6FIGURE 6.1 A new commentFIGURE 6.2 The next commentFIGURE 6.3 Resolved commentFIGURE 6.4 Deleting a commentFIGURE 6.5 Track Changes iconFIGURE 6.6 Previous and Next optionsFIGURE 6.7 Markup drop‐down menuFIGURE 6.8 Accept menuFIGURE 6.9 Reject menuFIGURE 6.10 Track Changes drop‐down menuFIGURE 6.11 Unlock Password dialog box
7 Chapter 7FIGURE 7.1 Text Import Wizard dialog boxFIGURE 7.2 Get & Transform sectionFIGURE 7.3 Import Data dialog boxFIGURE 7.4 Preview dialog boxFIGURE 7.5 Find And Replace dialog boxFIGURE 7.6 The Define Name menu optionFIGURE 7.7 Go To dialog boxFIGURE 7.8 The Link iconFIGURE 7.9 The Insert Hyperlink dialog boxFIGURE 7.10 The Place In This Document menu optionFIGURE 7.11 A list of recently opened filesFIGURE 7.12 Browsed Pages listFIGURE 7.13 E‐mail Address menu optionFIGURE 7.14 Edit Hyperlink dialog boxFIGURE 7.15 The Remove Hyperlink option in the context menuFIGURE 7.16 Page Setup section optionsFIGURE 7.17 Column Width optionFIGURE 7.18 AutoFit Column Width optionFIGURE 7.19 Keep Source Column Widths iconFIGURE 7.20 Default Width optionFIGURE 7.21 The resize mouse pointer between two column headingsFIGURE 7.22 Row Height optionFIGURE 7.23 AutoFit Row Height optionFIGURE 7.24 The resize mouse pointer between two row headingsFIGURE 7.25 Header & Footer iconFIGURE 7.26 Header element drop‐down listFIGURE 7.27 Header & Footer Elements sectionFIGURE 7.28 Page Setup dialog boxFIGURE 7.29 The new icon in the Quick Access ToolbarFIGURE 7.30 Customize Quick Access Toolbar drop‐down menuFIGURE 7.31 The Quick Access Toolbar below the ribbonFIGURE 7.32 Reset button in Excel Options dialog boxFIGURE 7.33 Zoom dialog boxFIGURE 7.34 Custom Views iconFIGURE 7.35 Add View dialog boxFIGURE 7.36 The selected view in the list is at the top.FIGURE 7.37 Freeze Panes drop‐down menuFIGURE 7.38 Page Break Preview viewFIGURE 7.39 Page Layout viewFIGURE 7.40 Info screenFIGURE 7.41 Protect Sheet optionFIGURE 7.42 Protect Sheet dialog boxFIGURE 7.43 Set Print Area optionFIGURE 7.44 A partial list of file formatsFIGURE 7.45 Print screenFIGURE 7.46 Document Inspector dialog box
8 Chapter 8FIGURE 8.1 The Paste drop‐down menuFIGURE 8.2 Paste Special dialog boxFIGURE 8.3 Pop‐up box shows what value you will fill.FIGURE 8.4 Inserted columnsFIGURE 8.5 Inserted rowsFIGURE 8.6 Insert Sheet Columns menu optionFIGURE 8.7 Insert Sheet Rows menu optionFIGURE 8.8 Merge options in the drop‐down menuFIGURE 8.9 Align Left, Align Center, and Align Right iconsFIGURE 8.10 Orientation drop‐down menuFIGURE 8.11 Format Cells dialog boxFIGURE 8.12 Format Painter iconFIGURE 8.13 Wrap Text optionFIGURE 8.14 Number format optionsFIGURE 8.15 Format Cells optionFIGURE 8.16 Format Cells dialog boxFIGURE 8.17 Cell Styles drop‐down listFIGURE 8.18 Clear drop‐down listFIGURE 8.19 Define Name optionFIGURE 8.20 New Name dialog boxFIGURE 8.21 Create From Selection optionFIGURE 8.22 Create Names From Selection dialog boxFIGURE 8.23 Use In Formula drop‐down menuFIGURE 8.24 Highlighted table name in the Table Name BoxFIGURE 8.25 Highlighted table in the Name BoxFIGURE 8.26 The three Sparkline iconsFIGURE 8.27 The selected cell rangeFIGURE 8.28 Sparkline menu ribbonFIGURE 8.29 Quick Analysis iconFIGURE 8.30 Quick Analysis drop‐down menuFIGURE 8.31 Clear Rules From Entire Sheet optionFIGURE 8.32 Clear Rules From Selected Cells optionFIGURE 8.33 Go To Special dialog box
9 Chapter 9FIGURE 9.1 Table styles in the Format As Table drop‐down menuFIGURE 9.2 Format As Table dialog boxFIGURE 9.3 Highlighted default name in the New Table Style dialog boxFIGURE 9.4 Format Cells dialog boxFIGURE 9.5 Convert To Range menu optionFIGURE 9.6 Resize Table optionFIGURE 9.7 The reordered table rowsFIGURE 9.8 The Delete Table Rows and Delete Table Columns optionsFIGURE 9.9 Table Style Options section check boxesFIGURE 9.10 Total Row check boxFIGURE 9.11 Sum option in drop‐down menuFIGURE 9.12 Filter drop‐down menuFIGURE 9.13 The filtered table shows one row that contains the cell.FIGURE 9.14 Sort & Filter drop‐down menuFIGURE 9.15 Sort dialog box
10 Chapter 10FIGURE 10.1 Relative cell referenceFIGURE 10.2 Absolute cell referenceFIGURE 10.3 Mixed cell referenceFIGURE 10.4 Absolute reference in the Formula BarFIGURE 10.5 The formula in the Formula BarFIGURE 10.6 The average of all five numbersFIGURE 10.7 Average of five numbers in the cellFIGURE 10.8 The calculated MAX result in the cell and the formula in the For...FIGURE 10.9 The calculated MIN result in the cell and the formula in the For...FIGURE 10.10 The calculated SUM result in the cell and the formula in the Fo...FIGURE 10.11 The count result in the cell and the formula in the Formula Bar...FIGURE 10.12 The COUNTA results in the cell and the formula in the Formula B...FIGURE 10.13 The calculated COUNTBLANK result in the cell and formula in the...FIGURE 10.14 The FALSE result in the cell with the formula in the Formula Ba...FIGURE 10.15 The results of the formula in column RFIGURE 10.16 The last two letters in cell A4FIGURE 10.17 The first two letters in cell A6FIGURE 10.18 The three characters in cell A11FIGURE 10.19 All uppercase text in column CFIGURE 10.20 All lowercase text in column CFIGURE 10.21 Length in characters in column CFIGURE 10.22 Combined text with CONCAT() function in the Formula BarFIGURE 10.23 The combined text with spaces between each text string
11 Chapter 11FIGURE 11.1 The Recommended Charts icon in the Insert ribbonFIGURE 11.2 The Insert Chart dialog boxFIGURE 11.3 The Column category in the All Charts tabFIGURE 11.4 The chart in the worksheetFIGURE 11.5 Move Chart icon in the Chart Design ribbonFIGURE 11.6 Move Chart dialog boxFIGURE 11.7 The chart in a new tabFIGURE 11.8 The updated chart and expanded selection area in the tableFIGURE 11.9 Select Data Source dialog box and selected table cellsFIGURE 11.10 Updated chart in chart sheetFIGURE 11.11 Row titles in the horizontal axisFIGURE 11.12 Chart elements listFIGURE 11.13 Trend line for teddy bearsFIGURE 11.14 Excel previews the layout in the chart.FIGURE 11.15 Format ribbon sectionsFIGURE 11.16 Current Selection sectionFIGURE 11.17 Insert Shapes sectionFIGURE 11.18 Shape Styles sectionFIGURE 11.19 WordArt Styles sectionFIGURE 11.20 Arrange sectionFIGURE 11.21 Size sectionFIGURE 11.22 The preview of the style in the chartFIGURE 11.23 Six swatch colors in the selected swatch groupFIGURE 11.24 Alt Text pane
12 Chapter 12FIGURE 12.1 Slide Master option in the Master Views sectionFIGURE 12.2 Slide Master screenFIGURE 12.3 Theme tiles in the drop‐down listFIGURE 12.4 Background tiles in the drop‐down listFIGURE 12.5 Format Background paneFIGURE 12.6 Master Layout icon in the ribbonFIGURE 12.7 Master Layout dialog boxFIGURE 12.8 Insert Layout iconFIGURE 12.9 Eight content type options in the drop‐down menuFIGURE 12.10 Rename Layout dialog boxFIGURE 12.11 Delete icon in Slide Master ribbonFIGURE 12.12 Title and Footers check boxesFIGURE 12.13 Color scheme drop‐down listFIGURE 12.14 Font scheme drop‐down listFIGURE 12.15 Effects drop‐down listFIGURE 12.16 Hide Background Graphics check boxFIGURE 12.17 The Handout Master optionFIGURE 12.18 Handout Master ribbonFIGURE 12.19 Slides Per Page drop‐down listFIGURE 12.20 Color scheme drop‐down listFIGURE 12.21 Font schemes in the drop‐down listFIGURE 12.22 Effects drop‐down listFIGURE 12.23 Background tiles in the drop‐down listFIGURE 12.24 The Notes Master iconFIGURE 12.25 Notes Master ribbonFIGURE 12.26 Color scheme drop‐down listFIGURE 12.27 Font schemes in the drop‐down listFIGURE 12.28 Effects drop‐down listFIGURE 12.29 Background tiles in the drop‐down listFIGURE 12.30 Slide Size drop‐down listFIGURE 12.31 Slide Size dialog boxFIGURE 12.32 Icons in the Presentation Views sectionFIGURE 12.33 Info screenFIGURE 12.34 Print optionsFIGURE 12.35 Print Layout optionsFIGURE 12.36 Notes area below the slide on the pageFIGURE 12.37 Handouts section iconsFIGURE 12.38 Color settings listFIGURE 12.39 Custom Slide Show option in the ribbonFIGURE 12.40 Define Custom Show dialog boxFIGURE 12.41 The Link option in the drop‐down menuFIGURE 12.42 The Place In This Document icon in the Link To sectionFIGURE 12.43 Set Up Slide Show option in the ribbonFIGURE 12.44 Custom Show buttonFIGURE 12.45 Set Up Show dialog boxFIGURE 12.46 Rehearse Timings icon in the ribbonFIGURE 12.47 Recording dialog boxFIGURE 12.48 The time underneath Slide 1FIGURE 12.49 Manually buttonFIGURE 12.50 Clear Timing On Current Slide optionFIGURE 12.51 Record From Beginning optionFIGURE 12.52 Audio recording screenFIGURE 12.53 Playback barFIGURE 12.54 From Beginning iconFIGURE 12.55 Full Screen View controlsFIGURE 12.56 Presenter View screenFIGURE 12.57 Monitors area in the Slide Show ribbonFIGURE 12.58 Mark As Final optionFIGURE 12.59 Encrypt With Password optionFIGURE 12.60 Encrypt Document dialog boxFIGURE 12.61 Document Inspector dialog boxFIGURE 12.62 A new commentFIGURE 12.63 The next commentFIGURE 12.64 Deleting a commentFIGURE 12.65 Print Comments optionFIGURE 12.66 Preserve option and pushpin iconFIGURE 12.67 Export options on the Export screenFIGURE 12.68 Save As Type drop‐down listFIGURE 12.69 Video export optionsFIGURE 12.70 Save As Type drop‐down listFIGURE 12.71 Package For CD buttonFIGURE 12.72 Package For CD dialog boxFIGURE 12.73 Create Handouts buttonFIGURE 12.74 Send To Microsoft Word dialog boxFIGURE 12.75 Change File Type list
13 Chapter 13FIGURE 13.1 Slides From Outline option at the bottom of the drop‐down menuFIGURE 13.2 Insert Outline dialog boxFIGURE 13.3 The outline appears within the slide.FIGURE 13.4 Reuse Slides option at the bottom of the drop‐down menuFIGURE 13.5 The Browse button in the Reuse Slides paneFIGURE 13.6 The inserted slideFIGURE 13.7 Slide layout icons in the listFIGURE 13.8 The Summary Zoom optionFIGURE 13.9 Insert Summary Zoom dialog boxFIGURE 13.10 The Summary Zoom slide in the right paneFIGURE 13.11 The Duplicate Selected Slides optionFIGURE 13.12 The hidden slide in the left paneFIGURE 13.13 The Format Background optionFIGURE 13.14 The Format Background paneFIGURE 13.15 The Header & Footer iconFIGURE 13.16 The Notes And Handouts tabFIGURE 13.17 The Footer check boxFIGURE 13.18 The Slide Number check boxFIGURE 13.19 The Add Section optionFIGURE 13.20 Rename Section dialog boxFIGURE 13.21 The section title above the slideFIGURE 13.22 The selected slide in the left paneFIGURE 13.23 Rename Section optionFIGURE 13.24 Rename Section dialog box
14 Chapter 14FIGURE 14.1 Format Painter iconFIGURE 14.2 Line Spacing drop‐down menuFIGURE 14.3 Paragraph dialog boxFIGURE 14.4 Decrease List Level (left) and Increase List Level (right) icons...FIGURE 14.5 The Quick Styles drop‐down menuFIGURE 14.6 Clear All Formatting iconFIGURE 14.7 Add Or Remove Columns menuFIGURE 14.8 Bullets (left) and Numbering (right) iconsFIGURE 14.9 Insert Hyperlink dialog boxFIGURE 14.10 Selected Summary Zoom slideFIGURE 14.11 Insert Slide Zoom dialog boxFIGURE 14.12 Thumbnail‐sized slides within the Slide ZoomFIGURE 14.13 Selected Slide Zoom slideFIGURE 14.14 Pictures drop‐down menuFIGURE 14.15 Images dialog boxFIGURE 14.16 Shape Height (top) and Width (bottom) boxesFIGURE 14.17 The Crop menu optionFIGURE 14.18 The Crop icon in the Picture Format ribbonFIGURE 14.19 Quick Styles style tilesFIGURE 14.20 Offset: Center shadow style applied to the pictureFIGURE 14.21 Screenshots drop‐down listFIGURE 14.22 Capture areaFIGURE 14.23 The shapes drop‐down listFIGURE 14.24 The Draw ribbon and digital ink on the slideFIGURE 14.25 Edit Text optionFIGURE 14.26 The text box in the slideFIGURE 14.27 Height and Width boxesFIGURE 14.28 Height and Width boxes in the Size sectionFIGURE 14.29 Shape Format ribbonFIGURE 14.30 Font and Paragraph icons in the Home ribbonFIGURE 14.31 Shape Styles sectionFIGURE 14.32 Shape Styles drop‐down listFIGURE 14.33 WordArt Styles sectionFIGURE 14.34 Paragraph sectionFIGURE 14.35 Alt Text paneFIGURE 14.36 Drawing drop‐down list optionsFIGURE 14.37 Alignment optionsFIGURE 14.38 Group option in the drop‐down menuFIGURE 14.39 The ruler, gridlines, and guides
15 Chapter 15FIGURE 15.1 The selected table cellsFIGURE 15.2 Insert Table menu optionFIGURE 15.3 Insert Table dialog boxFIGURE 15.4 Insertion options in the Rows & Columns sectionFIGURE 15.5 Delete optionsFIGURE 15.6 Table style tilesFIGURE 15.7 The Chart icon in the Insert ribbonFIGURE 15.8 The Column category in the Insert Chart dialog boxFIGURE 15.9 The chart in the worksheetFIGURE 15.10 The selected chart entries in the spreadsheet windowFIGURE 15.11 The updated chart and expanded selection area in the spreadshee...FIGURE 15.12 Column titles in the horizontal axisFIGURE 15.13 Chart elements listFIGURE 15.14 Trendline for first quarter salesFIGURE 15.15 SmartArt option in the Insert ribbonFIGURE 15.16 SmartArt categoriesFIGURE 15.17 The Convert To SmartArt drop‐down listFIGURE 15.18 The Type Your Text Here boxFIGURE 15.19 Designing an organization chart using SmartArtFIGURE 15.20 3D model category listFIGURE 15.21 A 3D hat modelFIGURE 15.22 The Rotate icon in the 3D modelFIGURE 15.23 Audio On My PC menu optionFIGURE 15.24 The Insert button in the dialog boxFIGURE 15.25 The audio file in the slideFIGURE 15.26 Video On My PC menu optionFIGURE 15.27 The Insert button in the dialog boxFIGURE 15.28 The video file in the slideFIGURE 15.29 Record Audio menu optionFIGURE 15.30 Record Sound dialog boxFIGURE 15.31 The recorded audio file in the slideFIGURE 15.32 Screen Recording iconFIGURE 15.33 Control Dock boxFIGURE 15.34 The video recording and playback bar in the slideFIGURE 15.35 Playback ribbonFIGURE 15.36 The Playback ribbon for videos
16 Chapter 16FIGURE 16.1 The drop‐down list of transition effectsFIGURE 16.2 Preview iconFIGURE 16.3 Airplane transition in the drop‐down listFIGURE 16.4 The Left icon in the drop‐down listFIGURE 16.5 Animation styles in the drop‐down listFIGURE 16.6 By Paragraph at the bottom of the drop‐down listFIGURE 16.7 Animation PaneFIGURE 16.8 Effect Options in the drop‐down menuFIGURE 16.9 By Letter option in the Animate Text drop‐down menuFIGURE 16.10 The Wipe style in the drop‐down listFIGURE 16.11 One By One option in the Sequence sectionFIGURE 16.12 The Show Additional Effects Options iconFIGURE 16.13 The Wipe dialog boxFIGURE 16.14 Level 1 in the Animation PaneFIGURE 16.15 Remove option in the drop‐down menuFIGURE 16.16 The Turntable style in the drop‐down listFIGURE 16.17 The rotating scarf with the Turntable effect appliedFIGURE 16.18 Animation effect options for the Turntable styleFIGURE 16.19 Effect Options menu optionFIGURE 16.20 Wipe dialog boxFIGURE 16.21 The Turns motion path in the drop‐down listFIGURE 16.22 The truncated graphic in the slideFIGURE 16.23 Effect Options drop‐down menuFIGURE 16.24 The Duplicate Selected Slides optionFIGURE 16.25 The Morph icon in the ribbonFIGURE 16.26 Effects drop‐down menuFIGURE 16.27 Animation marker on the slideFIGURE 16.28 The Duration boxFIGURE 16.29 After check box in the Transitions ribbon

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

Подняться наверх