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




Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

Similar book on Amazon
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques
Microsoftu00ae Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
Microsoftu00ae Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
Special Edition Using Microsoft Office Word 2007
Special Edition Using Microsoft Office Word 2007
Microsoftu00ae Office Word 2007 Inside Out
Microsoftu00ae Office Word 2007 Inside Out

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net