vipolnenie prakticheskix navikov v ms excel

DOC 11 pages 749.5 KB Free download

11 pages

FaylHub.uz

Download via Telegram

Size 749.5 KB

File type DOC

Pages 11

Updated Dec 2025

Page preview (5 pages)

Scroll down 👇

1 / 11

zanyatie. laboratornaya rabota №1. vipolnenie prakticheskix navikov v ms excel tsel raboti: pravilnoe poshagovoe vipolnenie prakticheskix navikov pri vvode i obrabotke dannix v programme elektronnix tablits. ispolzuemie sredstva i prinadlejnosti: kompyuter, listok s zadaniem poryadok vipolneniya raboti 1. vvesti dannie v rabochiy list. 2. vipolnit sootvetstvuyushie operatsii. 3. rezultati predstavit v vide tablitsi. tselraboti: pravilnoe poshagovoe vipolnenie prakticheskix navikov pri vvode i obrabotke dannix v programme elektronnix tablits. ispolzuemie sredstva i prinadlejnosti: kompyuter, listok s zadaniem teoreticheskaya osnova vse dannie v microsoft excel predstavlyayutsya v vide tablitsi. vopredelennie yacheyki vvodyatsya pervichnie dannie. ostalnie yacheyki zapolnyayutsya obrabotannimi dannimi. v yacheyku mojno vvesti dannie trex vidov: — tekstovie; —tsifrovie; — formulu. tekstovie dannie vklyuchabt v sebya zagolovki, simvoli, primechaniya. tsifrovie znacheniya – eto neposredstvenno vvedennie tsifri. formuli — vichisleniya novix znacheniy na osnove formul. pered vvodom formuli vsegda pishetsya znak «=». posle vvoda formuli v dannoy yacheyke visvetitsya rezultat vichisleniya. pri izmenenii …

2 / 11

etsya zarabotok rabotnikam za proshedshiy mesyats v zavisimosti ot kolichestva otrabotannix dney i dnevnoy oplati truda. zapolnite ee uchitivaya sleduyushie momenti: 1. "nachisleno" vichislyaetsya, kak proizvedenie "otrabotano dney" i "stavka v den" 2. podoxodniy nalog vzimaetsya iz rascheta 13% ot "nachisleno". 3. vznos v pensionniy fond - kak 1% ot "nachisleno". 4. "na ruki" vichislyaetsya , kak "nachisleno" minus "pod.nalog" i "pens.fond".oformit tablitsu s granitsami, raspolojiv dannie po tsentru yacheek, nazvanie stolbtsov i strok doljni bit napisani polnostyu, primenit, gde neobxodimo jirniy shrift, viravnyat shirinu yacheek. otrabotano dney stavka v den nachis-leno pod. nalog pens. fond na ruki familii sotrudnikov ivanov 22 120 000r. -r. smirnov 23 100 000r. -r. sergeev 25 97 000r. -r. vasilev 27 124 000r. -r. semenov 22 132 000r. -r. voynov 21 150 000r. -r. mironov 20 86 000r. -r. tokarev 28 76 000r. -r. shemuranov 30 100 000r. -r. stolyarov 26 98 000r. -r. …

3 / 11

grafiki funktsiy: y1 = ax^3 + bx^2 + cx + d y2= ax^2 + bx + c ( x izmenyaetsya ot -20 do +20 s shagom 0.5; znacheniya a,b,c, d zadayusya v otdelnix yacheykax ) a=2, b=3, c=-5, d=-4 variant № 3 1.predstavlennaya nije tablitsa doljna pomoch administratsii instituta opredelit kolichestvo studentov zaslujivshix poluchat stipendiyu po rezultatam sessii. ispolzuyte sleduyushie kriterii: menee 18-ti ballov - stipendiyu ne poluchaet, ot 23,5 ballov vklyuchitelno - povishennaya stipendiya. spisok diff. analit. tenzor vektorn teoriya obshiy stipendiya studentov ur-ya geometr analiz algebra grupp ball da/net/povish ivanov 4,5 3,0 3,5 5,0 3,5 19,5 petrov 4,0 4,0 4,0 3,5 4,0 19,5 sidorov 3,5 5,0 5,0 4,0 5,0 22,5 savelev 3,0 4,5 3,0 3,0 3,5 17,0 smirnova 3,5 3,5 3,0 3,0 3,5 16,5 stepanova 3,5 4,0 5,0 5,0 5,0 22,5 vasilev 5,0 5,0 5,0 5,0 5,0 25,0 vasina 5,0 4,5 4,0 5,0 4,5 23,0 detochkin 4,5 5,0 …

4 / 11

ova 3,5 4,0 5,0 5,0 5,0 22,5 lenskiy 5,0 5,0 3,0 5,0 4,0 22,0 shemuranov 5,0 3,0 5,0 5,0 5,0 23,0 nevzorov 3,5 3,5 3,5 4,0 4,5 19,0 tsipinov 4,0 4,0 4,0 5,0 5,0 22,0 nosov 5,0 5,0 4,0 5,0 5,0 24,0 solntsev 4,5 4,5 4,5 5,0 4,5 23,0 kotov 5,0 5,0 5,0 4,0 4,0 23,0 kotovskiy 5,0 5,0 5,0 5,0 5,0 25,0 2.sostavte tablitsu znacheniy lineynoy funktsii y=kx+b, vibrav po svoemu usmotreniyu koeffitsient k i svobodniy chlen b. x -6 -5 -4 -3 -2 -1 0 1 2 3 4 5 6 y naprimer, k=3 i b=5 postroyte tochechnuyu diagrammu funktsii y=kx+b na osnove tablitsi. variant № 5 1. predstavlennaya nije tablitsa doljna pomoch komendantu obshejitiya opredelit kolichestvo yunoshey i devushek, chtobi pravilno raspredelit ix po korpusam obshejitiya. primechanie: ispolzuyte komandu schetesli spisok pol abiturientov jen/muj ivanov muj petrov muj sidorov muj savelev muj smirnova jen stepanova jen solntsev …

5 / 11

+ bx^2 + cx + d y2= ax^2 + bx + c ( x izmenyaetsya ot -20 do +20 s shagom 0.5; znacheniya a,b,c, d zadayusya v otdelnix yacheykax ) a=2, b=3, c=-5, d=-4 variant № 7 1.sostavte tablitsu perevoda dollarov v rubli po obichnomu i lgotnomu (bolshe $100) kursu. konkretnie znacheniya kursov obmena zadayutsya v yacheykax v8 i v9. zadacha reshaetsya s pomoshyu vvoda formuli v yacheyku v10 i kopirovaniya ee v v11:v43. kurs $ 67,52 lgotniy kurs $ 68,23 na ruki 5 10 15 20 25 45 50 55 60 65 70 75 95 100 105 150 155 160 165 170 2.sozdat grafik funktsii y = ax^3 - bx + c ( x izmenyaetsya ot -20 do +20 s shagom 0.5; znacheniya a,b,c zadayusya v otdelnix yacheykax b9:b11) a=3,b=-3, c=4 variant № 8 1.predstavlennaya nije tablitsa doljna pomoch priemnoy komissii instituta opredelit kolichestvo abiturientov uspeshno sdavshix vstupitelnie ekzameni. …

Want to read more?

Download all 11 pages for free via Telegram.

Download full file

About "vipolnenie prakticheskix navikov v ms excel"

zanyatie. laboratornaya rabota №1. vipolnenie prakticheskix navikov v ms excel tsel raboti: pravilnoe poshagovoe vipolnenie prakticheskix navikov pri vvode i obrabotke dannix v programme elektronnix tablits. ispolzuemie sredstva i prinadlejnosti: kompyuter, listok s zadaniem poryadok vipolneniya raboti 1. vvesti dannie v rabochiy list. 2. vipolnit sootvetstvuyushie operatsii. 3. rezultati predstavit v vide tablitsi. tselraboti: pravilnoe poshagovoe vipolnenie prakticheskix navikov pri vvode i obrabotke dannix v programme elektronnix tablits. ispolzuemie sredstva i prinadlejnosti: kompyuter, listok s zadaniem teoreticheskaya osnova vse dannie v microsoft excel predstavlyayutsya v vide tablitsi. vopredelennie yacheyki vvodyatsya pervichnie dannie. ostalnie yacheyki zapolnyayutsya obrabotanni...

This file contains 11 pages in DOC format (749.5 KB). To download "vipolnenie prakticheskix navikov v ms excel", click the Telegram button on the left.

Tags: vipolnenie prakticheskix naviko… DOC 11 pages Free download Telegram