& (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
2008 Projections.xlsx file, 412