Page 793 - Excel 2013 All-in-One For Dummies

Index 775
sparkline graphics, adding, 542–543
transferring from one workbook to another, 259–260
workbook design, 82–85 Workspace feature, 260–262 Wrap Text option, 145, 158,
159–160
X
XIRR function, 388 .xls file format, 119,
121–122
XLStart folder, 261
.xlsx file format, 119 .xltx file format, 120 .xlw file format, 260–262 XML files, 119, 633
XNPV function, 388
XOR function, 341
XPS (XML Paper Specification)
file format e-mailing workbooks
as, 494
overview, 120
saving and exporting files
as, 508, 509–510 XPS Document file
format, 120
Y
YEAR function, 366–367 YEARFRAC function, 371–372 years
calculating number elapsed, 363
Date function, 365 two-digit, 91, 355
YEAR function, 366–367 YEARFRAC function,
371–372
YIELD function, 388 YIELDDISC function, 388 YIELDMAT function, 388
Z
0, In number format codes, 153
zero values, removing display of, 345–346
Zoom to Page button, Print screen, 275
zooming
controls for, 199–201 before deleting rows and
columns, 232 with IntelliMouse, 56 in Print Preview
window, 275 Zoom slider, Status
bar, 34