{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Начало теста","Ученики","Тест","Отчет","Ведомость"],"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":"Начало теста","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,1,5]]}
[]
[null,"Тест на тему \"Табличный процессор MS Excel\""]

{"sheet":"Ученики","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["№","Фамилия","Имя","Класс","ФИ+Класс"]
[1,"Петров","Ефим","9А","Петров Ефим 9А"]
[2,"Иванов","Николай","9А","Иванов Николай 9А"]
[3,"Сидорова","Ольга","9А","Сидорова Ольга 9А"]
[4,"Сидоров","Станислав","9Б","Сидоров Станислав 9Б"]
[5,"Петухов","Никита","9Б","Петухов Никита 9Б"]
[6,"Кузнецова","Софья","9Б","Кузнецова Софья 9Б"]
[7,"Богомолов","Степан","9В","Лебедев Степан 9В"]
[8,"Романова","Виктория","9В","Романова Виктория 9В"]
[9,"Воронина","Светлана","9В","Воронина Светлана 9В"]
[10,"Жуков","Вячеслав","9Г","Жуков Вячеслав 9Г"]
[11,"Павлов","Максим","9Г","Павлов Максим 9Г"]
[12,"Фомина","Диана","9Г","Фомина Диана 9Г"]
[13,"Лебедева","Виктория","9Г","Лебедева Виктория 9Г"]

{"sheet":"Тест","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,0,9,4],[17,0,17,4],[25,0,25,4],[34,0,34,4],[42,0,42,4]]}
[null,null,null,null,null,null,13]
[]
[]
["Дата","Время","Фамилия","Имя","Класс"]
[{"$f":"TODAY()","v":"2019-08-31"},{"$f":"NOW()","v":43708.617631597219},{"$f":"INDEX(Ученики!B2:B14,$G$1,$1:$1)","v":"Лебедева"},{"$f":"INDEX(Ученики!C2:C14,$G$1,$1:$1)","v":"Виктория"},{"$f":"INDEX(Ученики!D2:D14,$G$1,$1:$1)","v":"9Г"},null,null,null,null,null,null,null,null,null,null,null,null,43708.616514930553]
[null,null,null,null,null,null,"кол-во неотв","кол-во -","кол-во +",null,null,null,null,null,null,null,null,"2019-08-31"]
[null,null,null,null,null,null,{"$f":"COUNTIF(G10:G42,0)","v":5},{"$f":"COUNTIF($I$10:$I$43,\"Неверно\")","v":5},{"$f":"COUNTIF($I$10:$I$43,\"Верно\")","v":0}]
[]
["Вопрос №1"]
["К какой категории функций относится функция И?",null,null,null,null,null,0,2,{"$f":"IF(G10=H10,\"Верно\",\"Неверно\")","v":"Неверно"}]
[]
[]
[]
[]
[]
[]
["Вопрос №2"]
["Как называется адрес ячейки, полностью защищенный от изменения при копировании формулы?",null,null,null,null,null,0,3,{"$f":"IF(G18=H18,\"Верно\",\"Неверно\")","v":"Неверно"}]
[]
[]
[]
[]
[]
[]
["Вопрос №3"]
["Какие из представленных ниже функций входят в стостав мастера функций?"]
[null,null,null,null,null,null,{"$f":"IF(AND($G$28=FALSE,$G$30= FALSE,$G$30=FALSE,$G$31=FALSE),0,1)","v":0}]
[null,null,null,null,null,null,false,true,{"$f":"IF(AND(G28=H28,G29=H29,G30=H30,G31=H31),\"Верно\",\"Неверно\")","v":"Неверно"}]
[null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,false,true]
[null,null,null,null,null,null,false,false]
[]
[]
["Вопрос №4"]
["Необходимо определить при каких входных значениях может быть получен требуемый результат. Какое средство MS Excel позволяет это сделать?",null,null,null,null,null,0,2,{"$f":"IF(G35=H35,\"Верно\",\"Неверно\")","v":"Неверно"}]
[]
[]
[]
[]
[]
[]
["Вопрос №5",null,null,null,null,null,{"$f":"IF(A45=\"\",0,1)","v":0}]
["При копировании формулы из ячейки В3 в ячейку С3 в последнюю была занесена формула =А2+5. Что было написано в ячейке В3? Введите ответ в ячейку А45.",null,null,null,null,null,"$A2+5","$A$2+5",{"$f":"IF(OR(A45=G43,A45=H43),\"Верно\",\"Неверно\")","v":"Неверно"}]
[]
[""]

{"sheet":"Отчет","index":3,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Отчет о прохождении теста по теме \"Табличный процессор MS Excel\""]
[]
[]
["Дата","Время","Фамилия","Имя","Класс","Кол-во верных ответов","Кол-во неверных ответов","Кол-во вопросов без ответа","№1","№2","№3","№4","№5","Оценка"]
["2019-08-31",43708.616514930553,"Лебедева","Виктория","9Г",0,5,5,"Неверно","Неверно","Неверно","Неверно","Неверно",{"$f":"IF($F$5<=2,2,IF($F$5=3,3,IF($F$5=4,4,IF($F$5=5,5,0))))","v":2},{"$f":"IF($F$5<=2,2,IF($F$5=3,3,IF($F$5=4,4,IF($F$5=5,5,0))))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F$5<=2,2,IF($F$5=3,3,IF($F$5=4,4,IF($F$5=5,5,0))))","v":2}]

{"sheet":"Ведомость","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Дата","Время","Фамилия","Имя","Класс","Кол-во верных ответов","Кол-во неверных ответов","Оценка"]