Index

###### 46

#DIV/0 17, 45

#N/A 17

#NAME 17, 45

#NULL 45

#NUM 17, 46

#REF 17, 46

#VALUE 17, 46

& operator 87

A

ABS, 54
ACOS, 52
Active Cell, 4
Analysis Toolpak, 44, 142
AND, 70
Arguments, 44
Arithmetic operators, 15
Array formulas, 57, 88
ASIN, 52
ATAN, 52
ATAN2, 52
Auto Fill, 27
AutoSum tool, 46
AVERAGE, 277
AVERAGEIF, 81, 92
AVERAGEIFS, 81, 92
Axis position, 112

B

Banker’s rounding, 155
Bar chart, 101, 12
Bin range, 93
Boolean functions, 70

C

Calculate mode, 58
Calibration curve, 290
CEILING, 54
Cell address, 4
Cell names, 24
Cell reference, 4
absolute, 22
relative, 22
Charts, 101
area, 101
axis position, 112
bar, 101, 121
column, 101
combination, 120
control, 114
distribution coefficient, 126
dynamic, 124
elements, 103
error bars, 118

Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial