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

Index 763
nonadjacent selections Locked protection format,
441–442 overview, 126–127 selecting with
keyboard, 129 selecting with mouse, 128
None option, Paste Special dialog box, 214
Normal margins, 278 Normal view, 34
NOT function, 341, 619 NOW function, 372–373 NPV (Net Present Value)
function, 377–378 Number Format button, 146 Number Format cell
styles, 170–171 number formats
assigning, 149–150 creating, 155–157 custom, 152–155
for pivot tables, 680–681 predefined, 150–152
Number group, Home tab, 146–147
Number of Pages button, 288
number sign (#), 339 Number tab, Format Cells
dialog box, 149–157 Numbers Formatted as
Text or Preceded by an Apostrophe check box, 356
numeric cell entries dates and times, 89–91 filtering data lists by,
607–608
Fixed Decimal Places
feature, 99–100 inputting numbers, 88–89 numeric formulas, 91–92 overview, 85, 88
numeric formulas, 91–92 Numeric key, Touch
keyboard, 95
O
Object Browser window, 738 objective cells, 660
OData data feed, 633, 698 odd and even pages,
alternating headers
and footers for, 293 ODD function, 393 ODDFPRICE function, 387 ODDFYIELD function, 387 ODDLPRICE function, 387 ODDLYIELD function, 387 .ods file format, 120 Office, Microsoft. See
Microsoft Office Office apps, 66–68
Office Background setting,
20, 47
Office Clipboard, 208,
211, 499
Office Theme option, 47 Office14 folder, 70
OFFSET function, 417
Omit Column Name If Same
Column check box, Apply Names dialog box, 331, 333
Omit Row Name If Same Row check box, Apply Names dialog box, 331, 333
one-to-many copy, 319 one-to-many relationship,
623
one-to-one relationship, 623 one-variable data tables,
646–649
online graphics, setting as background images, 251
online pictures, inserting, 554
online resources, 226 online services, 20, 53 Open Data Protocol data
feed, importing data
from, 633, 698 Open dialog box
default settings for, 53 general discussion,
185–189
Open drop-down menu
options, 190 searching for files in, 189 selecting multiple files to
open, 189
Open File Location check
box, Info screen, 19 Open in Browser option, 642 Open screen, 184–187 OpenDocument Spreadsheet
file format, 120 Operation option buttons,
Paste Special dialog
box, 213 operators
for AutoFilter feature, 610–611
comparative, in selection criteria, 615
comparison, 306–307 precedence in formulas,
307–309
types of, 305–306
Options dialog box, 663–665 OR conditions, setting up,
615–617
OR function, 341, 619 order of worksheets in
workbook, rearranging, 251–252