Symbols and Numbers


& (ampersand), 436–437, 458

' (apostrophe, single quote), 142–143, 458, 835, 852

* (asterisk, multiplication sign), 225, 427, 458, 689

\ (backslash), 142–143

{ } (braces), 458, 469, 471

[ ] (brackets)

Query, 777–778

structured references, 457, 458, 704–705

time and date notations, 529

time codes, 528

^ (caret), 142–143, 458

: (colon), 458, 840

, (comma)

array constants, 471, 472

formatting while typing, 297–298

imported data, 755

separating arguments, 491, 840

structured references, 457, 458

styles of, 298

© (copyright symbol), 228

/ (division sign, slash)

data entry, 139

formatting while typing, 297–298

keyboard command activation, 40

operator precedence, 427

structured references, 458

$ (dollar sign)

cell references, 429–430

data entry, 138

formatting while typing, 297–298

structured references, 458

= (equal sign), 427, 458, 478, 840

> = (greater than or equal to operator), 478

> (greater than operator), 458, 478

- (hyphen), 753

< = (less than or equal to operator), 478

< (less than operator), 458, 478

- (minus sign), 138, 256, 427, 458

<> (not equal to), 478

() (parentheses)

argument syntax, 841

functions and, 438, 490

negative numbers, 138

operator precedence and, 427

. (period), 458, 755

% (percent sign), 139, 297–298

+ (plus sign), 138, 256, 427, 458

# (pound sign)

##### error display, 531

expand cell indicator, 140

structured references, 458

? (question mark), 225, 689

" (quotation mark), 142–143, 458

; (semicolon), 471, 472

~ (tilde), 225, 689

_ (underscore character), 840

1-dimensional arrays, 468–469

1-variable data tables, 583–586

2-dimensional arrays, 470

2-variable data tables, 586–587

3-dimensional arrays, 470

3-dimensional cell references, 448–449

3-dimensional chart axes, 651–652

3-dimensional formulas, 453–454

3-dimensional graphic effects, 378–381

3-dimensional rotation, 370, 371

4-part formats, 312

12- and 24-hour clocks, 523, 528

12/31/29 magic crossover date, 523

1900 and 1904 date system, 522

2008 New Projects.xlsx, 151

image from book 2008 Projections.xlsx file, 412



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