Q

qualified structured references, 459, 460–461

QUARTILE function, 557, 979

queries

Query Wizard, 760–763, 764

specifications in ODC files, 745

Web-based, 779–785

Query

adding or removing fields from tables, 767

adding or removing tables, 766

aggregate calculations, 774–777

aggregate fields, 776–777

Automatic Query vs. Manual, 772

calculated fields, 777

compared to Query Wizard, 764

comparison criteria, 773–774

cycling through totals or functions, 775–776

editing SQL code in Query, 764

exact matches, 770–772

executing queries, 772

filtering records, 761–762, 774

filtering result sets, 769–770

grouping records, 776

hiding criteria or tables panes, 771

hiding fields, 768

joining operations, 767

opening, 763–766

overview, 759–760

parameter-based queries, 777–778

Query Wizard, 760–763, 764

renaming fields, 768

returning result sets to Excel, 778–779

saving queries, 763–764, 778

sorting records, 763–764

sorting result sets, 768–769

tools, 770

unique entries, 774

window elements, 766

Query Wizard, 760–763, 764

question mark (?), 225, 689

Quick Access Toolbar

adding tools, 84–88

attaching customized toolbar to workbooks, 92–94

commands and options, 907–925, 923

commands not on Ribbon, 88

creating buttons, 91

customizing command modifiers, 89

customizing command tabs, 86–87

customizing contextual tabs, 86

customizing from drop-down list, 86–87

deleting buttons, 94

deleting tools, 85

disappearing toolbars, 94

displaying hidden controls, 89–90

macros, 91

mini Ribbon, 88

More Controls button, 89–90

organizing tools, 85–88

overview, 38–39

positioning, 83–84

restoring defaults, 94

ScreenTip schemes, 95

separating tools, 86

Quick Print feature, 418

Quick Watch feature, 865

quotation mark ("), 142–143, 458

QUOTIENT function, 979