{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Zagadnienia","For_If","Kolokwium","Arkusz1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Zagadnienia","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"WYKŁAD 8"]
[]
[null,"1.Funkcje tablicowe VBA (c.d.)"]
[null,"2.Pętla For w połączeniu z instrukcją If"]
[null,"3.Przykładowe zadania na 2 kolokwium"]

{"sheet":"For_If","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,1.7]
[null,2]
[null,-3.2]
[null,4]
[null,-1]
[null,2.12]
[null,0]
[null,6.3]
[null,3]
[null,-4.5]

{"sheet":"Kolokwium","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Przykładowe zadania na 2 kolokwium"]
[]
[null,"1.","Napisz makro, które przesuwa wartości w komórkach zgodnie z kierunkiem strzałek pokazanym poniżej."]
[null,"2.","Napisz makro, które koloruje tło komórek na czerwono gdy w komórkach znajdują się literki od A do E,"]
[null,null,"na zielono w przypadku znaków od F do K, na niebiesko w przypadku znaków od L do Q"]
[null,null,"i na zółto dla znaków od R do Z."]
[null,"3.","Napisz makro, które tworzy czerwono-białą szachownicę."]
[null,"4.","Napisz f. tablicową która odwraca wartości w zakresie do góry nogami."]
[null,"5.","Wypisz litery w trójkątnym zakresie komórek wg schematu poniżej."]
[]
[]
[]
[6,7]
[5,8]
[4,9]
[3,10]
[2,"j",null,null,"F","J","K","H","N",null,{"$f":"Odwróć(E17:E30)","v":"G"}]
[1,"i",null,null,"D","N","Z","O","X",null,"P"]
["a","h",null,null,"R","L","S","B","T",null,"W"]
["b","g",null,null,"S","M","E","F","I",null,"I"]
["c","f",null,null,"U","B","N","T","U",null,"W"]
["d","e",null,null,"I","Z","U","R","X",null,"N"]
[null,null,null,null,"W","K","D","Y","U",null,"S"]
[null,null,null,null,"S","K","A","E","E",null,"W"]
[null,null,null,null,"N","K","C","H","Q",null,"I"]
[null,null,null,null,"W","M","E","X","J",null,"U"]
[null,null,null,null,"I","U","F","L","G",null,"S"]
[null,null,null,null,"W","P","J","K","W",null,"R"]
[null,null,null,null,"P","Y","N","I","W",null,"D"]
[null,null,null,null,"G","G","E","J","A",null,"F"]
[]
[]
[null,null,null,null,"A"]
[null,null,null,null,"C","B"]
[null,null,null,null,"F","E","D"]
[null,null,null,null,"J","I","H","G"]
[null,null,null,null,"O","N","M","L","K"]
[null,null,null,null,"U","T","S","R","Q","P"]

{"sheet":"Arkusz1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}