Leos_Excel_Practice_Midterm_With_Sol

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

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

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 Right Arrow Icon
Ask a homework question - tutors are online