S11 IE 148 Exam 1 Review

S11 IE 148 Exam 1 Review - x=x+1 Next I Average=sum/x Min...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style IE 148 Exam 1 Review Spring 2011 - Sly
Background image of page 1

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

View Full DocumentRight Arrow Icon
Dim Single, String, Integer 1D Array X(10) as Integer 2D Array X(10, 3) as integer (row,column) Math Functions SIN(x) where x is in radians 1rad = angle*3.14/180 X^2, 6*(7+1) NOT 6(7+1)
Background image of page 2
Logic T and T = T T and F = F T or F = T F or F = F Tests (a=5) or (x=“d”) evaluate to True or False
Background image of page 3

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

View Full DocumentRight Arrow Icon
VBA (strings) VBA #3 Dim str as String = “Dave” 4=LEN(str) “D”=MID(str,1,1) “VE”=MID(str,3) “DAVE” = UCASE(str) “dave”=LCASE(str)
Background image of page 4
Branching If (a=1) then b=2 If (a=1) then b=2 Elseif (a=3) then b=3 Else b=4 Endif
Background image of page 5

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

View Full DocumentRight Arrow Icon
Looping (Do Loop) Do if (ans=“Y”) then EXIT Do Loop Do While A<10 Loop Do Loop Until A=10
Background image of page 6
Looping (For Next) For i=1 to N if (ans=“Y”) then EXIT Do Next i For i=1 to 7 step 3 Next I For r=1 to Row For c=1 to Col Input #1, X(r,c) Next c Next r
Background image of page 7

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

View Full DocumentRight Arrow Icon
For i=1 to 10 sum=sum+i
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11

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

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: x=x+1 Next I Average=sum/x Min and Max maxVal=x(1) minVal=x(1) For i=1 to 10 if x(i) &gt; maxVal then maxVal=x(i) if x(i)&lt;minVal then minVal=x(i) Next I VBA Files Open data.dat for INPUT as #1 Open data.out for OUTPUT as #2 Open data.out for APPEND as #3 Input #1, x Print #2, x Close #1 Excel Graphing Graphing with Power, Exponential and Linear Functions Absolute and Relative Cell References Graphical Analysis Linear Function - Plot as a straight line on uniform grid (rectilinear) paper Y = mx + b Exponential Function -Plot as straight line on semi log paper Y = bemx Power Function -Plot as straight line on log-log paper Y = bxm Exam 1 Review Do Loops For Next If Statements Strings, Integers, Singles, Booleans Files Math Statements Excel Formulas and Graphing...
View Full Document

This note was uploaded on 08/22/2011 for the course IE 148 taught by Professor Davesly during the Spring '11 term at Iowa State.

Page1 / 13

S11 IE 148 Exam 1 Review - x=x+1 Next I Average=sum/x Min...

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

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