{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["せいせき","かいとう","使い方","CA"],"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":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,1],[11,2,11,3],[9,0,10,1],[9,2,10,3],[7,0,8,6],[9,4,10,6],[11,4,11,6],[1,10,2,12],[1,0,1,9],[1,13,2,13],[2,0,2,6],[3,2,4,3],[3,13,4,13],[2,7,2,9],[3,8,4,8],[3,11,4,11]]}
[]
["とくてんくぶんべつとくてん　Scores by Scoring Section",null,null,null,null,null,null,null,null,null,"そうごうとくてん\nTotal Score",null,null,"ごうかく\nひょうか"]
["げんごちしき（もじ・ごい・ぶんぽう）・どっかい\nLanguage Knowledge (Vocabulary / Grammar)&Reading",null,null,null,null,null,null,"ちょうかい\nListening"]
[null,null,{"$f":"ROUNDDOWN(SUM(かいとう!Q5:Q37)/57*120, 0) - MOD(ROUNDDOWN(SUM(かいとう!Q5:Q37)/57*120, 0), 5)","v":0},null,null,null,null,null,{"$f":"ROUNDDOWN(SUM(かいとう!Q42:Q51)/28*60, 0) - MOD(ROUNDDOWN(SUM(かいとう!Q42:Q51)/28*60, 0), 5)","v":0},null,null,{"$f":"C4+I4","v":0},null,{"$f":"IF(L4/180<=0.4, \"～40%\", IF(L4/180>=0.8, \"80%～\", TEXT((ROUNDUP(L4/180*10-0.5,0)*10)/100,\"0%\")))","v":"～40%"}]
[null,null,null,null,"/120",null,null,null,null,"/60",null,null,"/180"]
[]
[]
["さんこうじょうほう\nReference Information",null,null,null,null,null,null,null,"※N4の合格点は90点です。"]
[null,null,null,null,null,null,null,null,"※区分ごとの基準点（N4：言語知識・読解38点、聴解19点）を下回ると、合格点を超えていても不合格になります。"]
["もじ・ごい\nVocabulary",null,"ぶんぽう\nGrammar",null,"どっかい\nReading",null,null,null,"※本模試の採点および合格基準はアスク出版独自のもので、実際の試験とは異なります。"]
[]
[{"$f":"IF(SUM(かいとう!Q5:Q17)/28>=0.67, \"A\", IF(SUM(かいとう!Q5:Q17)/28>=0.34, \"B\", \"C\"))","v":"C"},null,{"$f":"IF(SUM(かいとう!Q22:Q28)/21>=0.67, \"A\", IF(SUM(かいとう!Q22:Q28)/21>=0.34, \"B\", \"C\"))","v":"C"},null,{"$f":"IF(SUM(かいとう!Q31:Q37)/8>=0.67, \"A\", IF(SUM(かいとう!Q31:Q37)/8>=0.34, \"B\", \"C\"))","v":"C"}]

{"sheet":"かいとう","index":1,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,0,16,0],[2,0,4,0],[5,0,7,0],[8,0,10,0],[11,0,13,0],[19,0,21,0],[22,0,24,0],[25,0,27,0],[28,0,30,0],[31,0,33,0],[34,0,36,0],[39,0,41,0],[42,0,44,0],[45,0,47,0],[48,0,50,0]]}
["これ一冊N4もぎしけん"]
["げんごちしき（もじ・ごい）"]
["もんだい\n１","もんだい",1,2,3,4,5,6,7]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C5:O5, \"〇\")","v":0},"／7問"]
["もんだい\n２","もんだい",8,9,10,11,12]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C8:O8, \"〇\")","v":0},"／5問"]
["もんだい\n３","もんだい",13,14,15,16,17,18,19,20]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C11:O11, \"〇\")","v":0},"／8問"]
["もんだい\n４","もんだい",21,22,23,24]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C14:O14, \"〇\")","v":0},"／4問"]
["もんだい\n５","もんだい",25,26,27,28]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C17:O17, \"〇\")","v":0},"／4問"]
[]
["げんごちしき（ぶんぽう）・どっかい"]
["もんだい\n１","もんだい",1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C22:O22, \"〇\")","v":0},"／13問"]
["もんだい\n２","もんだい",14,15,16,17]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C25:O25, \"〇\")","v":0},"／4問"]
["もんだい\n３","もんだい",18,19,20,21]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C28:O28, \"〇\")","v":0},"／4問"]
["もんだい\n４","もんだい",22,23,24]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C31:O31, \"〇\")","v":0},"／3問"]
["もんだい\n５","もんだい",25,26,27]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C34:O34, \"〇\")","v":0},"／3問"]
["もんだい\n６","もんだい",28,29]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C37:O37, \"〇\")","v":0},"／2問"]
[]
["ちょうかい"]
["もんだい\n１","もんだい",1,2,3,4,5,6,7,8]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C42:O42, \"〇\")","v":0},"／8問"]
["もんだい\n２","もんだい",1,2,3,4,5,6,7]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C45:O45, \"〇\")","v":0},"／7問"]
["もんだい\n３","もんだい",1,2,3,4,5]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C48:O48, \"〇\")","v":0},"／5問"]
["もんだい\n４","もんだい",1,2,3,4,5,6,7,8]
[null,"かいとう"]
[null,"〇, ×",null,null,null,null,null,null,null,null,null,null,null,null,null,"正答数：",{"$f":"COUNTIF(C51:O51, \"〇\")","v":0},"／8問"]

{"sheet":"使い方","index":2,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["使い方"]
["1.　「かいとう」シートの「かいとう」の行 （色のついた行）に、自分の解答番号を入力する"]
["2.　解答番号の入力がすべて終わったら、一番上の「Check Answers」ボタンを押す"]
["3.　「Check Answers」ボタンを押したら、問題ごとの正誤判定がされるとともに、「せいせき」シートに点数が出る"]
["4.　「Clear Feedback」ボタンを押すと、正誤判定がすべてクリアされる"]
["5.　「Clear Answers」ボタンを押すと、入力した解答がすべてクリアされる"]
[]
["注意事項"]
["本模試の採点および合格基準はアスク出版独自のもので、実際の試験とは異なります。"]
[]
["本ファイルはマクロを使用しています。"]
["Webからダウンロードした直後は、セキュリティの関係でマクロが無効になっている場合があります。"]
["正しく動作しない場合は、以下の手順をお試しください。"]
["1.　一度Excelを閉じて、このファイルを右クリック"]
["2.　「プロパティ」を開く"]
["3.　「全般」タブの一番下にある「ブロックの解除（許可する）」にチェックを入れて、「適用」→「OK」"]
["4.　再度ファイルを開き、上部に表示される「コンテンツの有効化」をクリック"]
[]
["How to Use"]
["1. On the \"かいとう\" sheet, enter your answer numbers in the \"かいとう\" rows (the colored rows)."]
["2. Once you’ve finished entering all your answers, click the \"Check Answers\" button at the top."]
["3. After clicking the \"Check Answers\" button, each answer will be marked as correct or incorrect, and your total score will appear on the \"せいせき\" sheet."]
["4. To clear all the grading results, click the \"Clear Feedback\" button."]
["5. To clear all entered answers, click the \"Clear Answers\" button."]
[]
["Important Notice"]
["The scoring and passing criteria of this mock exam are set independently by ASK publishing and differ from those of the actual exam."]
[]
["This file contains macros."]
["If macros are disabled after downloading, please follow these steps:"]
["1. Close Excel, then right-click the file"]
["2. Select \"Properties\""]
["3. In the \"General\" tab, check the box labeled \"Unblock\" (near the bottom), then click \"Apply\" and \"OK\""]
["4. Reopen the file and click \"Enable Content\" if prompted"]

{"sheet":"CA","index":3,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
["言語知識（文字・語彙）"]
["問題１","問題番号",1,2,3,4,5,6,7]
[null,"解答番号",1,4,2,3,3,1,4]
[null,"正誤判定"]
["問題２","問題番号",8,9,10,11,12]
[null,"解答番号",2,1,1,3,2]
[null,"正誤判定"]
["問題３","問題番号",13,14,15,16,17,18,19,20]
[null,"解答番号",4,1,4,1,2,3,1,2]
[null,"正誤判定"]
["問題４","問題番号",21,22,23,24]
[null,"解答番号",3,1,4,4]
[null,"正誤判定"]
["問題５","問題番号",25,26,27,28]
[null,"解答番号",3,1,2,4]
[null,"正誤判定"]
[]
["言語知識（文法）・読解"]
["問題１","問題番号",1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"解答番号",3,2,1,1,2,4,4,3,1,2,3,3,2]
[null,"正誤判定"]
["問題２","問題番号",14,15,16,17]
[null,"解答番号",4,3,3,2]
[null,"正誤判定"]
["問題３","問題番号",18,19,20,21]
[null,"解答番号",2,1,4,3]
[null,"正誤判定"]
["問題４","問題番号",22,23,24]
[null,"解答番号",1,4,4]
[null,"正誤判定"]
["問題５","問題番号",25,26,27]
[null,"解答番号",2,4,1]
[null,"正誤判定"]
["問題６","問題番号",28,29]
[null,"解答番号",4,2]
[null,"正誤判定"]
[]
["聴解"]
["問題１","問題番号",1,2,3,4,5,6,7,8]
[null,"解答番号",3,3,3,2,4,4,2,1]
[null,"正誤判定"]
["問題２","問題番号",1,2,3,4,5,6,7]
[null,"解答番号",1,1,3,1,2,3,3]
[null,"正誤判定"]
["問題３","問題番号",1,2,3,4,5]
[null,"解答番号",3,1,2,3,2]
[null,"正誤判定"]
["問題４","問題番号",1,2,3,4,5,6,7,8]
[null,"解答番号",2,1,3,1,2,1,2,3]
[null,"正誤判定"]