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

762 Excel 2013 All-In-One For Dummies
metadata, 18, 465 .mhtm file format, 119 .mhtml file format, 119 Microsoft Access,
importing data from,
623, 624–626 Microsoft Authenticode,
716 Microsoft Office
background of title bars, changing, 20, 47
data sharing between programs, 499–501 installations, viewing
information on, 21 Office apps, 66–68 themes for, 47
Microsoft Office Store website, 66–67
Microsoft Office Trusted Location dialog box, 718
Microsoft Office.com website, 554–556
Microsoft PowerPoint, 500–501, 506–507
Microsoft Query
data source definitions,
creating, 633–635 overview, 633 queries, specifying,
635–642
Microsoft Windows. See
Windows, Microsoft Microsoft Word, sharing
workbooks with,
501–506
Middle Align button, 145 MIME HTML (Multipurpose
Internet Mail Extension Hypertext Markup Language), 119
MIN function, 400 mini-courses on Excel, 35 minimizing Ribbon, 22
mini-toolbar, 22, 46, 148–149 MINUTE function, 374 mixed cell references,
318–319
Mode button, Status bar, 34 Modify Existing Outline
alert box, 240 modules, 710, 722, 724 MONTH function, 366–367 mortgage loan payments,
379–382 mouse
AutoSelect feature, 130–131 cell selection with, 127–128 click-and-drag
conventions, 26 column width, manually
adjusting with, 136 row height, manually
adjusting with, 138 selecting Ribbon
commands with, 24–25 wheel, using to scroll in
worksheets, 32 zooming with wheel, 200
Move Chart dialog box, 693 Move Chart option, 524 Move or Copy dialog
box, 252, 260 moving
data with cut-and-paste technique, 208–211
data with drag-and-drop technique, 207
graphics, 547–548 hyperlinks, 460–461 overview, 206
worksheets in workbooks,
251–252
Multiply option, Paste
Special dialog box, 214 Multipurpose Internet Mail
Extension Hypertext Markup Language (MIME HTML), 119
N
Name box, Formula bar, 27 Name Manager dialog box,
329–330
Name Order option, Apply
Names dialog box, 331 Name Splitter add-in, 71 names, using Flash Fill
feature with, 109–111 naming cell ranges, 133–134 Narrow margins, 279 navigating
data forms, 583
worksheets, 28–32 nesting parentheses in
formulas, 308–309 Net Present Value (NPV)
function, 377–378 Network button, Open
dialog box, 188 NETWORKDAYS function,
369–370
New command, File
menu, 20
new documents, linking
to, 458
New Formatting Rule dialog
box, 180, 181, 346 New Name dialog box,
324–325, 326
New Range dialog box,
446–447
New Rule option, 174 New Sheet button, 251 New Web Query dialog
box, 626–627
Next Page button, Print
Preview window, 276 Next Sheet button, 33 1900 date system, 89 1904 date system, 60, 89 NOMINAL function, 387