{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Arkusz5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Arkusz5","index":0,"n_rows":62,"n_cols":23,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Wykład 8: 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 zółto 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 wzór czerwono-żółtej szachownicy pokazanej obok."]
[null,"4.","Napisz f. tablicową która odwraca wartości w wybranym zakresie do góry nogami."]
[null,"5.","Za pomocą funkcji tablicowej przepisz litery  z kolumny P do trójkątnego zakresie komórek wg podanego schematu."]
[]
[]
[]
[6,7]
[5,8]
[4,9]
[3,10]
[2,"j",null,null,"S","N","P","H","H",null,{"$f":"Odwróć(E17:E30)","v":"K"},null,null,null,null,"A"]
[1,"i",null,null,"U","A","T","V","S",null,"K",null,null,null,null,"B"]
["a","h",null,null,"B","K","W","U","J",null,"K",null,null,null,null,"C"]
["b","g",null,null,"Z","W","B","Y","J",null,"H",null,null,null,null,"D"]
["c","f",null,null,"N","T","B","P","M",null,"C",null,null,null,null,"E"]
["d","e",null,null,"H","Q","Q","G","H",null,"C",null,null,null,null,"F"]
[null,null,null,null,"V","V","P","Z","X",null,"F",null,null,null,null,"G"]
[null,null,null,null,"F","S","Z","G","N",null,"V",null,null,null,null,"H"]
[null,null,null,null,"C","Z","R","A","O",null,"H",null,null,null,null,"I"]
[null,null,null,null,"C","C","U","H","B",null,"N",null,null,null,null,"J","n"]
[null,null,null,null,"H","J","H","Y","Z",null,"Z",null,null,null,null,"K"]
[null,null,null,null,"K","H","E","E","Q",null,"B",null,null,null,null,"L"]
[null,null,null,null,"K","K","S","I","Q",null,"U",null,null,null,null,"M"]
[null,null,null,null,"K","E","P","C","L",null,"S",null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P"]
[null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,"Q"]
[null,null,null,null,"C","B",null,null,null,null,null,null,null,null,null,"R"]
[null,null,null,null,"F","E","D",null,null,null,null,null,null,null,null,"S"]
[null,null,null,null,"J","I","H","G",null,null,null,null,null,null,null,"T"]
[null,null,null,null,"O","N","M","L","K",null,null,null,null,null,null,"U"]
[null,null,null,null,"U","T","S","R","Q","P"]
[]
[]
[null,null,null,null,{"$f":"trójkąt1(P17:P37)","v":"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"]
[]
[]
[]
[]
[]
[null,"6.","Napisz makro, które przesuwa cyklicznie dane w komórkach wg schematu przedstawionego obok."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"J"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]