Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1
copyrights, 448, 974
correcting mistakes automatically, 406
Corrections button (Word), 171
COUNT function, 287, 297
COUNTA function, 297
COUNTBLANK function, 297
COUNTIF function, 297
COUNTIFS function, 297, 299
counting entries, 287
counts, viewing with AutoCalculate, 355, 359
courtesy copies. See Cc field
Cover Page button (Word), 185
cover pages, 183, 186
Create button (Access), 793, 799
Create button (Publisher), 901
Create button (Word), 39
Create Names From Selection dialog box
(Excel), 283
Create New Building Block dialog box (Word),
94, 194
Create New Business Information Set dialog
box (Publisher), 882
Create New Color Scheme dialog box
(Publisher), 951
Create New Section button (OneNote), 559
Create New Theme Colors dialog box
(PowerPoint), 426
Create New Theme Fonts dialog box
(PowerPoint), 426
Create Notebook button (OneNote), 542, 547
Create tab, 755, 756
crediting pictures, 451
criteria, function, 299
Crop button (Word), 170
cropping pictures, 170, 920
currency, in Excel worksheets, 329, 331
cursor
function of, 38
keyboard shortcuts for, 47, 49
moving, 49-50
paging up or down with, 47
placing, 47
status bar display for, 47
Custom AutoFilter dialog box (Excel), 353
Custom Filter dialog box, 853
custom slide sizes, 486
custom themes, 830, 835
Custom XML Data check box, 506
CUSTOM.DIC dictionary, 412, 415
Customize Quick Access Toolbar button, 33
Customize Ribbon page, 27
Customize Status Bar menu, 8
Cut button (PowerPoint), 401, 404
Cut button (Word), 66, 70, 193

cutting text, 66, 70, 193, 263
vs. copying, 67
keyboard shortcut for, 67, 193, 402
cycle diagrams, 454

D
Daily Task List, 707
Daily Task List button, 707
data bars, 337
gradient fill in, 334
and negative values, 335
data entry
ensuring accuracy of, 361
in multiple cells, 257
techniques, summarized, 257
data entry tools
AutoComplete, 257
AutoFill, 256
AutoFill Options button, 258, 260
Fill Series, 256
overview of, 255
Pick From Drop-Down List, 257, 259
data fields for mail merge, 964
data markers, 463
data organization, 796
data points, 463
data series, 463
entering, 256-258
in Excel tables, 276
types of, 257
data source for mail merge, 964, 967
Data Type column, 809
data types, 348, 809-811
Data Validation dialog box (Excel), 361, 364
database application templates. See templates
database design, 804
database objects. See also forms; queries;
reports; tables
closing all, 773
creating, 755
defined, 747
groups of. See application parts
listing all, 794
printing, 782
uses for, 760
in Web databases, 795
databases. See also Web databases
adding to trusted locations, 759
closing, 757
creating, 749, 793, 799
default location of, 792

databases 993

Free download pdf