C

Calculate Now control, 42

Calculate Sheet control, 42

Calculated Field option, 513-516

Calculated Item option, 513-514, 516-519

Calculation section, Formulas tab, 55

Calculation tab, Options dialog box, 745

calculations

area and perimeter of circles, 282-283

area and perimeter of rectangles, 282

area and perimeter of squares, 282

area and perimeter of trapezoids, 283

area of triangles, 283

rounding numbers, 286-291

solving right triangles, 279-281

solving simultaneous equations, 284-286

surface and volume of cones, 284

surface and volume of cubes, 283

surface and volume of spheres, 283

unit conversions, 277-279

volume of cylinders, 284

volume of pyramids, 284

case of text, changing, 127-128

case-sensitive lookup, 221-222

cash flows, irregular, 340-342

cash in and cash out, 296-297

Categories in Reverse Order option, Format Axis dialog box, 457

category fields, 490

category_labels argument, SERIES formula, 445

CEILING function, 286, 288, 737

CELL function, 111, 734

cell references, 45-48

cell selecting, 19-21

CELLCOUNT function, 673

cells, formatting, 22, 23

Cells property, 669-671

Change Shape option, Drawing Tools, 449

CHAR function, 117, 119-120, 647, 742

character codes, 118-120

characters

counting in cells, 131

extracting from strings, 128

repeating, 124

Chart Elements drop-down control, Chart Tools, 446

Chart Name control button, Chart Tools option, 81

chart sheets, 10

chart title link, 448

Chart Tools tab, 24

charts

animating using iteration, 441-442

creating links to cells, 448-449

data bars in lieu of, 534-535

examples

box plot, 457-459

charting progress toward a goal, 450-451

comparative histogram, 453-454

creating awesome designs, 473

creating clock charts, 469-472

displaying conditional colors in column chart, 452-453

Gantt chart, 454-457

gauge chart, 451-452

plotting circles, 468-469

plotting every nth data point, 459-460

plotting last n data points, 461-462

plotting mathematical functions, 463-468

selecting series from combo box, 462-463

SERIES formula, 443-447

trendlines, 475-483

using names in, 79

checkerboard shading, 548

CHIDIST function, 739

CHIINV function, 739

CHITEST function, 739

CHOOSE function, 212, 224, 735

Circle Invalid Data option, Data Validation drop-down control, 557-558

circles

area of, 282-283

perimeter of, 282-283

plotting, 468-469

circular references

accidental, correcting, 430-431

calculation and iteration settings, 435

errors with, 442, 595

examples

animating charts using iteration, 441-442

generating unique random integers, 436-437

solving recursive equation, 437-438

solving simultaneous equations, 439-440

fixing errors with, 601

indirect, 431

overview, 429-431

potential problems with, 442

Circular References warning dialog box, 430-431, 435

Classic Pivot Table Layout option, 493

CLEAN function, 124, 742

Clear Formats option, 543

Clear Rules command, 529

Clip Art task pane, 15-16

Clipboard group, Home tab, 11, 47

clock charts, creating, 469-472

CODE function, 117, 119, 742

code windows, Visual Basic (VB) editor, 616-618

coefficient of determination, 476

Collapse Dialog button, 106

colon (:), 74

color scales, 535-537

Color Scales command, 529, 535

coloring values, 761-762

colors

conditional, displaying in column charts, 452-453

counting, 702-703

Columbus Day, 164

column charts, displaying conditional colors in, 452-453

COLUMN function, 548, 735

Column labels, 489

columns

adding to tables, 241-242

deleting in tables, 242

determining column letters for column numbers, 132-133

naming, 68-69

returning last value in, 414-416

Columns and Rows properties, 675

COLUMNS function, 111, 180, 735

COMBIN function, 737

combo box, selecting series from, 462-463

Comma Style button, 747

Comment Block button, VB Editor, 648

comments, 648

comparative histogram, 453-454

comparison operators, 264-265

COMPLEX function, 730

CONCATENATE function, 120, 742

concatenation, 119

concatenation operator, 639, 647

conditional colors, displaying in column charts, 452-453

conditional formatting

copying cells containing, 542-543

creating formula-based rules, 546-551

deleting, 543

find and replace limitations, 543

locating cells containing, 543-544

managing rules, 542

specifying, 528-532

using graphics, 532-542

Conditional Formatting feature, 20, 354, 527, 528-529, 546, 751

Conditional Formatting Rules Manager dialog box, 541-543

conditional number formatting, 761

Conditional Sum Wizard, 204

conditional sums using multiple criteria

using And criteria, 208-209

using Or criteria, 210

conditional sums using single criterion, 204-208

cones, surface and volume of, 284

CONFIDENCE function, 739

constants, 84-86, 652-653

contextual tabs, 14

controls, 25

conversions, unit, 277-279

CONVERT function, 277-279, 730

Convert software, 279

Convert Text to Columns Wizard, 134

Convert Text to Table command, 134

Convert to Number option, Smart Tag, 115

Convert To Range option, Tables menu, 259

Copy to Another Location option, Tables menu, 262

Copy To box, Tables menu, 262

Copy tool, Clipboard group, 11

copying

cells containing conditional formatting, 542-543

sheets, potential name problems, 81-82

Corel company, 3

CORREL function, 739

COS function, 737

COSH function, 737

Cost argument, 344

Count formula, Tables menu, 249

COUNT function, 176, 673, 687, 739

Count Numbers formula, Tables menu, 249

Count property, 673

COUNTA function, 93, 176, 181, 415, 671, 675, 739

COUNTBLANK function, 176, 180-181, 739

COUNTIF function, 176, 182-183, 187, 189, 406-407, 550, 561, 701, 739

COUNTIFS function, 176, 739

counting

cells, 182-190, 701

colors, 702-703

creating frequency distribution, 194-200

error values in a range, 184

logical values, 184

most frequently occurring entry, 190-191

number of unique values, 193-194

occurrences of specific text, 191-193

records in databases and pivot tables, 180-181

sheets in a workbook, 701

words in a range, 702

COUPDAYBS function, 732

COUPDAYS function, 732

COUPDAYSNC function, 732

COUPNCD function, 732

COUPNUM function, 732

COUPPCD function, 732

COVAR function, 739

Create Names From Selection dialog box, 65-67

Create Pivot Table dialog box, 491, 525

Create Table dialog box, Tables menu, 239

credit card calculations, 356-357

credit card number, determining validity of, 575-578

CRITBINOM function, 739

Criteria range box, Tables menu, 262-264

crosstab table, 417-418

cube functions, 114

CUBEKPIMEMBER function, 727

CUBEMEMBER function, 727

CUBEMEMBERPROPERTY function, 728

CUBERANKEDMEMBER function, 728

cubes, surface and volume of, 283

CUBESET function, 728

CUBESETCOUNT function, 728

CUBEVALUE function, 728

CUMIPMT function, 313-314, 565, 732

CUMPRINC function, 313-314, 732

cumulative sum, 202-203

currency, 123

Currency data type, 650

Currency number format, Options dialog box, 748

currency values, rounding, 288-289

Current Array option, 384

current date, displaying, 150

current time, displaying, 166-167

custom functions, 551-554, 624

custom number formats

creating, 749-754

examples

coloring values, 761-762

conditional number formatting, 761

displaying a zero with dashes, 763-764

displaying fractions, 759

displaying leading dots, 766

displaying leading zeros, 759

displaying N/A for text, 759-760

displaying negative sign on the right, 760-761

displaying text in quotes, 760

displaying text with numbers, 763

filling cells with a repeating character, 766

formatting dates and times, 762-763

hiding zeros, 758

repeating a cell entry, 760

scaling values, 755-758

suppressing certain types of entries, 764-765

using special symbols, 764

number formatting overview, 746-749

Custom option, Settings tab, 557

custom VBA functions, 137

customization, 26-27

Customize Regional Options dialog box, Control Panel, 139, 146

customized onscreen display, 18-19

Cut tool, Clipboard group, 11

cutting named ranges, 80

cylinders, volume of, 284