This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: EX 339 Data, Subtotals, At each change, St; Use function, Sum; Add subtotal to Quota, YTD and CLEAR Grade EX 342 Remove All EX 343 Select cell A8:J20, Data, List, Create List, OK EX 344 Data Form EX 346 NOTE: query means the process of filtering out unwanted records EX 348 Show All ( NOT remove all as in subtotal) EX 351 NOTE: Criteria Area heading, note actual criteria range EX 351-352 Advanced filter: Criteria Range, Database, Extract Range EX 352 Filter in Place EX 353 Show all records after filtering in place: Data, Filter, Show All EX 354 Copy to another location = Extract Area NOTE: Extract Area heading, not actual extract range EX 358 #5 Cell R5: Spell Age exactly like you did in cell C9, watch out for extra spaces, be sure to add quotes around the Age, “Age”; EX 359 Spell Gender and Grade exactly, no spaces, and with capitals EX 360 Be sure to put quotes around “A” and “F”...
View Full Document
- Spring '07
- extract range ex, Data validation EX, dialog box EX, Data Form EX, CLEAR Grade EX