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

766 Excel 2013 All-In-One For Dummies
Properties area, Info screen, 19
Properties dialog box, 19 Properties option, 642 Protect Shared Workbook
dialog box, 453–454 Protect Sheet dialog
box, 442–444 Protect Structure and
Windows dialog box,
452–453
Protect Workbook button,
Info screen, 18 Protected View, opening
files in, 190 protecting data. See also
passwords
cell range editing,
enabling, 445–450 data entry in unlocked
cells, 450–451
general discussion, 440–441 Hidden cell formatting,
changing, 441–442 Locked protection status,
changing, 441–442 overview, 433
Protection feature, 442–445 scenarios, 653
workbooks, 452–454 Publish as PDF or XPS
dialog box, 509 Publish as Web Page dialog
box, 511 purchasing third-party
add-ins, 71
PV (Present Value) function,
376–377
Q
Query Wizard, 635–639 querying data. See also advanced filtering;
Microsoft Query
from Access tables, 624–626
conditional formatting, filtering by, 609
customizing filtering, 609–612
database functions, 620–622
date, filtering by, 605–607 external, general
discussion, 622–624 general discussion, 602–603 numbers, filtering by,
607–608
from other data sources,
632–633 overview, 601 specific field entries,
filtering by, 603–605 text, filtering by, 605 from text files, 628–632 Top Ten option, filtering
with, 607–608
from web pages, 626–628
question mark (?) wildcard, 217, 263, 406, 614
Quick Access toolbar Compare and Merge
Workbooks command
button, adding, 479–480 customizing, 41–42
Form button, 581–582 general discussion, 26–27 macros, adding to, 44–45,
719–720
non-Ribbon commands,
adding to, 43–44 overview, 16
Print Preview button, 275 Quick Print button,
276–277 repositioning buttons
on, 42
Ribbon commands,
adding to, 42–43
Save button, 116
Text to Speech buttons,
adding to, 229 Touch/Mouse Mode
button, 16, 25, 26, 42 Undo command
options, 192
Quick Access Toolbar tab,
Excel Options dialog
box, 42, 43–44 Quick Analysis tool
and Conditional
Formatting feature, 176 formulas, 304–305 inserting charts with,
521–522
overview, 46, 125 pivot tables, creating
with, 668–669 tables, formatting
with, 143
Quick Layout option,
523, 524
Quick Print button, 276–277 quitting Excel, 39
R
R1C1 cell reference system, 50, 314–315
radar charts, inserting, 519 range names
applying to existing formulas, 330–333
building formulas with, 327–328
column headings, creating from, 328–329
for constants, 326–327 defining, 324–326
for formulas, 326–327 general discussion,
323–324
hyperlinks for, 456, 458