week08 - WELCOME EF 105 Spring 2006 Week 8 Topics Reviewed...

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

View Full Document Right Arrow Icon
    WELCOME WELCOME EF 105                Spring 2006 Week 8
Background image of page 1

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

View Full DocumentRight Arrow Icon
    Topics Reviewed Resolution of Duplicate Homework 2 Originator’s score: 50% of grade Duplicators’ score: 0 Demonstrate to Dr. Jackson the ability to do  problems before Quiz3 and regain points up to  score of Originator Vote on reallocation of Quiz points Currently, MC = 60% and App = 40% Quiz #2 Solution and Excel Basics Review Extra Credit: +1 for Pseudocode; and +1  for Flowchart to all group members
Background image of page 2
    Excel Basic Functions ABS(number) AVERAGE ( number1 ,number2, . ..)   COS(number) EXP(number) LN(number) LOG10(number) NORMDIST ( x mean standard_dev, cumulative ) PI() SIN(number)  SQRT ( number ) STDEV ( number1 ,number2,. ..) SUM ( number1 ,number2, . ..)  TODAY() or NOW()
Background image of page 3

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

View Full DocumentRight Arrow Icon
    Q2: Multiple Choice 1.) The formula =C3+C4+C5 has been copied from cell C7 to cell E7.  The formula bar will display ___________ when the cell selector is in  cell E7. a) =C7+D7+E7 b)  =C3+C4+C5 c) =E4+E5+E6 d)  =E3+E4+E5 Ans: D 2.) In the function =SUM(B12:B20), the argument is: a) the overall structure of the function b)  B12:B20 c) SUM d) the "=" sign Ans: B 3.) You want to display the lowest bowling score in the league. The  fastest way to do this would be to use the ________ function. a) MIN b)  LOW c) SUM d)  COUNT Ans: A
Background image of page 4
    Q2: Multiple Choice 1) 4.) Which of the following functions gives the same result as  totaling a range of values and dividing the result by the number of  values in the range? a) SUM b)  AVERAGE c) MEAN d)  COUNT Ans: B 2)      5.) Cell B3 contains the value 5; cell B4 contains the value 10;  cell B5 contains the value 2. What value will be displayed by the  formula =B3+B4*B5? a) 30 b)  60 c) 52 d)  25 Ans: D 3)     6.) All macro shortcuts begin with the _____ key. a) [Ctrl] b) [Alt] c) [Shift] d)[Esc] Ans: a
Background image of page 5

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

View Full DocumentRight Arrow Icon
    Q2: Multiple Choice 1) 7.) A(n) _____ is a formatted worksheet with blank spaces that can be  filled in online. a) survey b) form c) questionnaire d) control Ans: b 2) 8.) A(n) _____ is a description of a cell or range of cells that can be  used in place of cell references. a) macro b) range reference c) name d) range name Ans: d        9.) Using a function within another function is referred to as a(n): a) multiple function b)  pasted function c) nested function d)  combo function Ans: c         10.) A control that allows the user to select from a list of options is called  a(n) _____.
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 42

week08 - WELCOME EF 105 Spring 2006 Week 8 Topics Reviewed...

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

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