1Reprezentarea "grafic" a distribuiei notelorDistribuia notelorCod studentNota ExamenNotaNumr noteDistribuia grafic a notelor5548.25152||||||||||||||||||||||||||||||||||||||||||||||||||||2998.75270||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||3318.25353|||||||||||||||||||||||||||||||||||||||||||||||||||||19010.00459|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||5319.00570||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||27110.00648||||||||||||||||||||||||||||||||||||||||||||||||5497.25760||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||7152.50851|||||||||||||||||||||||||||||||||||||||||||||||||||1046.50961|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||5898.2510111|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||3001.007081.25566.502083.00722.756315.001378.253026.253126.506326.757231.506488.504159.753042.256383.256592.753929.0033910.004021.006233.002549.503051.751084.506043.507189.003701.253545.2566.255066.00647.00291.753132.751844.004774.002922.00592.50899.504343.751839.506451.252826.50714.501001.003153.507259.001016.254519.256124.503162.503178.502749.756676.506175.251277.50793.75771.001564.007046.505293.752963.251727.00815.005710.0045710.004322.005863.255418.752253.253309.75443.2514410.002207.252169.503241.501351.003289.503088.25426.506443.502006.506993.0012910.001715.253292.001739.003205.503359.501927.002601.003364.503799.006374.502069.0034110.002482.753448.503452.751127.503101.003678.253468.752771.001522.002310.007164.752912.504114.502765.751857.506083.751051.255645.252366.753491.002222.501867.0025110.004432.759810.005002.253349.75668.503551.004747.503603.001028.253752.755683.755992.002396.504701.256816.255371.006685.753649.003664.756625.002248.00125.252410.005593.5073.5065310.006249.503732.504037.503762.254415.253502.005934.752988.0032510.007203.505103.006613.251433.254045.0042610.00469.003783.252689.00621.751239.756726.501345.505979.505798.504975.751684.503653.253837.255529.001694.006205.506196.75411.0012610.007105.006346.003379.502294.753871.002846.751116.00266.2539310.004866.502428.001881.004792.005410.003959.753401.253971.001653.503075.003615.254001.251392.006742.206338.005137.504018.754063.254891.006510.00493.50189.505704.50281.007131.006785.25877.004072.754186.502695.005748.002347.254905.754687.7539610.004089.504149.505424.504304.507129.00534.506134.506224.756555.00924.506069.756039.50479.502281.251249.004165.506777.502944.501186.25384.502157.754171.254199.754353.006824.506888.50931.004363.00179.003886.251801.501326.006841.5023810.001256.506216.506266.502138.75317.50849.50944.253435.504585.254814.506428.504383.2519910.00701.0048510.006472.006662.505509.502953.5039.756573.25158.002109.004395.507023.004595.003811.004427.756941.002738.0037210.004454.504473.75117.005828.254226.504485.001162.00810.006925.254494.502275.507079.757223.753279.506872.001387.5091.003211.503527.251974.756407.50679.252933.003597.754733.504677.755538.756521.0018.505483.001742.254558.005986.255110.004606.501643.256692.751418.002571.506291.256021.004625.755844.504633.756586.004464.5030310.006255.751953.504567.502611.003823.506009.502301.0028510.00611.005719.754106.504755.25806.251211.002099.255561.001576.006809.752417.501469.001332.00353.001202.752263.252071.002805.751932.002652.503941.00919.50306.25395.254763.754804.501818.504875.0048810.00452.004271.501631.504831.752358.755431.253581.001093.251365.004916.505449.507143.002784.502794.50271.002195.75149.751606.254942.25782.001424.7570010.00134.756982.003384.502176.251616.752538.501782.005015.505210.004310.005021.506963.505034.751071.004258.003627.251135.751405.2538610.0011710.006931.251158.0052.251194.75881.001511.502036.505059.505757.006653.254536.003331.006412.104788.00481.005081.505094.501627.255147.752666.5021410.004209.755157.7529.505162.001593.501874.001144.756978.005199.755181.001496.502409.502884.754010.004528.256055.005212.2530110.0017910.005774.505229.00741.00683.753536.754444.504374.754846.255738.755237.255251.003329.503479.254692.005729.755955.502052.506281.2524710.003913.75859.005281.251482.254318.50962.002452.503992.007065.003310.0018210.005928.756852.752468.505119.006515.506795.005364.501896.503683.751677.502023.7546410.005337.755049.7526210.006276.509710.00322.0065410.009910.001473.505349.755391.7523210.0037410.00362.007032.753422.506117.002863.506606.003895.007096.256461.006712.256899.505510.005328.255576.506736.504331.006561.001703.006105.002214.508310.005010.005878.506755.75638.25217.755581.004828.005963.757215.751068.002186.751039.004244.50732.005601.504289.506955.256764.502833.756864.506011.007179.752638.505179.754231.752704.502597.505612.003771.5025610.004611.005629.755637.751301.001312.002891.006076.7525510.006305.252433.505659.506394.506906.00226.002041.75901.004507.002126.253902.004938.006141.254669.0038510.005453.255675.753410.007242.001983.501283.502378.755763.755352.002448.755807.505667.755519.006631.0058110.006153.00869.007011.505832.0022310.003181.255853.753577.005889.504954.50691.506361.755903.503983.004718.002492.755911.002752.755784.501582.506495.503148.254134.504406.253061.252904.751103.003568.501229.50

2Nume PrenumeSucursalaDepartamentData nateriiData angajriiVechimea (ani)Salariu ncadrareNume PrenumeCod numeric personalPOPESCU Viorel DanDoctor FelixCreditareMon Apr 03 00:00:00 ICT 20065 ani1,000 leiALBITER Oana2491107345633MIHAI Carmentefan cel MareCreditare?Sat Sep 13 00:00:00 ICT 198031 ani2,900 leiALBU Constanta2770904444890POPA Florintefan cel MareCorporaii?Tue Jun 22 00:00:00 ICT 199912 ani1,180 leiBLAGA Mdlina2611123546967ALBU ConstantaDoctor FelixCreditare?Tue Feb 24 00:00:00 ICT 197042 ani2,900 leiCHIRU Bogdan1560817341871NEDELCU Mihaitefan cel MareOficiul juridic?Wed Jun 12 00:00:00 ICT 198526 ani2,790 leiCOMAN Aura2800304227773CHIRU BogdanPlevneiOficiul juridic?Wed Dec 12 00:00:00 ICT 197932 ani3,200 leiCONSTANTIN Ana2501207472590ALBITER OanaPlevneiCreditare?Sun Oct 16 00:00:00 ICT 198328 ani2,900 leiDEDU Natalia2610722114674VLAD Petrutefan cel MareRelaii clieni?Wed Aug 08 00:00:00 ICT 200110 ani1,180 leiGANEA Pavel1701101555889CONSTANTIN AnaDoctor FelixCorporaii?Wed May 05 00:00:00 ICT 20047 ani1,050 leiMANESCU Andreea2811010510053MONDREA Lauratefan cel MareCreditare?Sun Apr 09 00:00:00 ICT 20065 ani1,000 leiMIHAI Carmen2600227503812SAVU Ctlintefan cel MareAsigurari?Mon Mar 20 00:00:00 ICT 197834 ani2,900 leiMIHAI Dinu1550602422877PANAIT Corneltefan cel MareAsigurari?Wed Oct 10 00:00:00 ICT 198427 ani2,500 leiMONDREA Laura2600615100121COMAN Auratefan cel MareAsigurari?Tue Dec 12 00:00:00 ICT 20065 ani1,000 leiNEDELCU Mihai1810130333655BLAGA MdlinaPlevneiCorporaii?Mon Aug 17 00:00:00 ICT 198130 ani2,800 leiPANAIT Cornel1590501673895MIHAI DinuDoctor FelixOficiul juridic?Fri Jul 06 00:00:00 ICT 197932 ani3,200 leiPETRE Cristina2660809310349DEDU Nataliatefan cel MareCorporaii?Thu Feb 02 00:00:00 ICT 20066 ani1,050 leiPOPA Florin1501001701902GANEA Paveltefan cel MareCreditare?Thu Nov 14 00:00:00 ICT 20029 ani1,200 leiPOPESCU Viorel Dan1621212345345SORESCU LianaPlevneiCreditare?Fri Apr 21 00:00:00 ICT 20065 ani1,000 leiSAVU Ctlin1700404222888PETRE CristinaDoctor FelixRelaii clieni?Fri Apr 18 00:00:00 ICT 198031 ani3,350 leiSORESCU Liana2680312508405MANESCU Andreeatefan cel MareOficiul juridic?Tue Apr 04 00:00:00 ICT 20065 ani1,050 leiVISAN Alexandra2721225557812VISAN AlexandraPlevneiCorporatii?Sun Nov 16 00:00:00 ICT 197536 ani3,200 leiVLAD Petru1600205667445

3

Cod Produs123123412332122345657357890321341234568950490S se calculeze preul mediu, presupunnd c acesta este editat ncepnd de la valoarea poziional 3 pn la 5 n codul compozit din cmpul A3:A8. Pretul va fi rotunjit prin adaos la un multiplu de rotunjire de 10.

4

Cod compozit n patru trepte variabileIdentificarea valorii pozitionale aferente primului SPATIUIdentificarea valorii pozitionale aferente celui de-al doilea SPATIUIdentificarea valorii pozitionale aferente celui de-al treilea SPATIUExtragerea primului grup de caractereExtragerea celui de-al doilea grup de caractereExtragerea celui de-al treilea grup de caractereExtragerea ultimului grup de caractereCod recompus nalt ordine (prin concatenare)0001 AAA ZZ 9 59120001AAAZZ9 AAA00019 ZZ01 A ZZZZ 99 351001AZZZZ99 A0199 ZZZZ001 AA Z 9999 479001AAZ9999 AA0019999 ZObservaie: Alegerea succesiunii de afiare a grupurilor de caractere din codul compozit recompus rmne la latitudinea studentului.

5Nume PrenumeSucursalaDepartamentCodul salariatuluiGenul (M=masculin F=feminin)Vrsta (ani)Data angajriiVechimea (ani)Salariu ncadrareCNPCod numeric personalPOPESCU Viorel DanDoctor FelixCreditareM46 aniMon Apr 03 00:00:00 ICT 20062 ani1,000 leiALBITER Oana2491107345633MIHAI Carmentefan cel MareCreditare?F49 aniSat Sep 13 00:00:00 ICT 198028 ani2,900 leiALBU Constanta2770904444890POPA Florintefan cel MareCorporaii?M58 aniTue Jun 22 00:00:00 ICT 19999 ani1,180 leiBLAGA Mdlina2611123546967ALBU ConstantaDoctor FelixCreditare?F31 aniTue Feb 24 00:00:00 ICT 197039 ani2,900 leiCHIRU Bogdan1560817341871NEDELCU Mihaitefan cel MareOficiul juridic?M28 aniWed Jun 12 00:00:00 ICT 198523 ani2,790 leiCOMAN Aura2800304227773CHIRU BogdanPlevneiOficiul juridic?M52 aniWed Dec 12 00:00:00 ICT 197929 ani3,200 leiCONSTANTIN Ana2501207472590ALBITER OanaPlevneiCreditare?F59 aniSun Oct 16 00:00:00 ICT 198325 ani2,900 leiDEDU Natalia2610722114674VLAD Petrutefan cel MareRelaii clieni?M49 aniWed Aug 08 00:00:00 ICT 20017 ani1,180 leiGANEA Pavel1701101555889CONSTANTIN AnaDoctor FelixCorporaii?F58 aniWed May 05 00:00:00 ICT 20044 ani1,050 leiMANESCU Andreea2811010510053MONDREA Lauratefan cel MareCreditare?F48 aniSun Apr 09 00:00:00 ICT 20062 ani1,000 leiMIHAI Carmen2600227503812SAVU Ctlintefan cel MareAsigurari?M38 aniMon Mar 20 00:00:00 ICT 197831 ani2,900 leiMIHAI Dinu1550602422877PANAIT Corneltefan cel MareAsigurari?M49 aniWed Oct 10 00:00:00 ICT 198424 ani2,500 leiMONDREA Laura2600615100121COMAN Auratefan cel MareAsigurari?F29 aniTue Dec 12 00:00:00 ICT 20062 ani1,000 leiNEDELCU Mihai1810130333655BLAGA MdlinaPlevneiCorporaii?F47 aniMon Aug 17 00:00:00 ICT 198127 ani2,800 leiPANAIT Cornel1590501673895MIHAI DinuDoctor FelixOficiul juridic?M53 aniFri Jul 06 00:00:00 ICT 197929 ani3,200 leiPETRE Cristina2660809310349DEDU Nataliatefan cel MareCorporaii?F47 aniThu Feb 02 00:00:00 ICT 20063 ani1,050 leiPOPA Florin1501001701902GANEA Paveltefan cel MareCreditare?M38 aniThu Nov 14 00:00:00 ICT 20026 ani1,200 leiPOPESCU Viorel Dan1621212345345SORESCU LianaPlevneiCreditare?F41 aniFri Apr 21 00:00:00 ICT 20062 ani1,000 leiSAVU Ctlin1700404222888PETRE CristinaDoctor FelixRelaii clieni?F42 aniFri Apr 18 00:00:00 ICT 198028 ani3,350 leiSORESCU Liana2680312508405MANESCU Andreeatefan cel MareOficiul juridic?F27 aniTue Apr 04 00:00:00 ICT 20062 ani1,050 leiVISAN Alexandra2721225557812VISAN AlexandraPlevneiCorporatii?F36 aniSun Nov 16 00:00:00 ICT 197533 ani3,200 leiVLAD Petru1600205667445Codul salariatului reprezint un cod compozit care conine: primele 4 litere din departament, luna (n format abreviat ir de caractere) i anul naterii n format abreviat.Exemplu: salariatul Visan Alexandra are codul Corp-dec72

6

Nume PrenumeCod salariat (SUBSTITUTE)Nume PrenumeIndicativ loc de muncALBU Constana?POPESCU Viorel DanS221PETRE Cristina?MIHAI CarmenA117POPA Florin?POPA FlorinT400DEDU Natalia?ALBU ConstanaT400COMAN Aura?NEDELCU MihaiB222NEDELCU Mihai?CHIRU BogdanA117MIHAI Dinu?ALBITER OanaS337VLAD PetruT400CONSTANTIN AnaS221Indicativ loc de muncNr. apariiiMONDREA LauraA117A117?SAVU CtlinS221PANAIT CornelB2221. S se calculeze codul salariatului tiind c acesta reprezint un cod compozitCOMAN AuraB222format din 2 elemente: numele salariatului i indicativul locului de munc al acestuia.BLAGA MdlinaA117Exemplu: ALBU T400MIHAI DinuT400DEDU NataliaS3372. S se calculeze numrul total de apariii ale indicativului B222 n cmpul B4:B10.GANEA PavelS337SORESCU LianaT400PETRE CristinaS221MANESCU AndreeaA117VISAN AlexandraA117

7

Denumire disciplin de informaticDenumire disciplin de informatic (cu spaiile dintre cuvinte eliminate)Nr. total de spaiiMarcarea ultimului spaiu cu simbolul "*" Calcularea valorii poziionale a ultimului spaiuUltimul cuvnt din denumirea disciplineiSisteme Informatice de GestiuneBazele Tehnologiei InformaieiTehnologia Aplicaiilor OfficeSisteme de Asistare a DecizieiProgramarea CalculatoarelorSisteme Integrate de GestiuneManagementul Documentelor

S se extrag ultimul cuvnt din agregatul tip ir de caractere Denumire disciplin de informatic

8Cmpul B2:O11 = "Indici"Cmpul Q2:T15 ="Imobilizari"Categorie Mijloc Fix19981999200020012002200320042005200620072008200920102011Numr ordineDenumire mijloc fixData punerii n funciuneValoare de inventar10.1500.1680.1860.2040.2220.2400.2580.2760.2940.3120.3300.3480.8660.9845478AAA2/12/982,523.70 lei20.1000.1250.1500.1750.2000.2250.2500.2750.3030.3250.3500.3750.7500.9255479BBB2/18/0912,547.83 lei30.0800.1000.1200.1400.1600.1800.2000.2200.2400.2600.2800.3000.6200.9405480CCC9/3/003,550.00 lei40.0750.8700.6650.4600.2550.0500.8450.6400.4350.2300.0250.8200.8620.9415481DDD1/25/993,695.00 lei50.1000.1600.2200.2800.3400.4000.4600.5200.5800.6400.7000.7600.8200.8805482EEE6/6/061,754.01 lei60.0500.1100.1700.2300.2900.3500.4100.4700.5300.5900.6500.7100.7700.8305483FFF11/8/006,500.00 lei70.2000.2200.2400.2600.2800.3000.3200.3400.3600.3800.4000.4200.8400.9605484GGG4/12/002,765.82 lei80.0850.1140.1430.1720.2010.2300.2590.2880.3170.3460.3750.4040.8330.9625485HHH6/14/0719,469.52 lei90.4270.4500.4750.5000.5250.5500.5750.6000.6250.6500.6750.7000.7250.8505486III8/30/014,785.00 lei5487JJJ2/4/021,548.78 lei5488KKK8/6/9821,547.80 lei5489LLL3/17/043,583.00 lei5490MMM3/12/116,500.00 leiNumr de inventar Valoare de inventarCoeficient de reevaluareValoare reevaluat2547912547.830??454906500.000??7548519469.524??154782523.699??

1. Valoarea de inventar se recupereaz din tabelul de consultare "Imobilizari", n funcie de numrul de ordine aferent agregatului "Numr de inventar"

2. Coeficientul de reevaluare se extrage din tabelul "Indici", n funcie de codul categoriei mijlocului fix (primul caracter al agregatului "Numr de inventar")i de anul punerii n funciune (care se extrage din tabelul de consultare "Imobilizari", n funcie de numrul de ordine aferent agregatului "Numr de inventar")

3. Valoarea reevaluat se calculeaz aplicnd coeficientul de reevaluare la valoarea de inventar, fiind rotunjit la un multiplu de rotunjire de 1 leu.Observaie: Dac anul de punere n funciune este anul curent, valoarea reevaluat va fi valoarea de inventar.