E

editing text, PowerPoint 2007, 397-99

editing text, Word 2007, 36-42

building blocks, 42-44

Clipboard, 38-39, 42

drag-and-drop, 39

exercise in, 39-42

inserting date, 45

inserting text, 36-37

inserting time, 45

overtyping, 37

Research task pane, 47

selection area, 38

Thesaurus, 45-47

Translation feature, 48

editing Word documents

finalizing, 61-65

finding and replacing text, 51-55

inserting saved text, 42-45

outlining, 48-51

overview, 35-36

text editing, 36-42

word usage, improving, 45-48

effects, e-mail, 522

electronic pen, drawing on slides with, 459-62

elements, of Word environment, 4-7

elements, Outlook workspace

list of, 483

showing/hiding, 485

e-mail accounts

connecting to additional, 475-78

connecting to primary, 469-73

creating additional profiles, 480-83

supported by Outlook 2007, 468

e-mail management, Outlook 2007, 495-533

adding signatures automatically, 528-32

addressing messages, 503-04

archiving messages, 561-65

attaching files to, 510-14

composing and sending, 505-09

creating and formatting business graphics, 514-20

creating OneNote page from, 560

message settings and delivery options, 520-22

Outlook message formats, 502

overview of, 495-96

personalizing message appearance, 522-28

resending and recalling messages, 510

saving message drafts, 504-05

sending calendar information in, 604-06

sending courtesy copies, 504

using mail merge, 514

working in message window, 496-502

embedded files, 604-06

embedded objects, 126

empty strings, compared with Null, 334-35

encryption, setting up e-mail accounts and, 473

Equals command, filtering with, 303, 305

equal to (=), comparison operator, 306

error codes, 195

error detection and correction, Excel data

calculation, 195-202

errors in text entry

AutoCorrect feature for, 405-08

in PowerPoint generally, 393

Smart Tags for, 408

events, objects responding to, 278-83

events, Outlook 2007

defined, 578

scheduling and changing, 578-80

Events view, Outlook 2007, 590

Event tab, Outlook 2007, 572-73

event window, Outlook 2007, 568

Excel 2007, calculations, 179-202

conditional formulas for summarizing data, 191-94

error detection and correction, 195-202

formulas for values calculation, 184-90

naming data groups, 180-83

overview, 179-80

Excel 2007, data in, 155-77

correcting, 168-72

defining tables for, 172-75

entering, 156-60

expanding, 168-72

finding and replacing, 164-67

moving within workbooks, 160-63

overview, 155

replacing, 164-67

revising, 156-60

Excel 2007, document appearance, 205-37

cell formatting, 206-11

images, adding, 233-36

numbers, legibility of, 222-26

overview, 205-06

styles, defining, 212-16

table styles, applying, 218-21

values, changing data based on, 226-33

workbook themes, applying, 216-18, 220-21

Excel 2007, inserting data from Excel into Word tables, 125

Excel 2007, program window, 146-52

multiple windows, arranging, 147-48

multiple workbook windows, arranging, 147-48

overview, 133

Quick Access Toolbar, adding buttons to, 148-52

workbooks, 146-52

zooming in on worksheets, 146

Excel 2007, tables

appearance of Excel documents, 218-21

defining tables for, 172-75

overview, 155

Excel 2007, workbooks, 133-53

creating, 134-37

data calculations in, 179

modifying, 138-41

multiple windows, arranging, 147-48

overview, 133-34

Program Window, customizing, 146-52

Quick Access Toolbar, adding buttons to, 148-52

worksheets in, modifying, 141-45

zooming in on worksheets, 146

Excel 2007, worksheets

Excel formulas for calculating in tables, 118-19

formulas for calculating in tables, 117-19

performing calculations in tables, 120-24

Exchange Server

limited to one account per profile, 477

manually setting up e-mail account, 474-75

Outlook 2007 supported e-mail accounts, 468

setting up as primary e-mail account, 469-73

Exchange Server 2007, 583

Expand the Query Builder button, 538

Expression Builder

accessing, 324

building expressions with, 320-23

creating validation rules with, 345

expressions

building with Expression Builder, 320-24

overview of, 306

extensions, file name, 28