{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Basic Excel, Basic VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Basic Excel, Basic VBA","index":0,"n_rows":837,"n_cols":254,"rows_kept":837,"cut":false,"hidden":false,"merged":[[8,5,8,10]]}
[null,null,null,null,null,null,null,null,null,null,null,"TABELA WYNIKÓW","TU WPISZ WYNIKI","OCENA",null,null,null,null,"PUNKTY",null,null,null,0,"niedostateczna"]
[1,"W kolumnie C podane są ceny z VAT wynoszącym 22%. Podaj cenę bez VAT, zaokrągloną do zł, produktu nr. 1",null,null,null,null,null,null,null,null,null,2,null,{"$f":"IT2","v":"-"},"-",{"$f":"IF(N2=\"dobrze\",R2,0)","v":0}," / ",2,{"$f":"CONCATENATE(P2,Q2,R2)","v":"0 / 2"},{"$f":"IF(M2=DG833,\"dobrze\",IF(M2=0,\"-\",\"źle\"))","v":"-"},"Excel",null,1,"niedostateczna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T2","v":"-"}]
[2,"Ile produktów typu sample sprzedano, wielkość sprzedaży jest w kolumnie units, użyj autofiltra",null,null,null,null,null,null,null,null,null,1,null,{"$f":"IT3","v":"-"},"dobrze",0," / ",1,"0 / 1",{"$f":"IF(M3=DG834,\"dobrze\",IF(M3=0,\"-\",\"źle\"))","v":"-"},"Excel",null,2,"niedostateczna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":"-"}]
[3,"jaki udział w całości sprzedaży wg wartości ma produkt asd, wynik zaokrąglij do 1 miejsca po przecinku (np. 5,5,%)?",null,null,null,null,null,null,null,null,null,2,null,{"$f":"IT4","v":"-"},"źle",0," / ",2,"0 / 2",{"$f":"IF(M4=DG835,\"dobrze\",IF(M4=0,\"-\",\"źle\"))","v":"-"},"Excel",null,3,"niedostateczna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":"-"}]
[4,"Na którym produkcie występuje najwyższa marża procentowa, podaj numer produktu, użyj polecenia sortuj (cofnij po wprowadzeniu wyniku)",null,null,null,null,null,null,null,null,null,3,null,{"$f":"IT5","v":"-"},null,0," / ",3,"0 / 3",{"$f":"IF(M5=DG836,\"dobrze\",IF(M5=0,\"-\",\"źle\"))","v":"-"},"Excel",null,4,"niedostateczna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T5","v":"-"}]
[5,"Znajdź odpowiednią funkcją koszty dla 10 produktów po prawej stronie, sumę kosztów jednostkowych wprowadź do tabeli wyników",null,null,null,null,null,null,null,null,null,1,null,{"$f":"T6","v":"-"},null,0," / ",1,"0 / 1",{"$f":"IF(M6=DG837,\"dobrze\",IF(M6=0,\"-\",\"źle\"))","v":"-"},"Excel",null,5,"mierna -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[6,"Zmień tekst który pokazuje się przy uruchomieniu tego pliku",null,null,null,null,null,null,null,null,null,3,null,"-",null,0," / ",3,"0 / 3",null,"VBA",null,6,"mierna"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L7)","v":12},null,null,null,{"$f":"SUM(P2:P7)","v":0}," / ",{"$f":"SUM(R2:R7)","v":12},"0 / 12",null,null,null,7,"dostateczna"]
[null,null,null,null,null,"miejsce na Twoje obliczenia - nadaj tytuły wykorzystanym kolumnom zgodnie z dokonywanymi obliczeniami",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"dobra"]
["No.","NAME","PRICE","COST","UNITS",null,null,null,null,null,null,null,null,null,null,null,null,null,"NAME",null,"COST",null,9,"bardzo dobra"]
[1,"product aśd sample",299,91.656000000000006,8373,null,null,null,null,null,null,null,null,null,null,null,null,null,"product asl",null,null,null,10,"bardzo dobra"]
[2,"product asj",299,78.816999999999993,9577,null,null,null,null,null,null,null,null,null,null,null,null,null,"product asr",null,null,null,11,"bardzo dobra"]
[3,"product acd",999,257.892,17520,null,null,null,null,null,null,null,null,null,null,null,null,null,"product df ",null,null,null,12,"celująca"]
[4,"product asb",599,151.46,19345,null,null,null,null,null,null,null,null,null,null,null,null,null,"product tty "]
[5,"product asb sample",1299,329.94200000000001,2211,null,null,null,null,null,null,null,null,null,null,null,null,null,"product ern "]
[6,"product ash",1699,364.89800000000002,1391,null,null,null,null,null,null,null,null,null,null,null,null,null,"product qqw "]
[7,"product ask sample",299,94.522000000000006,9830,null,null,null,null,null,null,null,null,null,null,null,null,null,"product asj"]
[8,"product ast",249,88.218000000000004,5628,null,null,null,null,null,null,null,null,null,null,null,null,null,"product df "]
[9,"product asf ",259,107.10899999999999,3463,null,null,null,null,null,null,null,null,null,null,null,null,null,"product cvb "]
[10,"product asr",399,106.504,4329,null,null,null,null,null,null,null,null,null,null,null,null,null,"product mnb "]
[11,"product b sample",199,61.04,13853]
[12,"product ask sample",799,333.27499999999998,19481]
[13,"product asl",349,115.57,3463]
[14,"product asb",1999,562.69899999999996,1732]
[15,"product we sample",399,180.63900000000001,21645]
[16,"product rt ",799,277.16899999999998,7309]
[17,"product aśd  ",599,261.99200000000002,3030]
[18,"product ty sample",699,291.16699999999997,2597]
[19,"product fg ",699,261.99200000000002,1397]
[20,"product hj sample",699,219.691,2097]
[21,"product fg sample",99,55.962000000000003,34632]
[22,"product vb ",499,140.774,6010]
[23,"product df ",129,45.713999999999999,4762]
[24,"product cvb ",599,234.017,1020]
[25,"product mnb ",699,266.36799999999999,2496]
[26,"product ass",1999,180.756,4329]
[27,"product asd ",1499,326.7,3651]
[28,"product ads",699,245.364,3896]
[29,"product asm",399,134.82,6926]
[30,"product hxw sample",449,147.01599999999999,12420]
[31,"product xci ",799,190.245,10711]
[32,"product poj ",399,134.626,7792]
[33,"product pol sample",999,293.904,3030]
[34,"product ern ",399,219.51300000000001,3547]
[35,"product jfy sample",399,186.489,3463]
[36,"product qqw ",999,337.98700000000002,1731]
[37,"product ggh ",999,329.37799999999999,1298]
[38,"product tty ",119,50.582999999999998,5194]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133632]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500.787]