{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Random"],"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":"Лист1","index":0,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[1,7,12,12]]}
[]
["B","P","V",null,null,null,null,"13.  Столбцы A, B и C листа Excel (Лист1) заполняются буквами латинского алфавита. Разработайте алгоритм и коды соответствующих функций/процедур для расчета частоты встречаемости буквы из ячейки С3 в каждой заполненной строке и выделите желтым цветом ячейку, в которой встречается буква из ячейки С3. Вычислите количество частоты буквы из C3 и вставте сумму  в ячейку E5. В ячейку E6 введите имя столбца, в котором буква из C3 встречается чаще. Столбцы заполняются, начиная со второй строки листа."]
["H","R","X"]
["O","G","O"]
["W","I","T",null,17]
["K","L","R",null,"B"]
["X","I","V"]
["O","X","C"]
["B","T","X"]
["J","X","J"]
["P","T","B"]
["I","T","F"]
["L","X","M"]
["C","T","L"]
["B","Q","L"]
["D","R","N"]
["F","G","X"]
["R","T","Q"]
["L","K","A"]
["B","N","M"]
["S","B","E"]
["C","N","V"]
["Y","Z","G"]
["I","N","E"]
["B","F","F"]
["P","K","K"]
["Y","S","T"]
["U","C","X"]
["W","Z","S"]
["U","K","Z"]
["F","Y","T"]
["Y","B","D"]
["H","O","N"]
["Z","M","T"]
["A","E","J"]
["B","A","O"]
["C","I","F"]
["M","W","N"]
["S","D","T"]
["A","K","M"]
["Z","E","S"]
["Y","M","A"]
["Y","V","F"]
["K","V","R"]
["I","Z","A"]
["Z","A","O"]
["B","P","R"]
["F","K","Q"]
["C","I","K"]
["E","G","B"]
["H","X","K"]
["K","V","T"]
["V","T","K"]
["O","E","G"]
["V","Q","R"]
["J","Q","Q"]
["K","E","K"]
["C","E","Q"]
["A","P","Z"]
["P","V","E"]
["V","P","U"]
["O","P","C"]
["Z","T","O"]
["K","J","L"]
["Q","X","S"]
["Q","B","C"]
["U","V","H"]
["Y","H","Y"]
["C","U","B"]
["B","Y","E"]
["P","Z","C"]
["A","J","J"]
["V","V","S"]
["S","H","N"]
["M","W","L"]
["O","Q","R"]
["P","V","D"]
["F","O","E"]
["C","B","N"]
["J","Y","Z"]
["R","B","P"]
["D","G","M"]
["C","Z","R"]
["N","X","Z"]
["B","L","F"]
["E","S","H"]
["T","V","P"]
["I","L","L"]
["V","T","A"]
["Y","U","Y"]
["W","C","Z"]
["L","K","I"]
["I","N","P"]
["O","O","B"]
["K","U","B"]
["Y","S","M"]
["J","V","R"]
["M","L","E"]
["H","N","H"]
["K","C","D"]
["A","Q","M"]
["S","G","U"]
["L","X","V"]
["Z","M","Z"]
["T","B","J"]
["O","N","V"]
["M","D","J"]
["E","Q","J"]
["T","C","I"]
["Y","K","H"]
["V","B","P"]
["K","V","V"]
["H","Z","U"]
["Z","T","C"]
["K","D","I"]
["K","T","U"]
["T","A","Q"]
["P","M","A"]
["C","M","N"]
["P","H","Y"]
["N","T","O"]
["X","C","J"]
["U","X","C"]
["K","C","V"]
["K","J","P"]
["J","U","M"]
["U","I","V"]
["Y","Y","A"]
["Q","Y","I"]
["W","H","K"]
["A","G","I"]
["M","V","S"]
["K","R","O"]
["O","U","Z"]
["V","S","K"]
["D","D","A"]
["L","D","P"]
["D","Z","J"]
["S","I","Q"]
["T","V","Y"]
["K","A","C"]
["K","V","A"]
["D","U","Y"]
["V","R","O"]
["I","U","Y"]
["V","C","O"]
["G","M","I"]
["G","P","H"]
["G","M","Z"]
["F","F","Y"]
["V","V","R"]
["P","P","A"]
["K","Z","L"]
["J","V","J"]
["C","P","D"]
["G","C","S"]
["S","P","Z"]
["P","L","G"]
["N","K","D"]
["O","N","W"]
["F","F","Y"]
["Y","B","Z"]
["C","O","D"]
["M","B","X"]
["A","W","E"]
["S","T","V"]
["E","O","H"]
["H","I","Z"]
["E","P","M"]
["X","A","Q"]
["R","J","R"]
["I","O","X"]
["K","T","Z"]
["A","L","F"]
["G","Z","Q"]
["U","P","P"]
["B","R","T"]
["S","U","F"]
["K","J","J"]
["T","W","T"]
["R","P","H"]
["Z","E","T"]
["S","N","S"]
["T","R","O"]
["S","K","K"]
["R","R","V"]
["L","E","T"]
["O","L","A"]
["R","J","N"]
["A","V","H"]
["G","G","D"]
["C","Z","Q"]
["D","B","J"]
["A","Y","Q"]
["P","T","G"]
["M","A","G"]
["P","N","S"]
["N","W","F"]
["C","U","Q"]
["P","H","P"]
["L","K","E"]

{"sheet":"Random","index":1,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"CHAR(RANDBETWEEN(65,90))","v":"A"},"M","S"]
["N","P","Y"]
["I","Q","R"]
["X","O","O"]
["W","V","W"]
["R","J","W"]
["E","F","H"]
["P","L","H"]
["X","J","B"]
["F","Y","T"]
["O","X","D"]
["G","H","D"]
["E","M","Q"]
["X","A","N"]
["J","W","J"]
["W","B","L"]
["R","C","A"]
["Y","C","F"]
["Q","K","J"]
["J","O","L"]
["N","N","F"]
[{"$f":"CHAR(RANDBETWEEN(65,90))","v":"S"},"H","T"]
["Y","R","T"]
["S","V","S"]
["W","L","X"]
["Y","R","D"]
["A","I","T"]
["F","H","M"]
["S","F","Z"]
["Y","X","V"]
["Q","A","M"]
["F","U","O"]
["T","S","N"]
["D","N","J"]
["F","G","V"]
["Q","X","K"]
["H","C","D"]
["L","W","V"]
["L","O","M"]
["W","O","T"]
["Y","X","Q"]
["Y","S","M"]
["R","H","E"]
["L","L","F"]
["S","X","I"]
["A","M","S"]
["B","K","E"]
["W","A","T"]
["E","K","I"]
["D","Y","T"]
["P","Q","F"]
["U","K","J"]
["K","I","O"]
["Z","Q","G"]
["X","I","H"]
["C","V","C"]
["U","C","W"]
["F","R","A"]
["P","P","S"]
["O","J","I"]
["M","F","F"]
["R","D","W"]
["B","C","M"]
["J","K","O"]
["R","W","C"]
["R","W","Y"]
["Y","O","S"]
["S","Q","I"]
["T","X","R"]
["X","O","J"]
["E","F","T"]
["Y","P","I"]
["Q","W","T"]
["U","U","G"]
["O","G","N"]
["M","C","S"]
["D","B","W"]
["K","O","Q"]
["M","J","K"]
["O","T","U"]
["L","U","I"]
["F","B","R"]
["T","H","M"]
["G","W","X"]
["H","M","P"]
[{"$f":"CHAR(RANDBETWEEN(65,90))","v":"O"},"R","O"]
["H","O","I"]
["F","S","T"]
["N","D","G"]
["M","M","E"]
["C","M","H"]
["K","B","B"]
["R","X","P"]
["R","J","E"]
["G","P","H"]
["J","Y","O"]
["E","C","J"]
["Y","F","B"]
["Y","F","S"]
["D","L","C"]
["E","N","V"]
["E","M","U"]
["V","Y","M"]
["V","E","P"]
["N","U","O"]
["A","H","D"]
["A","P","G"]
["F","T","Q"]
["A","P","U"]
["Q","F","T"]
["P","S","R"]
["L","G","U"]
["X","G","Z"]
["C","J","M"]
["I","S","L"]
["T","R","C"]
["J","Q","A"]
["Y","E","U"]
["G","E","B"]
["B","B","D"]
["I","T","N"]
["F","G","I"]
["R","F","T"]
["P","I","J"]
["K","B","S"]
["C","J","X"]
["X","I","Y"]
["F","O","R"]
["U","T","C"]
["V","T","U"]
["X","M","P"]
["W","Q","F"]
["J","Z","X"]
["U","S","D"]
["G","A","D"]
["W","V","Z"]
["O","R","M"]
["G","N","A"]
["K","H","N"]
["M","L","B"]
["A","J","Q"]
["R","E","W"]
["W","F","C"]
["N","Z","E"]
["Y","T","V"]
["O","Y","L"]
["R","P","G"]
["P","Y","G"]
["P","D","B"]
[{"$f":"CHAR(RANDBETWEEN(65,90))","v":"I"},"M","O"]
["Q","Y","T"]
["K","J","F"]
["O","H","R"]
["G","X","G"]
["Q","P","M"]
["T","L","J"]
["D","R","G"]
["C","K","Z"]
["A","U","M"]
["C","M","J"]
["A","U","E"]
["L","H","D"]
["L","Z","E"]
["W","N","E"]
["Y","O","V"]
["V","S","Q"]
["A","U","J"]
["F","Q","D"]
["U","W","L"]
["H","F","A"]
["X","W","X"]
["E","C","Z"]
["N","B","N"]
["Q","C","U"]
["O","B","G"]
["I","O","N"]
["S","F","I"]
["E","I","S"]
["J","X","V"]
["F","K","A"]
["S","J","S"]
["D","I","N"]
["V","B","Z"]
["P","D","X"]
["P","V","X"]
["L","H","K"]
["P","C","E"]
["C","I","D"]
["N","Q","B"]
["X","Q","R"]
["O","Q","E"]
["J","R","P"]
["L","W","G"]
["W","Y","J"]
["R","G","Z"]
["C","R","T"]
["Y","C","N"]
["D","F","W"]
["I","B","Y"]
["N","X","D"]