DfunctionReview

DfunctionReview - The Excel Dfunctions The Excel database...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The Excel Dfunctions The Excel database functions, or dfunctions, do two things: 1. They extract selected data from a list, based on criteria you specify. 2. They summarize the extracted data by means of a calculation. Commonly-used dfunctions include DSUM, DAVERAGE, DMAX, and DMIN. The syntax of the dfunctions is: = dfunction-name(database, database-column, criteria-range) The dfunction extracts data from the column of the list you specify, using the criteria you specify to choose which values to extract. The criteria range for a dfunction is defined the same way as a criteria range for Excel's Advanced Filter. As ignm ent 1 Level 1T ask 3 output. A S u b s e t o f t h e J u ic e C a n L is t S y nta x : = d func tio n- na m e (d a ta b a s e , d a ta b a s e - c o lum n, c rite ria - ra ng e ) C rite ria : B r a n d Siz e H * 4 6 Ex a m p le s : D SU M 0 S um s e le c te d V o lum e s . D A V ER A G E #V A LU E! G e t the a v e ra g e o f s e le c te d 5 2- W k $ S a le s . D M A X 0 G e t the m a x im um S iz e o f the s e le c te d ite m s . D M IN $ 0 .0 G e t the m inim um S a le s R a te o f the s e le c te d ite m s . M arke t B rand Siz e 52-Wk D ist . Vo lu m e 52-Wk $ Sale s Sale s R at e Albany C AM PB 46 98% 40,510 $169,050 $89.60 Albany C AM PB 24 39% 3,792 $26,919 $36.8 Albany D LM N T 46 92% 29,501 $123,958 $63.36 Albany D N D C K 46 18% 2,798 $23,376 $62.96 Albany D N D C K 46 16% 2,37 $15,32 $50.67 Albany D O LE 46 9 % 26,830 $167,756 $83.41 Albany H IC 46 9 % 26,103 $98,7 4 $4 .92 Albany H IC 46 96% 20,28 $75,972 $32.90 Albany H IC 46 95% 2 ,461 $83,8 7 $4 .16 Albany H IC 46 92% 14,364 $53,526 $23.84 Albany H IC 46 64% 9,897 $38,524 $30.07 Albany H IC 46 59% 6,78 $26,53 $23.75 Albany H IC 46 42% 3,693 $14,726 $18.14 Albany H IC 46 42% 4,061 $18,3 0 $14.40 Albany H IC 46 24% 1,24 $7,309 $12.68 Albany H IC 46 21% 970 $7,248 $17.38 Albany H IC 46 18% 935 $4,138 $8.69 Albany H IC 46 14% 624 $3,751 $14.65 Albany H PN C H 46 45% 2 ,7 8 $70,367 $80.84 Albany H U N TS 46 74% 5,85 $29,01 $12.08 Albany H U N TS 46 16% 3,425 $14,419 $46.24 Albany JC YJC 46 9 % 59,784 $408,385 $217.96 Albany JC YJC 46 9 % 48,093 $329,7 3 $168.6 Albany JC YJC 46 96% 45,3 0 $314,01 $165.61 Albany JC YJC 46 95% 39,689 $268,758 $146.0 Albany JC YJC 46 59% 24,185 $169,715 $14 .3 Albany JC YJC 46 4 % 17,565 $120,486 $142.25 Albany LIB Y 46 63% 6,863 $51,460 $40.31 Albany LIB Y 46 15% 1,381 $5,076 $9.39 Albany LIB Y 46 7% 1,182 $6,958 $47.9 Albany PL 46 98% 87,919 $281,929 $150.54 Albany PL 46 92% 25,953 $157,524 $87.10 Albany PL 46 90% 39,164 $213,324 $125.40 Albany PL 46 79% 16,9 0 $95,371 $59.47 Albany PL 46 52% 9,284 $38,820 $38.10 Albany PL 46 48% 3,156 $25,185 $26.05 Albany PL 46 46% 6,750 $47,565 $48.21 Albany PL 46 3 % 17,530 $49,950 $74.27 Albany PL 46 29% 1,162 $10,508 $14.46 Albany R D G LD 46 58% 15,538 $61,917 $54.7 Albany R D G LD 18 35% 1,630 $12,026 $15.03 Albany R D G LD 46 2 % 2,364 $14,064 $30.96 Albany SEN C A 46 20% 5,432 $35,747 $87.08 Albany...
View Full Document

Page1 / 6

DfunctionReview - The Excel Dfunctions The Excel database...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online