https://peda.net/id/16104598054 2016-04-18T11:39:38+03:00 https://peda.net/:static/535/peda.net.logo.bg.svg <div class="license">Tämän sivun lisenssi <a rel="license" href="https://peda.net/info">Peda.net-yleislisenssi</a></div> https://peda.net/id/31be7b98054 2016-04-18T11:40:24+03:00 Käydään yhdessä läpi Google Sheets -ohjelman perustoiminnot. 2016-04-18T11:40:24+03:00 https://peda.net/id/bf852c14054 2020-02-20T13:26:51+02:00 Aloita tehtävä avaamalla uusi tyhjä Sheets -taulukko. Anna taulukolle nimeksi Harjoitus 1 ja jaa taulukko oikean yläkulman painikkeesta opettajalle (arja.karttunen@frosterus.net).<br/> <br/> Tee seuraavaksi alla oleva taulukko asiakirjaasi. Taulukossa kuvataan kokeen pisteiden suhdetta arvosanaan. Aloita taulukko siten, että nolla pistettä tulee soluun B5. Täydennä taulukkoon ylärajan pistemäärä ja puuttuvat arvosanat. <br/> <br/> <br/> <table><!--filtered attribute: cellspacing="0"--><!--filtered attribute: cellpadding="0"--> <tbody> <tr> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"alaraja"}"-->alaraja</td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"yl\u00e4raja"}"-->yläraja</td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"Arvosana"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->Arvosana</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":0}"-->0</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":0.5714285714285712}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]"-->1</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":4}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->4</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":1.5714285714285712}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->2</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":2.0476190476190474}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]"-->2</td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"4+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->4+</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":3.0476190476190474}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->3</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":3.5238095238095237}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]"-->4</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":4.5}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->4,5</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":5}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R8C1"-->5</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":6}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"5-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->5-</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":7}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->7</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":7.476190476190476}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"5"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":8.476190476190476}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->8</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":8.952380952380953}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"5+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":9.952380952380953}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->10</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":10.428571428571429}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"5 1/2"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":11.428571428571429}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->11</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":11.904761904761905}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"6-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":12.904761904761905}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->13</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":13.380952380952381}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"6"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":14.380952380952381}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->14</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":14.857142857142858}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"6+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":15.857142857142858}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->16</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":16.333333333333336}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"6 1/2"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":17.333333333333336}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->17</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":17.80952380952381}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"7-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":18.80952380952381}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->19</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":19.285714285714285}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"7"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->7</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":20.285714285714285}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->20</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":20.76190476190476}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"7+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":21.76190476190476}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->22</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":22.238095238095234}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"7 1/2"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":23.238095238095234}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->23</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":23.714285714285708}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"8-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":24.714285714285708}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->25</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":25.190476190476183}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"8"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":26.190476190476183}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->26</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":26.666666666666657}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"8+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":27.666666666666657}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->28</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":28.14285714285713}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"8 1/2"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":29.14285714285713}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->29</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":29.619047619047606}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"9-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":30.619047619047606}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->31</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":31.09523809523808}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"9"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":32.09523809523808}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->32</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":32.571428571428555}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"9+"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":33.571428571428555}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->34</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":34.04761904761903}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"9 1/2"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"--> </td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":35.04761904761903}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->35</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":35.523809523809504}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"10-"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->10-</td> </tr> <tr> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":36.523809523809504}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[-1]C[1]+1"-->36</td> <td><!--filtered attribute: data-sheets-value="{"1":3,"3":37}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"0",1]"--><!--filtered attribute: data-sheets-formula="=R[0]C[-2]+1"--> </td> <td><!--filtered attribute: data-sheets-value="{"1":2,"2":"10"}"--><!--filtered attribute: data-sheets-numberformat="[null,2,"@",1]"-->10</td> </tr> </tbody> </table> 2016-04-18T11:51:32+03:00