Excel 2010 Bible

963

Index

CHIDIST function, 918

CHIINV function, 918

CHISQ.DIST function, 929

CHISQ.DIST.RT function, 929

CHISQ.INV function, 929

CHISQ.INV.RT function, 929

CHISQ.TEST function, 929

CHITEST function, 918

Choose Commands list, Customize Quick Access Toolbar, 41

Choose Data Source dialog box, 682, 684, 690

Choose Details dialog box, 152

CHOOSE function, 311, 926

Christmas Day, date functions, 271

Circle Invalid Data item, Data Validation drop-down list, 572

Circular Reference Warning message, 219

circular references, 219–220, 650, 665

circular reference.xlsx sample file, 936

CLEAN function, 239, 932

Clear All button, Office Clipboard, 85

Clear All command, 35

Clear button, Format Cells dialog box, 484

Clear Comments command, 35

Clear Contents command, 35

Clear Formats command, 35

Clear Hyperlinks command, 35

Clear method, 817

Clear Rules command, Conditional Formatting drop-down

list, 483

Click event, 853

client-server network, 628

Clip Art task pane, 22, 531–532

ClipArt button, 470–471

Clipboard button, 470–471

Clipboards

overview, 616–617

replacing cell contents, 35

Close button, 50

closest values, determining, 391

closing

all workbooks, VBA macros, 896–897

Excel windows, 52–53

clustered column chart, 410, 419

CODE function, 932

codes

entering and editing, 812

for number formatting, 558–560

col_index_num argument, VLOOKUP function,

312

col_num argument, INDEX function, 316

Collated option, 180

Ribbon feature, 442

selecting with mouse, 438–439

embedded, 405

Gantt, 476–477

gauge, 473–474

gridlines, 448

histogram, 475–476

legends, 446–448

moving, 414

overview, 403–404

picture, 470–471

Plot Area, 444–445

plotting one variable mathematical functions, 477–478

plotting two variable mathematical functions, 479

printing, 416–417

resizing, 414

sheets, 406–407

templates, 469–470

thermometer, 472–473

titles, 445–446

types of

area, 427–428

bar, 422

bubble, 433

choosing, 417–419

column, 419–421

doughnut, 429–430

line, 423–424

pie, 424–426

radar, 430–432

stock, 433–436

surface, 432–433

XY (scatter), 426–427

using data bars instead of, 487

VBA macros and

applying formatting, 899

modifying properties, 898

modifying type, 898

overview, 897

Charts object, 815

Check Accessibility command, Info pane, 155

check boxes, Ribbon, 14

Check Compatibility command, Info pane, 156

Check for Issues button, 155

Check Mark icon

Formula bar, 36

New Formatting Rule dialog box, 491–492

CheckBox control, ActiveX, 844, 859, 861, 866–867

checkerboard shading, 497

Chi Square distribution, 201

60_474877-bindex.indd 96360_474877-bindex.indd 963 3/29/10 11:48 PM3/29/10 11:48 PM