{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["基本","問題","成績"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,2,6,3],[7,2,7,3],[8,2,8,3],[10,2,10,4]]}
[]
[]
[]
[]
[]
[]
[null,"クラス",null,null,null,null,"成績を印刷して提出する"]
[null,"出席番号",null,null,null,null,"場合のみ入力してください"]
[null,"名前"]
[]
[null,"問題名",{"$f":"問題!B1","v":"問題名"}]
[null,"問題数",{"$f":"COUNTA(問題!B3:B14)","v":12},"絞り込み","する",null,"絞り込みを「する」にすれば"]
[null,null,null,null,null,null,"連続３回正解した問題は"]
[null,"最新の成績",null,null,null,null,"表示されません"]
[null,"日付","回答数","正解率","正解率２"]
[]
[]
[null,"正解率２の順番に並べかえ",null,null,null,null,"正解率２は連続３回正解して絞り込み対象"]
[null,"日付","回答数","正解率","正解率２",null,"になった問題は正解したものとして"]
[1,null,null,null,null,null,"計算します"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[]
[]
[null,null,null,null,null,null,null,"irumi_i@irumi.sakura.ne.jp"]

{"sheet":"問題","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["問題名","問題名","3級ハード"]
["問題番号","問題番号","問題"]
[1,"コンピュータの五大装置のうち、演算装置と制御装置を総称したもの","ＣＰＵ"]
[2,"読み出し専用の記憶素子で、電源を切っても記憶内容が消えない。書き換えられては困るものを記憶する場合に使う。","ＲＯＭ"]
[3,"トランジスタやダイオード、抵抗、コンデンサなどの半導体による電子回路を数ミリ角のシリコン基板上に高度に集積化したもの。集積度の違いにより、LSIやVSLIなどがある","集積回路"]
[4,"一般にメモリという。メモリにはデータの読み出し専用のROM(ロム）と読み出しと書き込みができるRAM(ラム）がある。","主記憶装置"]
[5,"コンピュータの5大装置のうちで、記憶したデータをもとに命令に従って四則演算や比較判断を行う装置","演算装置"]
[6,"コンピュータの５大装置のうち、入力・記憶・演算・出力の各装置が効率よく動作するようにコントロールする装置","制御装置"]
[7,"主記憶装置を補うための記憶装置。コンピュータは電源を切るとその内部の内容は消えてしまうが、次回の続きの作業を行うためには、その内容を記憶しておくことが必要になる。そのための装置","補助記憶装置"]
[8,"コンピュータの五大装置のうちで、入力された命令やデータなどを記憶するための装置。主記憶装置と補助記憶装置からなる。","記憶装置"]
[9,"読み出しと書き込みができる記憶素子だが、電源を切ると記憶内容は消えてしまう。コンピュータのメインメモリや拡張メモリに使う。","ＲＡＭ"]
[10,"コンピュータの五大装置のうち、コンピュータが処理した結果を表示したり印字したりする装置","出力装置"]
[11,"コンピュータの五大装置のうち、コンピュータに命令やデータを読み込ませるための装置","入力装置"]
[12,"多数の細いノズルからインクを噴射して印字するプリンタ","インクジェットプリンタ"]

{"sheet":"成績","index":2,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,{"$f":"COUNTIF(E3:E100,\"正解\")","v":0}]
[]
[]
[]
[null,"試験日","2016-06-21T08:42:35","2016-06-26T16:23:42","2016-06-26T16:27:59"]
[null,"正解数",{"$f":"COUNTIF(C8:C105,\"正解\")","v":0},{"$f":"COUNTIF(D8:D105,\"正解\")","v":0},{"$f":"COUNTIF(E8:E105,\"正解\")","v":0}]
[null,{"$f":"IF(問題!B3<>\"\",問題!A3,\"\")","v":1}]
[null,{"$f":"IF(問題!B4<>\"\",問題!A4,\"\")","v":2}]
[null,{"$f":"IF(問題!B5<>\"\",問題!A5,\"\")","v":3}]
[null,{"$f":"IF(問題!B6<>\"\",問題!A6,\"\")","v":4}]
[null,{"$f":"IF(問題!B7<>\"\",問題!A7,\"\")","v":5}]
[null,{"$f":"IF(問題!B8<>\"\",問題!A8,\"\")","v":6}]
[null,{"$f":"IF(問題!B9<>\"\",問題!A9,\"\")","v":7}]
[null,{"$f":"IF(問題!B10<>\"\",問題!A10,\"\")","v":8}]
[null,{"$f":"IF(問題!B11<>\"\",問題!A11,\"\")","v":9}]
[null,{"$f":"IF(問題!B12<>\"\",問題!A12,\"\")","v":10}]
[null,{"$f":"IF(問題!B13<>\"\",問題!A13,\"\")","v":11}]
[null,{"$f":"IF(問題!B14<>\"\",問題!A14,\"\")","v":12}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(問題!#REF!<>\"\",問題!#REF!,\"\")","v":{"$error":"#REF!"}}]