tugas excel

Download Tugas Excel

Post on 12-Jan-2016

5 views

Category:

Documents

0 download

Embed Size (px)

TRANSCRIPT

SOAL11779854384748260601510765589693417552199761718324354555689239659261006037537359173562704117813069931318437599521379617955308730263357146633573047134967709819417177614312721004395406880807178547555364943247220243455978214329499589597591002014852578886860521292548795435093235475651693897613434860659285208730259610030663299967071725793612969283817351751672387585341JUMLAHRATA-RATATERBESARTERKECIL

SOAL20.93561743510.00475004560.36106648530.33386017670.42992087540.25278662190.668426280.25880520280.26028008750.58536188480.85989563510.27641523930.723091210.53023616080.60155730760.2143046710.00921721830.94755768870.38786897290.08586794420.22110400040.74160521740.8159470130.35594137660.07628108270.69434011670.90549605730.29247948190.28764693820.4382862910.16678597680.08230751860.93773541040.88178003660.7577033660.83686535940.15583707770.44313527040.29389397980.35172342120.93057855830.02802669470.14013796940.30795497650.129933510.61223608370.65222448240.47290743120.30609794390.27772800170.07012797160.012357410.0286618150.17745018430.8116209310.13076390540.24805942520.37732544970.79545319730.91599959640.73609320780.89658623670.37106080040.47051216020.40762345010.24045096270.87265846120.14654463190.87056957720.79086569350.66462322870.40079562770.26655646520.47604545530.54039557090.40933227110.14228604620.19156958760.52166759160.35732618310.39354636390.77039287940.16925703890.65086642050.75455510710.71132120190.66615311060.36144275990.08421267450.96079237570.04529185940.38127435490.19238855020.67310713530.26275062060.05231902560.22778223770.85486716140.15840258560.2788359260.52779814670.05751571440.42099101350.00954031740.30546586730.51380294340.09119208730.43259925620.27753627810.93863511490.75735127790.96164204680.38617260530.49836629730.91815730230.16967609060.39295693060.00415384090.12562299680.21995776810.52591103780.18145073690.27966210540.1646193330.34865623740.34730131850.70821760930.76919987560.03623399320.23494785160.79494898730.23382439990.23637286240.84925908840.9113104380.25218008350.69548668180.55412296430.06352258420.54118640310.20982333460.80524864520.40915368020.70485177920.08736715430.74782802050.8582916410.55011472790.03471481960.12901229550.10527940230.25582106730.0088737670.3162149210.11066570440.15905344130.91733148250.28807717190.59773743690.49099357630.74347823130.99136571170.41769448110.98973787270.28890641110.57939864730.51705207360.80273786490.81977466130.22963516490.97121261410.35454671020.13198296140.71636071550.34372871840.32287926760.57440230420.12504403870.93429207520.8837212659JUMLAHRATA-RATATERBESARTERKECIL

SOAL3BCAAAECBEACDAEADDDBDEABABEDDEEBEBCBEBAEEDADBCBACCEABCABBCBDAACCECDBBAEABCAEBDDCDCABDBEBEEAEEECAACACADDAACEBEAEBDBBEAAEEEAACCDBAEACDBDDADDDCEDAECBEDCECACEDABBEBCEABCDDBEADBBCDBCBBCEBEDEAECABEADEAEECEBDEDDCBERAPA JUMLAH SEL DENGAN ISI HURUF ABERAPA JUMLAH SEL DENGAN ISI HURUF BBERAPA JUMLAH SEL DENGAN ISI HURUF CBERAPA JUMLAH SEL DENGAN ISI HURUF DBERAPA JUMLAH SEL DENGAN ISI HURUF E

SOAL4PURWAKARTAKARAWANGCIKARANGPURWAKARTACIKARANGCIKAMPEKKARAWANGCIKARANGPURWAKARTACIKARANGCIKARANGCIKAMPEKSUBANGCIKARANGCIKARANGCIKARANGCIKAMPEKCIKAMPEKSUBANGKARAWANGCIKARANGPURWAKARTAKARAWANGPURWAKARTACIKAMPEKSUBANGSUBANGKARAWANGCIKARANGCIKAMPEKKARAWANGCIKAMPEKKARAWANGPURWAKARTAKARAWANGSUBANGKARAWANGCIKARANGCIKAMPEKCIKARANGCIKARANGPURWAKARTACIKARANGPURWAKARTACIKAMPEKSUBANGKARAWANGCIKARANGCIKAMPEKPURWAKARTACIKAMPEKSUBANGPURWAKARTACIKAMPEKKARAWANGSUBANGCIKAMPEKCIKARANGSUBANGCIKAMPEKSUBANGCIKAMPEKSUBANGCIKAMPEKKARAWANGPURWAKARTAKARAWANGCIKARANGCIKARANGSUBANGKARAWANGPURWAKARTASUBANGCIKARANGCIKAMPEKCIKAMPEKSUBANGKARAWANGCIKARANGKARAWANGPURWAKARTAKARAWANGCIKAMPEKCIKARANGKARAWANGSUBANGCIKAMPEKCIKARANGPURWAKARTACIKAMPEKCIKAMPEKKARAWANGKARAWANGCIKARANGSUBANGCIKARANGCIKAMPEKCIKAMPEKCIKARANGPURWAKARTAKARAWANGCIKARANGKARAWANGCIKAMPEKPURWAKARTAPURWAKARTAPURWAKARTASUBANGPURWAKARTAKARAWANGCIKARANGSUBANGKARAWANGSUBANGCIKAMPEKPURWAKARTAPURWAKARTACIKAMPEKPURWAKARTACIKAMPEKCIKARANGCIKAMPEKCIKARANGCIKARANGCIKARANGCIKAMPEKPURWAKARTASUBANGCIKAMPEKCIKARANGCIKARANGCIKAMPEKKARAWANGKARAWANGKARAWANGCIKARANGSUBANGKARAWANGSUBANGCIKAMPEKCIKAMPEKCIKAMPEKSUBANGSUBANGKARAWANGPURWAKARTASUBANGSUBANGKARAWANGCIKARANGPURWAKARTACIKAMPEKKARAWANGSUBANGCIKAMPEKKARAWANGKARAWANGCIKAMPEKCIKARANGSUBANGCIKARANGCIKARANGCIKAMPEKPURWAKARTACIKAMPEKCIKARANGCIKARANGKARAWANGCIKARANGCIKAMPEKKARAWANGSUBANGCIKARANGSUBANGPURWAKARTACIKAMPEKKARAWANGSUBANGPURWAKARTACIKAMPEKCIKARANGPURWAKARTAPURWAKARTACIKARANGPURWAKARTACIKARANGSUBANGPURWAKARTACIKARANGPURWAKARTACIKARANGCIKARANGCIKARANGCIKARANGPURWAKARTAKARAWANGSUBANGCIKARANGKARAWANGSUBANGCIKARANGCIKARANGSUBANGSUBANGSUBANGKARAWANGCIKAMPEKKARAWANGCIKAMPEKCIKAMPEKKARAWANGKARAWANGKARAWANGCIKAMPEKPURWAKARTACIKARANGSUBANGCIKARANGSUBANGKARAWANGPURWAKARTACIKAMPEKPURWAKARTACIKAMPEKPURWAKARTASUBANGKARAWANGCIKARANGKARAWANGSUBANGSUBANGSUBANGSUBANGSUBANGCIKAMPEKKARAWANGSUBANGPURWAKARTAKARAWANGKARAWANGCIKARANGKARAWANGCIKAMPEKCIKAMPEKPURWAKARTAKARAWANGPURWAKARTAPURWAKARTASUBANGCIKAMPEKSUBANGPURWAKARTAJUMLAH SEL DENGAN ISI KATA CIKAMPEKJUMLAH SEL DENGAN ISI KATA KARAWANGJUMLAH SEL DENGAN ISI KATA SUBANGJUMLAH SEL DENGAN ISI KATA PURWAKARTAJUMLAH SEL DENGAN ISI KATA CIKARANG

SOAL5DATA 1DATA 2HASIL1DATA 3DATA 4HASIL2DATA 5DATA 6HASIL3DATA 7DATA 8HASIL424244604702082336951100852771526313823662445474578249677632953466437622856315140015878554683136745181100209124486554832369664888560858283733938680273652854357434681642944164667258974243332783878809362498574494615166272768410016632232399203322729168662242870551127655077485514447533393018568243119029612077724249363695164240337792952712669133571684019345382311416720579973569237349674504032298942783858877025336393289313228080143638607831371959

JUMLAHJUMLAHJUMLAHJUMLAHRATA-RATARATA-RATARATA-RATARATA-RATATERKECILTERKECILTERKECILTERKECILTERBESARTERBESARTERBESARTERBESARKETERANGANHASIL1 = DATA 1 X DATA 2HASIL2 = DATA 3 / DATA 4HASIL3 = DATA 5 + DATA 6HASIL4 = DATA 7 - DATA 8

SOAL6KODENILAIC24105E53218E71994C19368A44281B61653A66841C60650E38388C39110C18267D25744D38856D90062D45661E10488E49617C50157A33721A33754D2203A42733B17041B9979A20208TOTAL968099JUMLAH NILAI AJUMLAH HURUF AJUMLAH NILAI BJUMLAH HURUF BJUMLAH NILAI CJUMLAH HURUF CJUMLAH NILAI DJUMLAH HURUF DJUMLAH NILAI EJUMLAH HURUF ETOTALTOTAL

SOAL7

KODE1BARANG1KODE2BARANG2KODE3BARANG3KODE4BARANG4KODE5BARANG5SMAMOSMAMSLMBMSSMBMSLMBMSLPBDOLPADSSPAMSSPBMOLPBMSSMBDSLMAMSLPBMOSPAMSSMADSKETERANGANGUNAKAN FUNGSI IFJIKA KODE1="S", "SOUND CARD"JIKA KODE1="L", "LAND CARD"JIKA KODE2="M","MEMORY"JIKA KODE2="P","PROCESSOR"JIKA KODE3="A","SUPERVISOR"JIKA KODE3="B","LEADER"JIKA KODE4="M","MANAGER"JIKA KODE4="D","DIREKTUR"JIKA KODE5="O","OPERATOR"JIKA KODE5="S","STAFF"

SOAL8GROUP AGROUP BGROUP CGROUP D170.9930366512473.4263419489655.6049589668111.797567471305.3970757216911.8384303296447.0902159971648.571105625924.7562007149852.5809129471997.9520210352392.512702376725.2232134202972.6377260572906.369114921556.4631706687154.9348831515892.685445530455.593964669815.6577594951781.2571419075922.9108702952746.3160040732241.1336621251688.5168843678380.6418898771867.921596743765.2525579068110.070328306191.2790574238810.563397541132.4481325466398.1972287487430.004554976573.5276789175762.1061361541974.9057697292719.501508837368.6936959855263.4179005353948.1705459296401.6158107059861.4614470529904.321351241594.7575086708129.2062090276157.320913385823.6601262644895.8677142367216.990835156714.75318848382.6936354483924.4018243305549.93361579529.976790411191.5277649379352.6563573089344.9887743612577.3382762579421.3671615591698.5624368113167.485887299250.6251617436349.5882300132213.0815830544338.2491057475896.9384815991167.5087679784286.3013751784419.7135652677950.9296131088569.6462847681369.5323533157501.2112945876423.368563345475.6900800445372.6909743071729.6028472665818.9472034084192.4669818435236.907419495375.5046628325281.1437509292600.4025009981381.482367124208.8463381404400.2383281063185.901215708389.5910712241640.4668137779344.0760551038235.0777474208150.2762833851217.2063374126611.7228357774100.6433950509GROUP EGROUP FGROUP GGROUP H772.4200550918147.2553617402882.1892393974836.846437275519.1877168315980.7551404511293.0628819401193.4917772573723.5305256801799.3623572684823.137823722174.5049124197622.7178955952247.615312456814.6734762358356.5526647886524.5013483882616.669009268987.3746615965114.2494617985405.2799013925291.5450870552371.0035871155746.8784402138415.1547478696538.1521653275266.3137025609642.5416715002491.3946825263166.5585162804172.6996564092237.3302980881503.2156709511612.0900081348365.702472135672.2264667479212.2667551219773.3249847861254.4998851086963.0396724019837.5119637096474.1360596647869.8641197785533.9660045078141.6070626353866.9160819127900.1121563119944.9609938405167.1140148836584.6376450777125.2825650812461.75946962493.70236518319.4177885355868.5127403262579.41649670050.7345853727100.683063446965.6337833351913.2173166641249.2614283794890.5808776523931.1565561045713.80927691547.9692833391504.870055606750.0853348842450.011330037776.5448077723330.064469669491.9562221986470.0401660808614.88721491594.9317263631622.3842544421316.9451018514455.8928533841300.471307039319.8272805931383.3084336072967.8601761217380.5497345278783.7317123074774.8200237385852.59383851728.370821253475.576391129276.2548454279927.6020163208952.4841429031955.0842894207837.011535063219.1169672064513.9560784041756.9282016057867.373927661GROUP IGROUP JGROUP KGROUP L251.648123301646.4882989873673.6232837604923.3217583347488.2569768815664.2283611601102.8609319377649.7734874111173.0509252515199.5854256208375.9069074933461.610695718237.1160998129347.218418499921.3610910274857.51887818971.9491602193952.4974986782310.6680547798658.4556378302288.8820145734808.9029589554702.5493021491628.5419529077579.7286277133415.984670502699.7639319959758.9317883448629.0825207345292.6910621216161.1463917266514.3538909969451.8138223808438.7159396579845.1170289203657.6930488777518.7682725814172.0449763341643.6231352763802.2585