CSCI 1310 Lecture Notes - Lecture 1: Square Root, Parallelogram, Inverse Trigonometric Functions
Document Summary
Properties: attributes of objects (value, text, count, column, row, address, etc) Methods: actions to be taken on objects (select a cell or ranges, clear) Selection. cells(3,3) (row 3 column 3 of current selection) Can use excels functions like using pi by application. worksheetfunction. pi() Ask user for a number and display the square root. Start (circle) input x (parallelogram) square root of x (square) output y (parallelogram) end (circle) Double: used for numbers with decimal fractions and possibly exponents where high precision or extended range are required. Range: from about 10^308 down to 10^-309, both + and . String: used to store text (just a word) Boolean (also called logical): used for t/f information. Sequence (cid:894)flo(cid:449) (cid:272)ha(cid:396)t(cid:895): (cid:862) ta(cid:396)t(cid:863) (cid:894)(cid:272)i(cid:396)(cid:272)le(cid:895) (cid:862)do so(cid:373)ethi(cid:374)g(cid:863) (cid:894)s(cid:395)ua(cid:396)e(cid:895) (cid:862)do this(cid:863)(cid:894)s(cid:395)ua(cid:396)e(cid:895) (cid:862)do that(cid:863) (square) (cid:862)e(cid:374)d(cid:863) (cid:894)(cid:272)i(cid:396)(cid:272)le(cid:895) One way: if the(cid:374) (cid:862)sta(cid:396)t(cid:863) (cid:894)(cid:272)i(cid:396)(cid:272)le(cid:895) (cid:862)is it t(cid:396)ue o(cid:396) false? (cid:863) (cid:894)dia(cid:373)o(cid:374)d(cid:895) (cid:862)false(cid:863) do(cid:374)"t do anything (cid:862)t(cid:396)ue(cid:863) (cid:373)ake a state(cid:373)e(cid:374)t (cid:894)s(cid:395)ua(cid:396)e(cid:895) (cid:862)e(cid:374)d(cid:863) (cid:894)(cid:272)i(cid:396)(cid:272)le(cid:895)