- A
- absolute cell references, 304–307
- accepting tracked changes, 159–161
- accessibility
- adding Alt text to charts for, 366–368
- finding and fixing, 28–29
- Accessibility panel, 28–29
- Accessibility section, 362
- Accounting Number Format icon, 253
- action button, 519
- Add Trendline dialog box, 354
- Add View dialog box, 213
- adding
- Alt text around objects, 146–147
- Alt text for accessibility, 532–533
- Alt text to charts, 366–368
- Alt text to shapes, 532–533
- bibliographies, 112–113
- built‐in footer elements, 202–205
- built‐in header elements, 202–205
- cells, 242–244
- chart elements, 556–558
- columns, 242–243
- columns to tables, 284, 287–288
- comments to presentations, 441–446
- from Customize Quick Access Toolbar menu, 208–209
- data series to charts, 348–351, 554
- dates to Sparklines, 268–269
- footers, 201–202
- headers, 201–202
- line breaks, 251–252
- motion paths to animations, 612–614
- Picture Effects, 129–130, 514–515
- pictures, 120–121
- placeholder areas to presentations, 385–387
- rows to tables, 284, 287–288
- screen clippings, 124–125
- screenshots, 123–124
- ScreenTips, 184
- shapes, 118–119
- SmartArt content, 563–564
- SmartArt graphics, 122–123
- sounds to transitions, 594–595
- Sparklines, 265–266
- Advanced Find, 37
- AIFF audio file, 569
- aligning
- charts in worksheets, 363–364
- columns, 246–247
- images, 535–537
- rows, 246–247
- text box text, 139
- Alt text
- adding around objects, 146–147
- adding to shapes for accessibility, 532–533
- in charts, 366–368
- alternative file formatting, saving documents in, 20–21
- animations
- about, 590, 596, 622
- adding motion paths, 612–614
- applying, 606–608
- configuring effects, 609–611
- configuring paths, 612–617
- creating morph transitions, 615–616
- editing morph transitions, 616–617
- editing motion paths, 614
- exam essentials, 623
- exercises, 618–619
- graphic elements, 596–606
- modifying effects, 608–609
- removing, 605–606
- reordering on slides, 617–618
- reversing order of, 603–605
- review questions and answers, 624–625, 638
- for slides, 596–619
- SmartArt, 601–606
- text, 596–606
- 3D models, 606–609
- answers, to Assessment Test, xl–xliv. See also review questions and answers
- applying
- animations, 606–608
- artistic effects, 127–128
- basic transitions, 590–592
- built‐in conditional formatting, 269–271
- built‐in styles to effects and images, 513–515
- built‐in styles to shapes, 529–530
- built‐in styles to tables, 548–550
- built‐in styles to text, 499–500
- cell formatting from Format Cells dialog box, 253–254
- custom views, 214
- formatting user Format Painter, 496–497
- Picture Styles to images, 513–514
- slide master themes to presentations, 380–381
- style settings to documents, 15–17
- styles to cells, 254–256
- styles to charts, 364–366
- styles to tables, 282–283
- styles to text, 495–501
- 3D transitions, 590–592
- WordArt styles to shapes, 530–531
- Arrange section, 362–363
- artistic effects, applying, 127–128
- ascending sort, 296–297
- Assessment Test, xxviii–xliv
- asterisk (*), 180
- AU audio file, 569
- audio narration, 427–429, 430
- Audio Options option, 582
- audio recordings
- editing, 581–583
- inserting, 568–576
- playing, 429–430
- recording, 577–579
- removing, 429–430
- supported formats for, 569
- Audio Styles option, 583
- Auto Fill feature, filling cells using, 238–239
- AutoFit feature
- average
- of cells, 310
- defined, 310
- of numbers, 310–312
- using for different criteria, 312–314
-
AVERAGE()
function, 310–314
-
AVERAGEIF()
function, 312–314
-
AVERAGEIFS()
function, 312–314
- axes, in charts, 556
- axis titles, 353, 557
- B
- Background icon, 192
- Background option, 398–399, 404–405
- backgrounds
- modifying for slides, 477–479
- picture, 131–132
- basic transitions, applying, 590–592
- Behind Text text style, 145
- bibliographies
- adding, 112–113
- creating sources, 104–105
- inserting citations, 107–109
- modifying sources, 106–107
- black and white, printing presentations in, 415–416
- blog posts, sharing documents via, 25
- Bookmarks option, 582
- borders, 19, 53
- Breaks icon, 192
- built‐in conditional formatting, applying, 269–271
- built‐in styles
- applying to effects, 513–515
- applying to images, 513–515
- applying to shapes, 529–530
- applying to tables, 548–550
- applying to text, 499–500
- in documents, 46–47
- bullet characters
- changing, 86–88
- custom, 88–90
- bulleted lists, 85, 502–504
- Bullets icon, 86
- Butow, Eric (author), contact information for, xxii
- C
- calculating data, 310–324
- CD‐R, packaging slideshows to save to, 451–452
- CD‐RW, packaging slideshows to save to, 451–452
- cells
- about, 62, 234
- adding, 242–244
- applying formatting from Format Cells dialog box, 253–254
- applying styles, 254–256
- average of, 310
- clearing formatting, 256–258
- configuring margins, 70–73
- configuring spacing, 71
- counting, 317–321
- filling using Auto Fill feature, 238–239
- formatting, 245–258
- merging, 73–75, 245–246
- modifying alignment of, 246–249
- modifying indentation, 246–249
- modifying orientation, 246–249
- naming, 258–260
- navigating to, 180–181
- removing, 242–244
- removing styles from data, 256
- review questions and answers, 277–278, 632–633
- rotating text in, 249
- setting width of, 72
- splitting, 73–75
- styles, 254–256
- unmerging, 245–246
- using mouse in, 71–72
- wrapping text within, 250–252
- chart sheets, 344–348, 350–351
- Chart Wizard, 342
- charts
- about, 342, 544, 584–585
- adding Alt text, 366–368
- adding data series, 348–351, 554
- adding elements of, 556–558
- aligning in worksheets, 363–364
- applying styles, 364–366
- creating, 342–348, 551–554
- exam essentials, 585–586
- exercises, 559
- formatting, 355–368
- inserting, 551–559
- modifying, 348–355, 551–559
- modifying elements of, 556–559
- resizing, 554
- review questions and answers, 370–371, 587–588, 634–635, 637–638
- switching between rows and columns in source data, 554–556
- titles for, 557
- using layouts, 356–364
- citations (bibliographies)
- creating sources, 104–105
- defined, 100
- editing, 106–107
- inserting, 107–109
- modifying sources, 106–107
- clearing
- cell formatting, 256–258
- conditional formatting in ranges, 272–273
- conditional formatting in worksheets, 272
- text formatting, 500–501
- Close Master View option, 399, 405
- collaboration
- configuring content for, 222–228
- preparing presentations for, 436–456
- color
- pages, 19
- printing presentations in, 415–416
- color scheme, 15
- Colors option, 390, 396–397, 402–403
- column breaks, inserting, 52–53
- columns
- about, 545–548, 554–556
- adding, 242–243
- adding in tables, 284, 287–288
- aligning, 246–247
- column breaks, 50–53
- creating sections on pages, 50–51
- creating tables by specifying, 66–67
- deleting multiple, 240–242
- formatting text in multiple, 50–51
- freezing, 214–216
- inserting multiple, 240–242
- modifying width, 192–200
- removing, 242–243
- removing from tables, 284–288
- resizing in tables, using AutoFit, 75
- sizing multiples in tables, 79–80
- sorting data by multiple, 296–298
- switching rows and, in source data, 351–352
- in tables, 62
- unfreezing, 216
- Comma Style icon, 253
- comma‐delimited value (CSV) format
- defined, 172
- importing data from, 174–177
- inserting files into worksheets, 176–177
- commands, removing from Quick Access Toolbar, 209
- comments. See also Track Changes
- adding to presentations, 441–446
- defined, 152
- deleting, 155–156
- inserting, 152–153
- managing in presentations, 441–446
- moving to next, 154
- replying to, 153–154
- resolving, 154–155
- reviewing, 153–154
- compatibility issues, locating and correcting, 29–30
-
CONCAT()
function, 333–334
- conditional formatting
- clearing in ranges, 272–273
- clearing on worksheets, 272
- removing, 271–274
- conditional operations, performing, 320–324
- configuring
- animation effects, 609–611
- animation paths, 612–617
- cell margins in tables, 70–73
- cell spacing in tables, 70–73
- content for collaboration, 222–228
- effects for animations, 609–611
- margins of cells, 70–73
- media playback options, 581–584
- page background elements, 18–19
- paths for animations, 612–617
- playback options for media, 581–584
- print area, 223–224
- print settings, 224–225, 411–416
- repeating headers in tables, 82–84
- slideshows, 417–436, 422–423
- table style options, 288–289
- total rows, 289–292
- content, configuring for collaboration, 222–228
- Continue Numbering option, 93
- controls (Presenter View), 433
- conventions, for naming cells, 260
- Convert Table to Text dialog box, 67
- Convert Text to Table dialog box, 65
- converting
- lists to SmartArt, 560–563
- tables to cell ranges, 283–284
- text to tables, 64–65
- copying hyperlinks, 187–188
-
COUNT()
function, 318–319
-
COUNTA()
function, 319–320
-
COUNTBLANK()
function, 320
- counting cells, 317–321
- Create Names From Selection dialog box, 261
- creating
- bulleted lists, 502–504
- chart layouts, 357–363
- chart styles, 365–366
- charts, 342–348, 551–554
- column sections on pages, 50–51
- custom hyperlinked slideshows, 419–420
- custom slideshows, 417–421
- custom sorts, 296–298
- custom views, 212–213
- handouts, 452–454
- lists, 85–95, 85–95
- lists from existing text, 86
- morph transitions, 615–616
- numbered lists, 502–504
- screen recordings, 576–581
- slide layouts for presentations, 384–389
- slide sections, 484–486
- sources for bibliographies, 104–105
- sources for citations, 104–105
- tables, 62–68, 280–284, 544–545
- tables by specifying columns, 66–67
- tables by specifying rows, 66–67
- tables from cell ranges, 280–281
- cropping images, 512–513
- Current Date icon, 204
- Current Selection section, 358
- Current Time icon, 204
- Custom Range option, 412
- customizing
- footers, 200–206
- headers, 200–206
- options, 206–222
- Quick Access toolbar, 207–211
- table of contents (TOC) style, 110–111
- views, 206–222
- D
- data
- calculating, 310–324
- importing into workbooks, 172–177
- manipulating in worksheets, 234–244
- removing cell styles from, 256
- searching for within workbooks, 178–180
- summarizing visually, 265–274
- tables (See tables)
- transforming, 310–324
- data labels, 353, 557
- data series, adding to charts, 348–351, 554
- dates, adding to Sparklines, 268–269
- default settings, resetting Quick Access Toolbar to, 210–211
- Define New Bullet dialog box, 89
- Define New Number Format dialog box, 90
- defining named ranges, 258–263
- deleting
- animations, 605–606
- audio narration, 430
- audio recordings, 429–430
- columns from tables, 545–548
- comments, 155–156, 155–156, 444–445
- custom views, 214
- footers, 205–206
- headers, 205–206
- hyperlinks, 189–190
- layouts for presentations, 388–389
- multiple columns, 240–242
- multiple rows, 240–242
- rows, 243–244
- rows from tables, 545–548
- slideshow timing, 426
- Sparkline charts, 268
- delimiter, 172
- descending sort, 296–297
- Design menu, 15–16
- designing slide masters for presentations, 378
- digital ink, drawing shapes using, 520–522
- disabling AutoFit, 78
- displaying
- alignment tools for images, 538–539
- content in workbooks, 211–214
- formatting symbols, 10–11
- formulas, 219–222
- hidden slides during presentations, 477
- hidden text, 11–13
- presentations in different views, 408–410
- Styles list pane, 47
- workbook content, 211–214
- Distribute Columns icon, 80
- Document Inspector dialog box, 26–27, 226–228
- documents
- about, 30–31
- applying style settings, 15–17
- exam essentials, 31–32
- formatting, 13–20
- hyperlink base, 22
- inspecting for issues, 26–30
- linking to locations within, 8–9
- modifying properties, 21–23
- moving to locations in, 9
- navigating within, 4–13
- personal information, 26–28
- review questions and answers, 33–34, 628
- saving, 20–26
- setting up pages, 14–15
- sharing, 20–26
- sharing electronically, 24–25
- drawing shapes using digital ink, 520–522
- duplicating slides, 474–475
- E
- Edit Hyperlink dialog box, 188
- editing
- animation motion paths, 614
- audio clips, 581–583
- audio recordings, 581–583
- citations, 106–107
- morph transitions, 616–617
- motion paths for animations, 614
- Editing option, 582
- effects
- about, 15
- artistic, 127–128
- configuring for animations, 609–611
- modifying for animations, 608–609
- picture, 129–130
- setting duration of, for transitions, 619–620
- transition, 592–595
- Effects option, 392, 398, 404
- email
- hyperlinks to addresses, 186–187
- sharing documents via, 24
- endnotes
- defined, 100
- inserting, 100–103
- properties, 103
- enlarging Sparkline charts, 267
- error bars, 353, 557
- Esc key, 423
- exam essentials
- animations, 623
- charts, 585–586
- documents, 31–32
- graphic elements, 148
- images, 540
- lists, 96
- media, 585–586
- presentations, 457–458
- references, 114
- shapes, 540
- slides, 490
- SmartArt, 585–586
- tables, 96, 585–586
- text, 57
- text boxes, 540
- 3D models, 585–586
- transitions, 623
- users, 165
- exercises
- adding Alt text, 147
- adding bibliographies, 113
- adding table of contents (TOC), 113
- adding text to shapes/graphics, 142
- animating slide content, 618–619
- animations, 618–619
- applying and configuring slide transitions, 596
- Calculate and Transform Data, 324
- changing file types, 26
- changing paragraph format, 49
- changing presentation options/views, 411
- Changing Print Settings and Inspecting a Workbook, 228
- Changing Workbook Properties and Views, 221–222
- charts, 559
- checking out documents, 30
- configuring and presenting slideshows, 436
- configuring print settings for presentations, 416
- Creating a Table, 284
- Creating Charts, 346–347
- creating tables, 67–68
- Define and Reference Named Ranges, 264–265
- deleting comments, 156
- Filtering and Sorting Your Table Data, 298
- finding text, 41
- Formatting a Workbook, 206
- Formatting and Modifying Text, 336
- Formatting Cells and Ranges, 258
- Formatting Charts, 368
- formatting graphics, 137
- formatting lists, 95
- formatting pictures, 137
- formatting text, 504
- images, 518, 539
- Importing Text and CSV Format Files, 177
- inserting and formatting graphic elements, 534
- inserting and formatting images, 518
- inserting and formatting SmartArt graphics, 565
- inserting and formatting tables, 550
- inserting and managing media, 584
- inserting and modifying 3D models, 568
- inserting and modifying charts, 559
- inserting citations, 108–109
- inserting comments, 156
- inserting footnotes, 108–109
- inserting graphics, 127
- inserting links, 509
- Inserting References, 309
- inserting sections, 55
- inserting shapes, 127
- inserting slides, 475
- inserting sources, 108–109
- Manipulating Data, 244
- media, 584
- Modifying a Table, 292
- Modifying Charts, 355
- modifying Handout Masters, 406
- modifying Note Masters, 406
- modifying Slide Masters, 406
- modifying slides, 483–484
- modifying tables, 84–85
- modifying text, 13
- Navigating in a Workbook, 190
- navigating text, 13
- ordering and grouping objects on slides, 539
- ordering and grouping slides, 489
- positioning graphics, 147
- preparing presentations for collaboration, 456
- presentations, 406, 411, 416, 436, 456
- replacing text, 41
- replying to comments, 156
- setting timing for transitions, 622
- setting up documents, 20
- shapes, 534, 539
- sharing documents, 26
- slides, 475, 483–484, 489
- SmartArt, 565
- Summarizing Data Visually, 274
- tables, 550
- text, 13
- text boxes, 539
- 3D models, 568
- Track Changes, 164
- transitions, 622
- exporting
- to PDF documents, 447–448
- presentations to other formats, 447–456
- slideshows as video recordings, 449–451
- to XPS documents, 447–448
- F
- fax, 25
- file formats
- changing, 454–456
- saving workbooks in other, 224
- File Name icon, 205
- File Path icon, 205
- file properties, setting for presentations, 410–411
- files, hyperlinks to existing, 185
- filling cells, using Auto Fill feature, 238–239
- filtering
- records, 292–295
- table data, 292–298
- Find and Replace dialog box, 6–7, 37, 38–39, 178
- finding text
- about, 36–37
- Advanced Find, 37
- case, 38
- Find and Replace dialog, 37
- prefixes/suffixes, 39
- punctuation, 39
- using Home ribbon, 36
- whole words, 38
- wildcards, 39
- Flashcards, xxiv
- fonts, 15
- Fonts option, 391–392, 397, 403–404
- Footer check box (Slide Master ribbon), 389
- footers
- customizing, 200–206
- inserting in documents, 17–18
- inserting in slides, 481–482
- modifying, 17–18
- footnotes
- defined, 100
- inserting, 100–103
- properties, 103
- Format As Table dialog box, 281
- Format Cells dialog box, 253–254, 282–283
- Format Painter
- about, 43
- applying formatting using, 496–497
- formatting cells using, 249–250
- Format Picture icon, 205
- formats, exporting presentations to other, 447–456
- formatting
- alternative, 20–21
- applying to text, 495–501
- cells, 245–258
- cells using Format Painter, 249–250
- charts, 355–368
- clearing from cells, 256–258
- clearing from documents, 47–49
- clearing in text, 500–501
- documents, 13–20
- Format Painter, 43
- images, 133, 509–518
- lists, 85–95
- number formatting, 86–90
- numbers, 252–253
- paragraphs, 42–49
- ranges, 245–258
- screen clippings, 134
- screenshots, 134
- shapes, 518–534
- Sparkline charts, 267–268
- tables, 280–284, 544–550
- text, 42–49, 325–336, 495–504
- text boxes, 528
- in text files, 174
- text in formulas, 325–336
- text in multiple columns, 50–51, 501–502
- workbooks, 190–206
- worksheets, 190–206
- formatting symbols, 10–11
- Formula Bar, 220–221, 304
- formulas
- about, 304
- calculating data, 310–324
- displaying, 219–222
- formatting text, 325–336
- hiding in Formula Bar, 220–221
- inserting references, 304–309
- modifying text, 325–336
- referencing named ranges in, 307–309
- referencing named tables in, 307–309
- review questions and answers, 338–339, 634
- transforming data, 310–324
- using names in, 262–263
- freezing columns/rows, 214–216
- Full HD (1080p), 449
- functions. See also specific functions
- about, 304
- calculating data, 310–324
- formatting text, 325–336
- inserting references, 304–309
- modifying text, 325–336
- review questions and answers, 338–339, 634
- transforming data, 310–324
- G
- Glossary, online, xxiv
- Go To dialog box, 180, 181
- Gradient Fill button, 478
- graphic elements
- about, 118, 148
- adding Alt text around objects, 146–147
- adding picture effects, 129–130
- adding picture styles, 130–131
- adding pictures, 120–121
- adding screen clippings, 124–125
- adding screenshots, 123–124
- adding shapes, 118–119
- adding SmartArt graphics, 122–123
- adding text, 137–142
- applying artistic effects, 127–128
- exam essentials, 148
- formatting, 132–134
- formatting illustrations/text boxes, 127–137
- formatting pictures, 133
- formatting screen clippings, 134
- formatting screenshots, 134
- formatting shapes, 132
- inserting 3D models, 121–122
- inserting illustrations, 118–127
- inserting text boxes, 125–126
- modifying, 142–147
- organizing text, 137–142
- placing for easy reading, 146
- positioning objects, 142–143
- removing picture backgrounds, 131–132
- review questions and answers, 149–150, 630–631
- rotating 3D models, 136
- setting up SmartArt graphics, 134–136
- wrapping text around objects, 143–146
- grave ('), 219
- grayscale, printing presentations in, 415–416
- gridlines, 354, 558
- grouping
- H
- Handout Master, modifying, 393–399, 406
- Handout Orientation option (Handout Master menu ribbon), 394, 395
- handouts
- creating, 452–454
- inserting headers on slides, 480–481
- printing for presentations, 414–415
- hardware, requirements for, xxi
- Header & Footer Elements section, 203–205
- Header & Footer icon, 201
- Header & Footer menu, 17–18
- Header & Footer section, 202–203
- headers
- configuring repeating, in tables, 82–84
- customizing, 200–206
- inserting in documents, 17–18
- inserting in slides, 480–481
- modifying, 17–18
- hidden properties, locating and removing from documents, 26–28
- hidden text, 4, 11–13
- Hide Background Graphics option, 392–393, 399, 405
- hiding
- formatting symbols, 10–11
- formulas in Formula Bar, 220–221
- hidden text, 11–13
- slides, 476–477
- highlighting text, 37
- Home ribbon
- finding text, 36
- indenting, 45
- paragraph spacing, 44
- Styles area, 46
- hyperlink base, 22
- hyperlinked slideshows, creating custom, 419–420
- hyperlinks
- copying, 187–188
- deleting, 189–190
- to email addresses, 186–187
- to existing files, 185
- inserting, 182–190, 504–509
- modifying, 188–189
- moving, 187–188
- removing, 182–190
- to web pages, 185–186
- in workbooks, 183–184
- I
-
IF()
function, 320–324
- illustrations, inserting, 118–127
- images
- about, 495, 539
- adding, 120–121
- adding Picture Effects, 514–515
- aligning, 535–537
- applying built‐in styles and effects to, 513–515
- applying Picture Styles, 513–514
- categories, 121
- changing Summary Zoom slides to, 469–471
- cropping, 512–513
- displaying alignment tools, 538–539
- effects, 129–130
- exam essentials, 540
- exercises, 518, 539
- formatting, 133, 509–518
- grouping, 537
- inserting, 509–518
- inserting screen clippings, 516–517
- inserting screenshots, 515–516
- ordering, 534–535
- removing backgrounds, 131–132
- resizing, 511
- review questions and answers, 541–542, 636–637
- styles, 130–131
- importing
- data from comma‐delimited value (CSV) format, 174–177
- data into workbooks, 172–177
- text files into worksheets, 174
- Word document outlines to slides, 462–465
- In Front Of Text text style, 145
- In Line With Text text style, 144
- indenting paragraphs, 45, 498–499
- Insert Chart dialog box, 343–344
- Insert Hyperlink dialog box, 182, 183
- Insert ribbon, 63–64
- Insert Shapes section, 359
- Insert Table dialog box, 67
- Insert Table menu, 66–67
- inserting
- absolute cell references, 305–307
- audio clips, 568–576
- charts, 551–559
- citations, 107–109
- column breaks, 52–53
- comma‐delimited value (CSV) format files into worksheets, 176–177
- comments, 152–153
- endnotes, 100–103
- footers in documents, 17–18
- footers on slides, 481–482
- footnotes, 100–103
- handouts headers, 480–481
- headers in documents, 17–18
- headers on slides, 480–481
- hyperlinks, 182–190
- illustrations, 118–127
- images, 509–518
- layouts on slides, 467–468
- links, 504–509
- media, 568–584
- mixed cell references, 305–307
- multiple columns/rows, 240–242
- notes headers, 480–481
- online videos from YouTube, 575–576
- page breaks, 52–53
- page numbers on slides, 483
- references into formulas, 304–309
- relative cell references, 305–307
- rows, 240–244
- screen clippings into images, 516–517
- screen recordings, 576–581
- screenshots into images, 515–516
- section breaks, 52–53
- Section Zoom links, 505–509
- sections, 53
- slide headers, 480–481
- slide layouts, 467–468
- slides, 462–475
- slides from other presentations, 465–467
- SmartArt, 560
- Sparklines, 265–269
- special characters, 40–41
- symbols, 40–41
- table of contents (TOC), 109–111, 113
- table rows/columns, 545–548
- tables, 544–550
- 3D models, 121–122, 565–567
- total rows, 289–292
- video clips, 568–576
- inspecting
- documents for issues, 26–30
- presentations for issues, 439–441
- L
- Layout dialog box, 144
- Layout menu option, 14–15
- Layout Options menu, 143
- Layout Ribbon
- indenting, 45
- paragraph spacing, 44
- layouts. See also slide layouts
- chart, 356–364
- inserting on slides, 467–468
- renaming for presentations, 387
- selecting for slides, 467–468
-
LEFT()
function, 326–327
- legends, 354, 558
-
LEN()
function, 332–333
- Line And Paragraph Spacing menu, 45
- line breaks, adding, 251–252
- line spacing, setting, 43–45, 497–498
- linking
- to document locations, 8–9
- text in textboxes, 139
- links. See hyperlinks
- list levels, 62, 91–92
- lists
- about, 62, 95
- bulleted, 85
- continuing numbered, 93
- converting to SmartArt, 560–563
- creating, 85–95, 85–95
- creating from existing text, 86
- decreasing list levels, 91–92
- exam essentials, 96
- formatting, 85–95
- increasing list levels, 91–92
- numbered, 85
- restarting numbered, 93
- review questions and answers, 97–98, 629
- setting starting number value, 94
- locating
- compatibility issues, 29–30
- hidden properties from documents, 26–28
- locking Track Changes, 162–164
-
LOWER()
function, 330–331
- M
- managing
- media, 568–584
- presentation comments, 441–446
- manipulating data, in worksheets, 234–244
- margins, configuring for table cells, 70–73
- Margins icon, 191
- marking presentations as final, 437–438
- markup, 157–159
-
MAX()
function, 314–315
- media
- about, 544, 584–585
- configuring playback options, 581–584
- creating screen recordings, 576–581
- editing audio clips, 581–583
- exam essentials, 585–586
- exercises, 584
- inserting, 568–584
- inserting audio clips, 568–576
- inserting screen recordings, 576–581
- inserting video clips, 568–576
- managing, 568–584
- modifying video playback settings, 583–584
- recording audio clips, 577–579
- recording video clips, 579–581
- review questions and answers, 587–588, 637–638
- Merge Cells menu option, 74
- merging cells, 73–75, 245–246
-
MID()
function, 328–329
- MIDI audio file, 569
-
MIN()
function, 316–317
- mixed cell references, 304–307
- modifying
- animation effects, 608–609
- backgrounds for slides, 477–479
- bullet characters, 86–88
- cell alignment, 246–249
- cell indentation, 246–249
- cell orientation, 246–249
- change markup settings, 158–159
- chart elements, 556–559
- charts, 348–355, 551–559
- column width, 192–200, 197
- default column width on worksheets, 196
- document properties, 21–23
- file types, 454–456
- footers, 17–18
- formula text, 325–336
- Handout Master, 393–399, 406
- headers, 17–18
- hyperlinks, 188–189
- markup settings, 158–159
- Notes Master, 400–406
- number formatting, 86–88
- options for sections, 53–55
- options in presentations, 406–411
- page settings, 53–55, 190–192
- print settings, 23
- properties in documents, 21–23
- row height, 75–76, 192–200
- slide layouts in presentations, 389–393
- slide master content, 383–384
- slide master theme/background for presentations, 378–382, 406
- slide size for presentations, 406–408
- SmartArt content, 141, 563–564
- sources for bibliographies, 106–107
- sources for citations, 106–107
- Summary Zoom slides to images, 469–471
- tables, 68–85, 285–292
- text, 325–336
- 3D models, 565–568, 567
- video playback settings, 583–584
- views for presentations, 406–411
- window views, 216–218
- workbook content, 211–214
- workbook properties, 218–219
- monitor, settings for, 433–434
- morph transitions, 615–617
- motion paths, 612–614
- mouse
- modifying column width using, 197
- modifying row height using, 200
- using in table cells, 71–72
- Move Chart dialog box, 345, 347
- moving
- hyperlinks, 187–188
- to locations in documents, 9
- to next comment, 154
- Quick Access Toolbar, 209–210
- sections, 487–488
- MP4 video file, 569
- MPEG movie file, 569
- MPEG3 audio file, 569
- MPEG4 audio file, 569
- N
- named ranges, referencing in formulas, 307–309
- named tables, referencing in formulas, 307–309
- names, using in formulas, 262–263
- naming
- cells, 258–260
- ranges, 258–260
- tables, 263–265
- navigating
- to cells, 180–181
- within documents, 4–13
- to ranges, 180–181
- within workbooks, 178–190
- Navigation pane
- finding text, 36
- opening, 7
- New Name dialog box, 259–260
- New Table Style dialog box, 282
- Normal template, 13
- Normal view, 217–218, 409
- Notes Master, modifying, 400–406
- Notes Page icon, 410
- Notes Page Orientation option (Notes Master ribbon), 401
- notes pages
- inserting headers on slides, 480–481
- printing for presentations, 413–414
- Notes pane, resizing, 434–436
- number formatting
- custom, 88–90
- modifying, 86–88
- Number Of Pages icon, 204
- Numbered icon, 86
- numbered lists
- about, 85
- continuing, 92–94
- creating, 502–504
- restarting, 92–94
- setting starting value, 94
- numbers
- average of, 310–312
- formatting, 252–253
- O
- objects
- adding Alt text (alternative text) around, 146–147
- positioning, 142–143
- sizing, 143
- wrapping text around, 143–146
- online Glossary, xxiv
- online videos, inserting from YouTube, 575–576
- opening Navigation pane, 7
- options
- customizing, 206–222
- modifying in presentations, 406–411
- ordering images, 534–535
- organizational chart, SmartArt and, 141
- orientation, changing for text in cells, 247–248
- Orientation icon, 191
- Other Paste Options section, 236
- Outline view, 409
- P
- packaging slideshows to save to CD‐R/CD‐RW, 451–452
- page background elements, configuring, 18–19
- Page Break Preview view, 216
- page breaks, inserting, 52–53
- Page Layout view, 202, 216–217
- Page Number icon, 204
- page numbers
- inserting in documents, 53–54
- inserting on slides, 483
- page settings
- modifying, 190–192
- modifying options for sections, 53–55
- Page Setup dialog box, 205–206
- Page Setup section, 14–15, 52–53
- paragraphs
- formatting, 42–49
- indenting, 498–499
- spacing, 15, 43–45
- passwords
- protecting presentations using, 438–439
- for Track Changes lock/unlock, 164
- Paste section, 245–246
- Paste Special section, 236–238
- Paste Values section, 236
- pasting data, by using special paste options, 234–238
- paths, configuring for animations, 612–617
- Pattern Fill button, 478
- PDF documents, exporting to, 447–448
- Percent Style icon, 253
- performing conditional operations, 320–324
- personal information, locating and removing, 26–28
- Picture Effects, adding to images, 514–515
- Picture icon, 205
- Picture or Texture Fill button, 478
- Picture Styles, applying to images, 513–514
- pictures. See images
- placeholder areas, adding to presentations, 385–387
- Placeholders option, 396, 401–402
- playback options, configuring for media, 581–584
- playing audio recordings, 429–430
- Portable Document Format (PDF), 20
- positioning objects, 142–143
- prefixes, 39
- preparing presentations for collaboration, 436–456
- presentations
- about, 377–378, 456–457
- adding comments, 441–446
- adding placeholder areas, 385–387
- applying slide master themes, 380–381
- configuring print settings, 411–416
- configuring slideshow options, 422–423
- configuring slideshows, 417–436
- creating custom slideshows, 417–421
- creating slide layouts, 384–389
- deleting layouts, 388–389
- designing slide masters, 378
- displaying hidden slides during, 477
- displaying in different views, 408–410
- exam essentials, 457–458
- exercises, 406, 411, 416, 436, 456
- exporting to other formats, 447–456
- inserting slides from other, 465–467
- inspecting for issues, 439–441
- managing comments, 441–446
- marking as final, 437–438
- modifying Handout Master, 393–399, 406
- modifying Notes Master, 400–406
- modifying options, 406–411
- modifying slide layouts, 389–393
- modifying slide master content, 383–384
- modifying slide master theme/background, 378–382, 406
- modifying slide size, 406–408
- modifying views, 406–411
- preparing for collaboration, 436–456
- presenting slideshows using Presenter View, 430–436
- preserving content, 446–447
- printing, 411–413
- printing handouts, 414–415
- printing in color, grayscale, or black and white, 415–416
- printing notes pages, 413–414
- protecting using passwords, 438–439
- rehearsing slideshow timing, 423–426
- renaming layouts, 387
- review questions and answers, 459–460, 635–636
- setting basic file properties, 410–411
- setting up slideshow recording options, 427–430
- Presenter View, presenting slideshows using, 446–447
- presenting slideshows using Presenter View, 430–436
- preserving presentation content, 446–447
- Preview option, 582
- Print All Slides option, 412
- print area, setting, 222–224
- Print Area icon, 192
- Print Current Slide option, 412
- Print screen, 23
- Print Selection option, 412
- print settings
- configuring, 224–225, 411–416
- modifying, 23
- Print Titles icon, 192
- printing
- comments, 445–446
- handouts, 414–415
- notes pages for presentations, 413–414
- presentations, 411–413
- presentations in color, grayscale, or black and white, 415–416
- properties
- endnotes, 103
- footnotes, 103
- modifying in documents, 21–23
- workbook, 218–219
- Protect Sheet dialog box, 221
- protecting presentations using passwords, 438–439
- punctuation characters, 39
- R
- ranges
- about, 234
- clearing conditional formatting in, 272–273
- converting tables to, 283–284
- creating tables from, 280–281
- defining named, 258–263
- formatting, 245–258
- naming, 258–260
- navigating to, 180–181
- review questions and answers, 277–278, 632–633
- Reading view, 410
- recording
- audio clips, 577–579
- audio narration, 427–429
- setting options for presentations, 427–430
- video clips, 579–581
- records, filtering, 292–295
- references
- adding bibliographies, 112–113
- bibliographies, 109, 112–113
- citations, 100
- creating citation sources, 104–105
- creating elements of, 100–109
- endnotes, 100
- exam essentials, 114
- footnotes, 100
- inserting, 304–309
- inserting endnotes, 100–103
- inserting footnotes, 100–103
- modifying citation sources, 106–107
- properties of footnotes/endnotes, 103
- review questions and answers, 115–116, 630
- table of contents (TOC), 109–111, 113
- referencing named ranges/tables in formulas, 307–309
- rehearsing slideshow timing, 423–426
- rejecting tracked changes, 159, 161–162
- relative cell references, 304–307
- removing
- animations, 605–606
- audio recordings, 429–430
- cell styles from data, 256
- cells, 242–244
- columns, 242–243
- columns from tables, 284–288
- commands from Quick Access Toolbar, 209
- conditional formatting, 271–274
- data cell styles from data, 256
- hyperlinks, 182–190
- personal information, 26–28
- picture backgrounds, 131–132
- rows from tables, 284–288
- table of contents (TOC), 110–111
- renaming
- presentation layouts, 387
- sections, 488–489
- reordering
- rows, 70
- slides, 617–618
- table rows, 70
- Repeat Header Rows icon, 83
- replacing text, 38–39
- replying to comments, 153–154, 443–444
- resetting Quick Access Toolbar, 210–211
- resizing
- charts, 554
- columns in tables using AutoFit, 75
- images, 511
- Notes pane, 434–436
- placeholders, 387
- shapes, 525–526
- slides, 408
- tables, 75–80
- text boxes, 526
- resolving comments, 154–155
- restarting numbered lists, 92–94, 93
- reversing order of animations, 603–605
- review questions and answers
- animations, 624–625, 638
- cells, 632–633
- charts, 370–371, 587–588, 634–635, 637–638
- data cells, 277–278
- data ranges, 277–278
- documents, 33–34, 628
- formulas, 338–339, 634
- functions, 338–339, 634
- graphic elements, 149–150, 630–631
- images, 541–542, 636–637
- lists, 97–98, 629
- media, 587–588, 637–638
- presentations, 459–460, 635–636
- ranges, 632–633
- references, 115–116, 630
- shapes, 541–542, 636–637
- slides, 491–492, 636
- SmartArt, 587–588, 637–638
- tables, 97–98, 300–301, 587–588, 629, 633–634, 637–638
- text, 58–59, 628–629, 636–637
- text boxes, 541–542
- 3D models, 587–588, 637–638
- transitions, 624–625, 638
- users, 166–167, 631–632
- workbooks, 221–222, 632
- worksheets, 221–222, 632
- reviewing
- comments, 153–154, 443–444
- Track Changes, 158–159
- Ribbon, 5–7
-
RIGHT()
function, 325–326
- rotating
- rows
- about, 545–548, 554–556
- adding in tables, 284, 287–288
- aligning, 246–247
- configuring total, 289–292
- creating tables by specifying, 66–67
- deleting, 243–244
- deleting multiple, 240–242
- freezing, 214–216
- inserting, 243–244
- inserting multiple, 240–242
- inserting total, 289–292
- modifying height, 75–76, 192–200
- removing from tables, 284–288
- reordering, 70
- setting height, 198–199
- sizing multiples in tables, 79–80
- switching columns and, in source data, 351–352
- in tables, 62
- unfreezing, 216
- S
- Save As screen, 21
- saving
- documents, 20–26
- slideshows, 429
- workbooks, 224
- screen clippings
- adding, 124–125
- formatting, 134
- inserting to images, 516–517
- screen recordings, 576–581
- screenshots
- adding, 123–124
- formatting, 134
- inserting to images, 515–516
- ScreenTips, adding, 184
- Search bar, 5
- Search box, 36
- searching
- for data within workbooks, 178–180
- Navigation pane, 7
- replacing with keyboard, 7–8
- Search bar, 5
- for text, 4–8
- using Ribbon, 5–7
- section breaks, inserting, 52–53
- Section Zoom links, inserting, 505–509
- sections
- about, 484–489
- changing page setting options for, 53–55
- inserting, 53
- selecting slide layouts, 467–468
- Set Numbering Value menu and dialog box, 92–93
- setting(s)
- basic file properties for presentations, 410–411
- cell width, 72
- column width, 192–193
- duration of effects for transitions, 619–620
- file properties for presentations, 410–411
- line spacing, 497–498
- monitor, 433–434
- Presenter View, 433–434
- print area, 222–224
- row height, 198–199
- starting number value for lists, 94
- timing for transitions, 619–622
- setup
- documents, 14–15
- recording options for slideshows, 427–430
- SmartArt graphics, 134–136
- shading, 53
- Shape Format ribbon, 148
- Shape Styles section, 360
- shapes
- about, 495, 539
- adding, 118–119
- adding Alt text for accessibility, 532–533
- adding text boxes to, 524
- adding text to, 139–141, 523
- aligning, 535–537
- animating in SmartArt graphics, 602–603
- animations and, 596–606
- applying built‐in styles to, 529–530
- applying WordArt styles, 530–531
- displaying alignment tools, 538–539
- drawing using digital ink, 520–522
- exam essentials, 540
- exercises, 534, 539
- formatting, 132, 518–534
- formatting text boxes, 528
- grouping, 537
- inserting, 518–534
- modifying, 518–519
- modifying appearance of text in, 140–141, 531–532
- modifying text in, 531–532
- ordering, 534–535
- resizing, 525–526
- resizing text boxes, 526
- review questions and answers, 541–542, 636–637
- Shape Format ribbon, 148
- Share screen, 24
- sharing
- documents, 20–26
- documents electronically, 24–25
- documents via blog posts, 25
- documents via email, 24
- Sheet Name icon, 205
- Show/Hide icon, 10–11
- Size icon, 191
- Size section, 363
- sizing
- multiple columns in tables, 79–80
- multiple rows in tables, 79–80
- objects, 143
- sizing handles, 574
- slide layouts
- creating for presentations, 384–389
- deleting for presentations, 388–389
- modifying for presentations, 389–393
- slide masters
- applying themes to, 380–381
- designing for presentations, 378
- modifying content for presentations, 383–384
- modifying theme/background in presentations, 378–382, 406
- Slide Size option, 394, 401
- Slide Sorter view, 409
- Slide Zoom links, inserting, 505–509
- slides
- about, 462, 489–490
- animations for, 596–619
- creating sections, 484–486
- duplicating, 474–475
- exam essentials, 490
- exercises, 475, 483–484, 489
- grouping, 484–489
- hiding, 476–477
- importing Word document outlines, 462–465
- inserting, 462–475
- inserting footers, 481–482
- inserting from other presentations, 465–467
- inserting handouts headers, 480–481
- inserting layouts, 467–468
- inserting notes headers, 480–481
- inserting page numbers, 483
- inserting slide headers, 480–481
- inserting Summary Zoom, 469–474
- modifying, 475–484
- modifying backgrounds, 477–479
- moving sections, 487–488
- ordering, 484–489
- ordering and grouping objects on, 534–539
- renaming sections, 488–489
- reordering, 486–487
- resizing in presentations, 406–408
- review questions and answers, 491–492, 636
- selecting layouts, 467–468
- unhiding, 476–477
- Slides Per Page option (Handout Master menu ribbon), 394, 395
- slideshows
- configuring, 417–436
- configuring options for, 422–423
- creating custom, 417–421
- exporting as videos, 449–451
- hyperlinked, 419–420
- presenting using Presenter View, 430–436
- rehearsing timing for, 423–426
- saving, 429
- setting up recording options for, 427–430
- transitions, 429
- SmartArt
- about, 544, 560, 584–585
- adding, 122–123
- adding content, 563–564
- for animations, 601–606
- converting lists to, 560–563
- exam essentials, 585–586
- exercises, 565
- inserting, 560
- modifying content, 141, 563–564
- organizational chart, 135
- review questions and answers, 587–588, 637–638
- setting up, 134–136
- text, 141
- software, requirements for, xxi
- Sort dialog box, 68–70, 296–298
- sorting
- data by multiple columns, 296–298
- table data, 68–70, 292–298
- tables, 68–70
- sounds, adding to transitions, 594–595
- source data, switching between columns and rows in, 351–352, 554–556
- Sparklines
- adding, 265–266
- adding dates to, 268–269
- deleting charts, 268
- formatting charts, 267–268
- inserting, 265–269
- special characters, 39–41
- Split Cells dialog box, 75
- splitting
- table cells, 73–75
- tables, 80–82
- Square text style, 144
- starting Presenter View, 430–432
- styles
- applying settings for, 15–17
- applying to tables, 282–283
- applying to text, 495–501
- built‐in, 46–47
- bullets, 87
- cells, 254–256
- chart, 364–366
- citations, 104–105
- Design menu, 15–16
- numbers, 88
- table, 288–289
- WordArt, 138, 140
- Styles pane, 16–17, 47
- suffixes, 39
-
SUM()
function, 317, 318
- summarizing data visually, 265–274
- Summary Zoom slides, 469–474
- switching
- between displaying formulas and results, 219
- between rows and columns in source data, 351–352, 554–556
- Symbol window, 40
- symbols, 39–41
- T
- table of contents (TOC)
- customizing style, 110–111
- inserting, 109–111, 113
- removing, 110–111
- updating, 111
- tables
- about, 62, 95, 280, 353, 544, 584–585
- applying built‐in styles, 548–550
- applying styles, 282–283
- AutoFit, 78
- cells, 62
- columns in, 62
- configuring cell margins, 70–73
- configuring cell spacing, 70–73
- configuring repeating row headers, 82–84
- configuring style options, 288–289
- converting text to, 64–65
- converting to cell ranges, 283–284
- creating, 62–68, 280–284, 544–545
- creating by specifying rows/columns, 66–67
- deleting rows/columns, 545–548
- exam essentials, 96, 585–586
- exercises, 550
- filtering data in, 292–298
- formatting, 280–284, 544–550
- Insert ribbon, 63–64
- inserting, 544–550
- inserting rows/columns, 545–548
- merging cells, 73–75
- modifying, 68–85, 285–292
- modifying row height, 75–76
- naming, 263–265
- reordering rows, 70
- resizing, 75–80
- review questions and answers, 97–98, 300–301, 587–588, 629, 633–634, 637–638
- rows in, 62
- sizing multiple columns, 79–80
- sizing multiple rows, 79–80
- sorting, 68–70
- sorting data in, 292–298
- splitting, 80–82
- splitting cells, 73–75
- switching to text, 65–66
- templates, Normal, 13
- TestBank, xxiv
- text
- about, 56, 495
- adding Alt text around objects, 146–147
- adding effects, 42–43
- adding to shapes, 139–141, 523
- alignment of in text boxes, 139
- animations for, 596–606
- applying built‐in styles to, 46–47, 499–500
- applying formatting to, 495–501
- applying formatting using Format Painter, 43
- applying styles to, 495–501
- clearing formatting, 47–49, 500–501
- configuring document sections, 50–56
- converting to tables, 64–65
- creating bulleted lists, 502–504
- creating document sections, 50–56
- creating lists from existing, 86
- creating numbered lists, 502–504
- displaying Styles list pane, 47
- exam essentials, 57
- exercises, 13
- finding, 36–37
- formatting, 42–49, 325–336, 495–504
- formatting in multiple columns, 50–51, 501–502
- formatting in text boxes, 137–139
- hidden, 4
- indenting paragraphs, 45, 498–499
- inserting column breaks, 52–53
- inserting links, 504–509
- inserting page breaks, 52–53
- inserting section breaks, 52–53
- inserting Section Zoom links, 505–509
- inserting Slide Zoom links, 505–509
- inserting special characters, 40–41
- inserting symbols, 40–41
- linking in text boxes, 139
- markup, 157
- modifying, 325–336
- modifying appearance of in shapes, 140–141, 531–532
- modifying appearance of in text boxes, 139
- modifying orientation of in cells, 247–248
- modifying settings for markup, 158–159
- replacing, 38–39
- review questions and answers, 58–59, 628–629, 636–637
- rotating, 139
- rotating in cells, 249
- searching for, 4–8
- setting line spacing, 43–45, 497–498
- setting paragraph spacing, 43–45
- SmartArt, 141
- switching tables to, 65–66
- wrapping around objects, 143–144
- wrapping text styles, 144–145
- wrapping within cells, 250–252
- text boxes
- about, 539
- adding to shapes, 524
- aligning, 535–537
- alignment of text in, 139
- applying WordArt styles, 138
- displaying alignment tools, 538–539
- exam essentials, 540
- exercises, 539
- formatting, 528
- formatting text in, 137–139
- inserting, 118–127, 125–126
- linking text in, 139
- modifying text appearance, 139
- ordering, 534–535
- resizing, 526
- text effects, 42–43
- Text Effects And Typography icon, 42
- text files, 173–174
- Text Import Wizard dialog box, 173, 176
-
TEXTJOIN()
function, 333, 334–335
- Themes option, 396, 402
- 3D models
- about, 544, 565, 584–585
- animations and, 606–609
- exam essentials, 585–586
- exercises, 568
- inserting, 121–122, 565–567
- modifying, 565–568, 567
- review questions and answers, 587–588, 637–638
- rotating, 136
- 3D transitions, applying, 590–592
- Through text style, 145
- Tight text style, 144
- tilde (~), 180
- timing, setting for transitions, 619–622
- Title check box (Slide Master ribbon), 389
- titles (chart), 353
- Top And Bottom text style, 145
- Track Changes. See also comments
- accepting tracked changes, 159–161
- change lines, 157
- defined, 152
- locking, 162–164
- markup, 157
- markup drop‐down menu, 160
- modifying change markup settings, 158–159
- rejecting tracked changes, 159, 161–162
- reviewing, 158–159
- turning on, 157–158
- unlocking, 162–164
- viewing changes in documents, 158
- transforming data, 310–324
- transitions
- about, 590, 622
- adding sounds to, 594–595
- applying, 590–596
- applying 3D, 590–592
- applying basic, 590–592
- configuring effects, 592–595
- configuring start and finish options for, 620–621
- exam essentials, 623
- exercises, 622
- review questions and answers, 624–625, 638
- setting duration of effects, 619–620
- setting timing for, 619–622
- slideshows, 429
- trendlines, 354, 558
- Trim option, 582
- turning on/off
- Draw menu option, 520–521
- slideshow timings, 424–426
- Track Changes, 157–158, 157–158
- U
- unfreezing rows/columns, 216
- Unlock Password dialog box, 164
- unlocking Track Changes, 162–164
- unmerging cells, 245–246
- updating table of contents (TOC), 111
-
UPPER()
function, 329–330
- users
- about, 152, 165
- adding comments, 152–156
- exam essentials, 165
- review questions and answers, 166–167, 631–632
- tracking changes, 157–164
- V
- video playback settings, changing, 583–584
- video recordings
- exporting slideshows as, 449–451
- inserting, 568–576
- recording, 579–581
- supported formats for, 569
- views
- about, 406–411
- applying custom, 214
- creating custom, 212–213
- customizing, 206–222
- deleting custom, 214
- Normal, 217–218
- Page Break Preview, 216
- Page Layout, 216–217
- window, 216–218
- workbook, 211–214
- W
- watermark, 18–19
- web pages, hyperlinks to, 185–186
- white‐space characters, 39
- wildcard characters, 39, 179–180
- Wiley, contact information for, xxii
- window views, changing, 216–218
- Windows audio file, 569
- Windows Media Audio file, 569
- Windows Media Video file, 569
- Windows Video file, 569
- Word document outlines, importing to slides, 462–465
- Word Options dialog box, 12
- WordArt
- about, 138, 140
- applying styles to shapes, 530–531
- WordArt Styles section, 361–362
- workbooks
- about, 172
- displaying content in, 211–214
- formatting, 190–206
- hyperlinks in, 183–184
- importing data into, 172–177
- inspecting for issues, 225–228
- modifying basic properties, 218–219
- modifying content in, 211–214
- navigating within, 178–190
- review questions and answers, 221–222, 632
- saving, 224
- searching for data within, 178–180
- views, 211–214
- worksheets
- about, 172
- aligning charts in, 363–364
- clearing conditional formatting on, 272
- finding conditional formats in, 273–274
- formatting, 190–206
- freezing rows/columns, 214–216
- importing text files into, 174
- inserting CSV files into, 176–177
- manipulating data in, 234–244
- modifying default column width on, 196
- removing conditional formats in, 273–274
- review questions and answers, 221–222, 632
- unfreezing rows/columns, 216
- wrapping
- text around objects, 143–146
- text within cells, 250–252
- X
- XPS documents, exporting to, 447–448
- Y
- YouTube, inserting online videos from, 575–576
- Z
- Zoom dialog box, 211–212
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.