Leos_Excel_Practice_Midterm_With_Sol

# Leos_Excel_Practice_Midterm_With_Sol - A 1 2 3 4 5 6 7 8 9...

This preview shows pages 1–2. Sign up to view the full content.

Leo Kerklaan's - Monday night - in class MidTerm Practice Material - Introduction Note: Your midterm will have a help page with help on most if not all functions on your midterm. Be sure to download practice midterm material from webct. See Complementary material page The following basic functions work on cells that contain values. Text and empty cells are ignored. SUM, MAX, MIN, AVERAGE and COUNT (Note: Count adds 1 for each cell containing a value) The function COUNTA, counts 1 for each non empty cell or value or text string. Row Column D Column E 3 + 3.5 = 6.5 10 1 leo 1 =SUM(D10:D11)+AVERAGE(D13:D14) 11 2 12 peter The expression in cell B10 yields what? 13 3 100 a) A value less than or equal to 0 14 4 Lotus123 b) >0 and <= 5 c) >5 and <=10 d) > 10 e) None of the above for whatever reason 1+0+0 2 =MIN(D10:D12)+MAX(E10:E12)+MIN(E10:E12) Row Column D Column E 10+2=12 10 1 leo 3 =SUM(D10:D14,2) 11 2 12 peter 10+5+100=115 13 3 100 4 =SUM(D10:D14,5,E10:E14) 14 4 Lotus123 5 5 =COUNT(D10:E14) Row Column D Column E 10 1 leo 8 11 2 6 =COUNTA(D30:E34) 12 peter 13 3 100 14 4 Lotus123 7 =COUNTA(E10:E14,1,2*2) 2.5-1=1.5 8 =AVERAGE(D10:D14)-INT(1.9999) Row Column D Column E 10 1 leo -4 11

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

Leos_Excel_Practice_Midterm_With_Sol - A 1 2 3 4 5 6 7 8 9...

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

View Full Document
Ask a homework question - tutors are online