R


R1C1 reference style, 431–432

RADIANS function, 980

RAND function, 500, 574, 851, 980

RANDBETWEEN function, 500, 576, 980

random-number sets

generating, 553, 574–579

troubleshooting, 575

random numbers, 500

range operators (:), 458

ranges. See also cell ranges; named references

array, 468

conditional formatting, 287

consolidation, 711

Descriptive Statistics tool, 569

names, 12–13

new and changed features, 12–13

rank-and-percentile functions, 555–558, 573–574

rank-and-percentile tables, 553

Rank And Percentile tool, 573–574

RANK function, 557–558, 980

RATE function, 540, 980

rates

arguments, 536

hurdle, 536, 540–541

internal rates of return, 540–541

modified internal rate of return, 541

security interest rates, 544

read-only files

opening, 65

previously-shared workbooks, 798

publishing tables to SharePoint sites, 819

SharePoint files, 808

readability and worksheet design, 117–118

reading IRM-protected documents, 803

real estate regression analysis, 563

rearranging fields in PivotTables, 716–721

recalculation

calculating portions of formulas, 463–464

interrupting, 460

iterative calculations, 466

manual process, 461–462

stopping, 461

RECEIVED function, 546, 980

recent workbooks, 46

recognizers, 229

recoloring

objects, 385

pictures, 369, 381

recording macros. See macros

records

databases, 122

duplicated in filtering, 698–699

filtering for mail merge, 903

grouping in Query, 776

sorting for mail merge, 904

sorting in Query, 763–764, 768–769

recovering data. See also troubleshooting

after crashes, 79–82

AutoRecover feature, 79–80

charts, 67

Dr. Office, 80–81

Excel Web site, 82

formatting, 67

Office Diagnostics program, 80–81

product support, 82

repairing files, 65, 66–67

using links, 67

red triangles, 251

redemption values of securities, 544

redoing actions, 206

#REF! error, 438, 682

reference functions, 512–520

reference operators, 458

references. See cell references; named references

references to other worksheets, 250–251

reflections, 370, 371

refreshing

external data, 747–748, 750

imported XML data, 757, 758

PivotTables, 721

Web queries, 780, 784

regional settings, 755

regions. See also worksheets

active areas, 125

defined, 125

jumping to, 132, 133

keyboard shortcuts, 128

navigating to, 126–127, 128

selections, 131, 134

registering Excel 2007, 21–22

regression analysis

creating, 553

exponential, 566–567

future values, 567

linear, 559–566

multiple, 560

real estate example, 563

standard errors, 566

trendlines, 660

regression sum of squares, 561

regrouping objects, 387

reinvestment rates, 536

rejecting changes, 797

relationships

queries, 761–762

SmartArt graphics, 359

relative cell references

computed filter criteria and, 695–697

copying, 432

defined, 429–430

ignoring, 452

in linked workbooks, 476–477

macros and, 832

in names, 448

relative values in conditional formatting, 285

remainders from MOD function, 499

remote computers, 789–790. See also collaboration

removed commands in Excel 2007, 907–925

removing. See also clearing; deleting

array assignments, 469

AutoFilter menus, 273

automatic table features, 273

buttons from toolbars, 85

cell names, 444

chart gridlines, 628

chart titles, 621–622

conditions in conditional sums, 480

data labels, 652

duplicate filtered records, 698–699

error flags in cells, 582

filters, 686, 762

formatting, 273

hyperlinks, 192, 876, 880

keyboard shortcuts, 936, 941

links to objects, 888–889

links to workbooks, 476

page break settings, 420–421

print area definitions, 413–414

print title definitions, 414

query criteria, 773

query fields, 767

scenarios, 593

SharePoint tasks, 813

subtotals, 725

table formatting, 273, 706

tables from queries, 766

undoing deletions, 200

workbooks from sharing status, 797, 798

rendering data, 881–882

renumbering objects in collections, 838

repairing corrupted files, 65, 66–67

repeating rows or columns on printouts, 414

REPLACE function, 506–507, 980

REPLACEB function, 981

replacing

cell references with names, 451–452

formatting, 223–224

formula elements with meaningful names, 699

text, 228, 506–507

replicating formulas in tables, 667, 672

reports

best uses of, 598

PivotTable fields and, 717, 722

scenarios, 589, 595–599

REPT function, 981

"reputable developers," 103

requesting permission to open IRM documents, 806

research resources, 18, 234–236

resetting

chart elements to original position, 635

object formatting adjustments, 385

original chart appearance, 631

original page breaks, 420

picture adjustments, 369

SmartArt options, 360

window positions, 171

residual sum of squares, 561

resizing

chart text, 629, 641–642

charts, 617

pages for printing, 405

shapes, 346–347, 354

shapes proportionally, 390

SmartArt, 360

text boxes, 352–353

text in shapes, 383

workbook windows, 29–30

worksheets with shapes, 390

resolution

pictures, 373

printing, 404

resolving conflicts in shared workbooks, 791–792, 794

restoring

chart elements to original position, 635

object formatting adjustments, 385

original chart appearance, 631

original page breaks, 420

pictures, 369

SmartArt options, 360

window positions, 171

restricting permissions. See permissions

result sets

fields not in, 774

filtering, 769–770

Query, 764, 766

results ranges, 585

returning to Excel, 778–779

sorting, 768–769

results-oriented user interface, 4–5

results ranges, 585

resuming

after error handlers, 868

iterations, 600

retired features, summary of, 16–18

retrieving files from remote computers, 789–790. See also collaboration

image from book Revenue Scenarios.xlsm file, 589

Review tab commands and options, 907, 908, 911, 912, 914, 916, 922, 923

reviewing

changes, 794, 797

distributing files by e-mail, 800–802

highlighting changes, 795–796

Send For Review command, 802

Ribbon. See also toolbars

commands and options, 907–925

contextual tool sets, 36–37

customizing, 88, 95

Dialog Box Launchers, 32–34

drop-down lists, 32–34

editing VBA code and, 95

File menu and, 37–38

formatting graphics, 368–371

formula bar, 42–43

graphic tabs, 347

hiding, 31

hiding formula bar, 42

illustrated, 31

keyboard command mode, 39–40

keyboard shortcuts, 942

live preview, enabling, 95

macros and, 95

Microsoft Office Button and, 37–38

Mini toolbar, 42

mini version, 88

ScreenTips, 32

self-documenting features, 31–32

shortcut menus, 41–42

status bar, 44–45

RibbonX model, 92

rich text formatting (RTF), 783, 893, 894, 895

RIGHT function, 506, 981

RIGHTB function, 981

Rights Management Services (RMS), 803

ROMAN function, 981

rotating

3-D, 380

chart text elements, 627–628

pictures, 370

shapes, 354, 371

ROUND function, 500–501, 851, 981

ROUNDDOWN function, 500–501, 981

rounded values

compared to rounding functions, 501

Solver add-in, 606

troubleshooting, 467

ROUNDUP function, 500–501, 981

row differences, selecting, 135–136

ROW function, 519, 982

rows (array), 473

rows (chart), 618–619

ROWS function, 520, 982

rows (table)

adding to PivotTable data, 715

hiding PivotTable labels, 724

implicit intersection, 700–701

inserting, 667, 671–672

new and changed features, 9

number of, 9

organizing, 669

selecting, 673

totals, 673–675, 701–702, 704

rows (worksheet)

AutoFill feature, 216

AutoFit feature, 335

banding, 271, 706, 708

cell references and, 431–432

charting hidden, 658

current, 702–703

deleting, 198–202, 272

design guidelines, 117–118

displaying or hiding, 944

duplicated, 698–699

extracting with filters, 689, 697–698

filtering, 684, 689–699

header, 269–271, 676–677, 704

headings, 96, 98, 414–415

height, 334–335, 336

hidden, 337, 658, 692

inserting, 194–196, 272

keyboard shortcuts, 940, 944

letters, 25

in mail merge data, 901

printing on each page, 414

resizing in Page Layout view, 406

returning identifiers, 519

returning numbers of, 520

selecting, 944

sorting, 675–677, 679–680

special item specifiers, 458

starting rows for imports, 751

summary, 270–271

using in names, 452

VLOOKUP and HLOOKUP functions, 513

RSQ function, 982

RTD function, 982

RTF (rich text formatting), 783, 893, 894, 895

rulers, 406

rules in conditional formatting, 290–294

run-time errors, 866–869

running

choosing applications to open files, 887

code step-by-step, 862–863

code to cursor points, 862

macro subroutines, 844–845

macros, 832

running heads or footers, 408–412

running totals, 733



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net