0 Assessement questions of the EASE basic Excel workshop online SY
wJs1 Z 89 pwn`&nTpn npw
1 4 9 pw4 89 Z ğnwJ1wMV1wX1wv0w l k hs $5 @ Y ! ğn w J1w MV1w X1w v0w l k hs $5 @ Y ! Tp t=nI1 w1pw MV1wMV1wTr'w>w w MV1whpwTr'w Vji1 *w w ϸ F
t $$l /ta|u` r|u[ $TPtNi fkTtQt%ؤj @IQtB {up{up{u0 ! ( ,Htx ! ( ! Ht]x x 40 ]ؤj\=t! ( untitled 0 x ! 0 |u0 x 5ou NAI \@t @t
2 (d2x ! 0 t}u X 0 dou NAI H)q (dq ( ] ?x ! jOtlFt!> ̒ ̒ 6q 3 ̒ 4F:t6q6q
jR% pݻ6q @6 ^<lFt'> j R% ݻ
pݻ pݻxE C R pݻpݻ yj Ft!> DȠtPVw F pݻՠt̒ 5jdh$ PVw̒ t 0 C Y P xm ! t U [ xm b xmw,/ t pݻ xmxmT[+t xmxmͫ [ xm<|tw < < ~wh , <Wh w ,< | p gi<8ywh,( $yw h / o $ ( . Supplementary Material 2 c Freeze panes [ Sort ] Filter d Entering Data j What information is NOT available via the EASE website - Basic Excel for Bio 203L Supplementary Material? [rSpqUemEta] Fill in the Blank 2 l turn your filter off, interspersed values g highlight all the data, the top rows + scroll to the top, the top rows i scroll to the top, interspersed values b Whe you 'freeze panes' make sure to ________because otherwise you may not be able to see________. [rSpqUemEta] Formulas 2 a Nothing, this is not a problem o You get an invalid entry ] You get the correct answer What happens if you do not close the formula before clicking back to your original worksheet? [rSpqUemEta] Average 2 5.72 18.42 21.71 51.21 What is the average Neck size (to 2 decimal places) of Sex 2 Bears? [rSpqUemEta]
Paste Special 2 Because the presenter wanted us to go through unnecessary motions Because “paste” would copy all of the header values and we don’t want ‘sex’ included t They do the same thing, there is not a difference Because “Paste” would have moved the function and given us an incorrect number in the target cell Why did we use a “Paste Special” option, rather than a standard “Paste”? [rSpqUemEta] Column Graph 2 p I can’t tell based on the current graph P ; Yes, Weight N Yes, Length _ Yes, all of the measurements z No, none of the error bars overlap. Based on the column graph, are there any measurements were the error bars do not overlap, thus you could imply that that pair of measurement is statistically different between sexes? If yes, which measurement? [rSpqUemEta]
Scatter Plots 2 } y = 3.2052x + 73.641, R² = 0.6952 } y = 2.1838x + 40.011, R² = 0.5575 | y = 0.2462x + 44.71, R² = 0.7239 It is not possible to determine this information What are the equation and R-squared for Sex 2 scatter plot? [rSpqUemEta]
Trendlines d s I can’t tell based on the current graph(s) k Sex 1 bears live longer than sex 2 bears Sex 2 is overall smaller at each given age, and sex 1 has a steeper relationship between age and weight compared to sex 2 Sex 2 is overall larger at each given age, and has a steeper relationship between age and weight compared to sex 1 There is less scatter in sex 2 bear weight with respect to age than there is in sex How do the trendlines of the two sexes compare? In other words, what can you conclude about sex 1 vs sex 2 with regards to their age to weight relationship? [rSpqUemEta] Special Paste: 2
Paste- destination theme Paste- Source formatting
Paste picture Paste- Text only What is the paste special option in the presentation suggested for transfering tables/graphs into a word or power point document? [rSpqUemEta] [rSpdOcmEta] , $ 2cf85f4e-4144-420f-9f4c-71b5f84ff4f8