Tugas Excel

Download Tugas Excel

Post on 12-Jan-2016

5 views

Category:

Documents

0 download

Embed Size (px)

TRANSCRIPT

<p>SOAL11779854384748260601510765589693417552199761718324354555689239659261006037537359173562704117813069931318437599521379617955308730263357146633573047134967709819417177614312721004395406880807178547555364943247220243455978214329499589597591002014852578886860521292548795435093235475651693897613434860659285208730259610030663299967071725793612969283817351751672387585341JUMLAHRATA-RATATERBESARTERKECIL</p> <p>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</p> <p>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</p> <p>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</p> <p>SOAL5DATA 1DATA 2HASIL1DATA 3DATA 4HASIL2DATA 5DATA 6HASIL3DATA 7DATA 8HASIL424244604702082336951100852771526313823662445474578249677632953466437622856315140015878554683136745181100209124486554832369664888560858283733938680273652854357434681642944164667258974243332783878809362498574494615166272768410016632232399203322729168662242870551127655077485514447533393018568243119029612077724249363695164240337792952712669133571684019345382311416720579973569237349674504032298942783858877025336393289313228080143638607831371959</p> <p>JUMLAHJUMLAHJUMLAHJUMLAHRATA-RATARATA-RATARATA-RATARATA-RATATERKECILTERKECILTERKECILTERKECILTERBESARTERBESARTERBESARTERBESARKETERANGANHASIL1 = DATA 1 X DATA 2HASIL2 = DATA 3 / DATA 4HASIL3 = DATA 5 + DATA 6HASIL4 = DATA 7 - DATA 8</p> <p>SOAL6KODENILAIC24105E53218E71994C19368A44281B61653A66841C60650E38388C39110C18267D25744D38856D90062D45661E10488E49617C50157A33721A33754D2203A42733B17041B9979A20208TOTAL968099JUMLAH NILAI AJUMLAH HURUF AJUMLAH NILAI BJUMLAH HURUF BJUMLAH NILAI CJUMLAH HURUF CJUMLAH NILAI DJUMLAH HURUF DJUMLAH NILAI EJUMLAH HURUF ETOTALTOTAL</p> <p>SOAL7</p> <p>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"</p> <p>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.258504134914.0991179447404.4913933622228.6749771634130.1755552704666.785928279974.9190258944433.1207666093961.8571026176826.3373694518865.1177519223250.7016392626121.3503865446963.3436432207448.385532846798.1894384637278.5367043693360.6042822516338.8129901923433.0078137548638.8854915772216.6969264036968.4287199017827.9170367265945.4547628749756.0005866467567.1551086284773.7298455942101.4664962398119.682560507886.621779841972.8688467088456.64243731428.2923088083290.2753276334643.2752451872333.5842307505408.5765469872393.02077132623.217304434499.9546080834153.9777624969879.5767799973231.0021738859234.275832906740.7512570092101.1455714395787.1455192597265.1049538433351.8281451911235.3325378265222.5483214872218.384546229546.7630095001344.343341824890.7142905781728.3579866195JUMLAH GROUP A HINGGA GROUP LRATA-RATA GROUP A HINGGA GROUP LMAX GROUP A HINGGA GROUP LMIN GROUP A HINGGA GROUP LJML ANGKA GROUP A HINGGA GROUP L</p> <p>SOAL9NILAINILAINILAINILAINILAIANGKAHURUFANGKAHURUFANGKAHURUFANGKAHURUFANGKAHURUF83.0711.7032.0932.2076.0730.6680.7657.3754.5336.0546.1863.6584.2639.6557.5940.0968.5517.2237.0487.4275.0878.7275.1452.0613.4391.1791.8261.7278.0462.5619.9535.5080.4013.3469.0331.9966.8236.1136.9411.5518.7311.7527.6955.3180.3773.2766.5551.3532.3210.9296.7675.1219.7455.6195.0330.7196.3254.4366.2411.4923.5395.0399.3376.4095.0970.5042.5623.1768.6067.6323.3326.8490.2090.8155.8569.2471.4886.1812.7871.5311.7525.4939.2263.1337.2384.5975.4068.0664.0777.3616.1765.6765.3371.4682.8310.0435.4181.0055.6663.8256.8332.1586.6611.5456.4080.4219.9590.5251.8463.1160.8074.2215.9177.2669.6989.7081.5180.3654.6277.72NILAIHURUF&gt;89A&gt;79B&gt;69C&gt;59D&gt;49E</p> <p>SOAL10KODEJABATANKODEJABATANKODEJABATANKODEJABATAN4532341414422515524425542153313252232223442322145335322133424545143334513123141525145415151255233145KETERANGANGOL1OPERATOR2STAFF3SUPERVISOR4MANAGER5DIREKTUR</p> <p>SOAL11HIJAUHIJAUKUNINGMERAHBIRUUNGUUNGUUNGUUNGUUNGUBIRUBIRUKUNINGMERAHUNGUHIJAUHIJAUKUNINGKUNINGBIRUKUNINGKUNINGUNGUHIJAUBIRUHIJAUKUNINGMERAHHIJAUBIRUKUNINGMERAHUNGUBIRUMERAHHIJAUKUNINGHIJAUMERAHMERAHUNGUHIJAUUNGUKUNINGKUNINGBIRUHIJAUUNGUHIJAUKUNINGBIRUHIJAUUNGUUNGUBIRUUNGUBIRUHIJAUBIRUBIRUHIJAUMERAHUNGUHIJAUUNGUKUNINGUNGUBIRUUNGUBIRUHIJAUUNGUKUNINGHIJAUBIRUMERAHMERAHBIRUMERAHMERAHMERAHHIJAUMERAHKUNINGUNGUHIJAUMERAHBIRUUNGUKUNINGHIJAUKUNINGHIJAUUNGUKUNINGHIJAUKUNINGMERAHKUNINGBIRUBIRUBIRUKUNINGHIJAUBIRUHIJAUBIRUKUNINGMERAHUNGUMERAHUNGUKUNINGUNGUMERAHHIJAUHIJAUMERAHBIRUKUNINGMERAHBIRUUNGUKUNINGBIRUKUNINGMERAHBIRUMERAHBIRUHIJAUUNGUMERAHHIJAUUNGUUNGUBIRUKUNINGKUNINGKUNINGKUNINGKUNINGUNGUHIJAUMERAHMERAHMERAHKUNINGBIRUBIRUBIRUMERAHHIJAUKUNINGUNGUUNGUUNGUUNGUBIRUHIJAUMERAHMERAHMERAHKUNINGUNGUMERAHUNGUHIJAUHIJAUUNGUHIJAUKUNINGHIJAUMERAHKUNINGUNGUUNGUHIJAUHIJAUMERAHBIRUBIRUKUNINGUNGUKUNINGBIRUBIRUBIRUBIRUUNGUHIJAUKUNINGKUNINGHIJAUMERAHUNGUHIJAUKUNINGBIRUBIRUMERAHBIRUBIRUBIRUMERAHMERAHMERAHMERAHBIRUHIJAUKUNINGUNGUUNGUUNGUMERAHBIRUHIJAUHIJAUBIRUUNGUKUNINGKUNINGHIJAUKUNINGMERAHMERAHHIJAUUNGUMERAHUNGUUNGUHIJAUKUNINGBIRUUNGUUNGUBIRUHIJAUKUNINGMERAHKUNINGBIRUBIRUUNGUBIRUHIJAUMERAHMERAHMERAHHIJAUMERAHMERAHHIJAUBIRUBIRUUNGUUNGUBIRUHIJAUHIJAUMERAHUNGUUNGUUNGUKUNINGHIJAUUNGUUNGUKUNINGBIRUUNGUMERAHKUNINGUNGUMERAHKUNINGKUNINGBIRUHIJAUUNGUUNGUKUNINGKUNINGBIRUUNGUKUNINGUNGUKUNINGMERAHMERAHHIJAUMERAHKUNINGHIJAUKUNINGBIRUUNGUBIRUHIJAUHIJAUUNGUMERAHMERAHBIRUUNGUMERAHHIJAUMERAHKUNINGUNGUUNGUKUNINGHIJAUUNGUBIRUMERAHBIRUKUNINGKUNINGBIRUUNGUBIRUUNGUHIJAUBIRUUNGUBIRUBIRUUNGUBIRUUNGUKUNINGHIJAUUNGUMERAHBIRUUNGUUNGUUNGUKUNINGUNGUHIJAUUNGUUNGUHIJAUJUMLAHHIJAUJUMLAHMERAHJUMLAHKUNINGJUMLAHBIRUJUMLAHUNGUJUMLAH SELURUHNYA</p> <p>SOAL12NOTANGGALKODEBARANGKUANTITIHARGATOTAL15/7/12B79KODEBARANGHARGA25/21/12C48ACPU50000035/7/12B84BHARDDISK30000045/9/12C12CMEMORY25000055/29/12A4065/16/12C7675/22/12C3985/2/12A5995/28/12A22105/19/12C58115/28/12B80125/7/12C36135/30/12C91145/10/12B62155/6/12C88165/1/12A64175/2/12C23185/7/12B29195/11/12B54205/24/12B100215/3/12A95225/16/12C50235/7/12C98245/25/12A16255/6/12C53265/16/12C80TOTAL</p> <p>SOAL13NOTANGGALKODEBARANGKUANTITIHARGATOTAL15/19/12Z45KODEXYZ25/28/12X23BARANGKOMPUTERPRINTERMONITOR35/2/12Z114HARGA300000075000065000045/24/12X13755/2/12X9365/24/12X11475/1/12Y8585/15/12Z3695/30/12Y92105/12/12Y97115/6/12Y141125/27/12Y108135/11/12Y112145/8/12X124155/20/12Y77165/4/12X12175/13/12Z21185/2/12Y49195/19/12X38205/13/12Y134215/10/12Y134225/1/12Z125235/3/12Y142245/20/12Z140255/8/12Y26265/22/12Z90TOTAL</p> <p>SOAL14</p> <p>Sheet15</p>