ࡱ> 65 I\pTom Blum Ba==&8X@"1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1@0Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0% 0.000%                + ) , *   @ (   (X  H   (  @ !   `@   @    ! A         H5  *x"@@ *  *x"@ *  *x " @ * !P*  P*  8@@  8@  8  @  8@  8  8  8 @  8  8 `Formulas5 Graphing 1@8 Graphing 2%@ Formatting87The Formatting SheetAdamsAddamsAbdoAdboBetheBarthBartBortzBoyleBurkeBerryAmico 1. Average =2. Standard deviation = 3. Minumum = 4. Maximum =x,Time for rat to go through maze (in minutes) 5. Median = 6. (1-cos(x))/2*7. Square root of previous column+9. Product of previous two columns81. Merge cells A1 through G1 and center the above title.#2. Put the title in 36 point font. 3. Put the title in bold. 4. Make the font blue. BensenBogartD5. Shade in the header cells (this row) in yellow.6. Reduce the width of this column7. Delete this columnd8. Format this column as percents with two places beyond the decimal point (e.g. 12.35%)58. 1 if sin(x/2) > 0 and -1 otherwiseAge-Number of females alive at beginning of year +Number of males alive at beginning of year ZScottish Bird Data (Campbell, Biology, p. 1098)I P 54. Change the color of the plot area to a light greend2. Place the graph on this worksheet, move it and stretch it so that it covers cells A14 through J28=6. Change the axis scales so that the maxima are 1000 and 8. k5. Fit to an exponential, display the equation and the R2 value on the chart. The font size should be 9 pt.89q3. Label the axes Age (in years) and Number of Surviving Females as appropriate. The font size should be 10 pt.  %A a =b =c =Make a plot of the function f(x)=ax2+bx+c versus x for x=0 to x=5 with points separated by 0.1. Use the values a, b and c below. You should use absolute addressing so that your plot is updated if I change the values in the cells corresponding to a, b and c. #$81. Make a plot of Number of Surviving males versus age.  79. Clear this column/10. Center the entries in this column11. Wrap this cell412. Aphabetize (sort) the items in this list(13. Format this column as dollars.HAll calculations should be done using Excel formulas (nine calculations)f(x)2T t Y  yb    bbb b  ҁҁ(Н0   @L azp0ZbbZbbtS0hbt00{b(@Hb{T0?  @!!!@""" @###jfffff @$$$733333 @%%% @&&& @'' @(((kfffff@)))833333@***@+++hfffff@,,,@---433333@...@///@000ffffff@111@222233333@333@444@555dfffff@666@777033333@888@999@:::bfffff@;;;@<<<.33333@===@>>(>@??(?`fffff@@Dl)))))))))))))))))))))))))))))))@T0AbBbCDEFGbHbIJҁҁKLMN@LO PQRbS0TUbVWXbYXZe[b\b]b^T0_@(@@A(A,33333@BB(B@CC(C@DD(%D^fffff@'DC?E(E@FEEVL?F(F*33333@GEG(G@HEH(H@IEI(I\fffff@JEJ(J@KEK(K(33333@LEL(L@MEM(M@NEN(NZfffff@OEO(O@PEP(P&33333@QEQ(Q@RER(R@SES(S,33333 @TET(T_fffff @UEU(U @VEV(V @AEW(W @XWWa L?X(X+33333!@YWY(Y^fffff!@ZWZ(Z!@[W[([!@\W\(\!@]W](]*33333"@^W^(^]fffff"@_W_(_"@`WDl))))3F)))))))))))))))))F)))))))`T0abbbcdef`(`"@aWa(a"@EWb(%b)33333#@cDa?c(%c\fffff#@dDb?d(%d#@eDc?e(%e#@WDd?f(%f#@bDe?x))3333>@  I  Q67  dMbP?_*+%"??U T0bb b ..//////0122222231222222345555556 +~ b@ ,~ v -~ @  6&>@    I #:(??  dMbP?_*+%MHP LaserJet 4M Plus@w XX@MSUDOHP LaserJet 4M Plus<d "dXX??U} $ } I } $ } #  vT0@  b@ @b @ @ @ @ b@ @b @ ҁ@ҁ @ @ @ @@L @  @ @ b@ 0@ @ b@ @ @ @b @X e@ b@ @ @ @b @ )% **+ " # $?@@@@ ,/,,,,, @0x@z@ -'----- @`e@j@------ @S@@[@ -*----- @B@F@------ @,@7@ ,&,,,,, @@ @ -)-----   @?@ ------ ,( ,,,,, Dl*>>2>2>>2" T0@! b@" @b <(>@ :        I AH  dMbP?_*+%MHP LaserJet 4M Plus@g XX@MSUDNHP LaserJet 4M Plus;d "dXX??U} I } I }  } I }  (!Aphabetize the items in this list  T0 b b     b b  ҁҁ   @L b0b      % % $ % $0 %1 &2 %3 %4?&@@P@"|Pk?@!@m@$@  ~ r@ 7@6@@ "y? @!u@8 A  ~ C@ |@@@@ "UMu? @!|@8A ~ F@ @F@@ "]].;? @!@TA ~ <@ @K@@ "67',? @!0@T!A  ~ n@ 2"P@"@ "ׁ? ?!@o) ~ @@aA*@S@@S@"?@!Ћ@((A ~ ;!  ! ! !  ! ! ! !!4R~ffffff\  >@ Oh+'08@Th  Info Tech  Tom Blum Microsoft Excel@@|O՜.+,D՜.+,H PXt | La Salle Universityj  Formulas Graphing 1 Graphing 2 Formatting  Worksheets 6> _PID_GUIDAN{14AD8A80-6C1B-11D2-AAD8-0000C051BDEB}  !"#$&'()*+,./01234Root EntryRoot F2bWorkbookFbbWork bbLISummaryInformationLISum(rmation7b%DocumentSummaryInformationDoc8maryInformation$@-