MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

2017-07-07 02:10:07

hiding

columns, 14, 114–115

comments, 507

highlighting cells with conditional formatting, 164, 166–167

Histogram dialog box, 278–279

histograms

bin ranges, 277

bin ranges, defining, 278

comparing, from different data sets, 282–283

defined, 277

formatting, 279–280

gaps in, removing, 279

labels, displaying, 279–280

multiple peaks, 282

shapes for, 280

skewed left, 281

skewed right, 281

symmetric, 280–281

HLOOKUP function

for price that changes by date, 14–15

syntax, 12

HOUR function, 94.

Категории