{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Info1","Info2","Info3 ","Info4","Info5","SearchResultSheet","Result11","Result12","Result21","Result22","Result31","Result32","Result41","Result42","Result51","Result52","Result61","Result62","SearchResult","SetData","Manual"],"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":"Info1","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["No.","質問項目","答え1","答え2","答え3","理解･記憶の補助","ヒント","解説"]
[1,"パネルヒーター","クレオ工業㈱\n3Hタイマー付きテーブルヒーター\nNH2471　90W","3948円　楽天",null,null,"2017.1購入　\n","10=&H008000=RGB(0,128,0)=緑"]
[2,"オーブントースター","TWINBIRD   TS-D037","4200円",null,null,"\n","13=&H800080=RGB(128,0,128)=あずき・紫"]
[3,"超音波温熱吸入器","A&D 超音波温熱吸入器 ホットシャワー5 ピンク UN-135A-JC1","10117円",null,null,"健康","3=&H0000FF=RGB(255,0,0)=赤"]
[4,"ヨーグルトメーカー","ヨーグルティアホワイト \nYM-1200-NW TANICA  ","9180円",null,null,null,"5=&HFF0000=RGB(0,0,255)=青"]
[5,"魚の焼き方","塩を振ってすぐ焼くと生臭さが残る\n","浸透圧で中から臭みの液が出る\n出し切ってから焼くとよい",null,null,"日本人の3割しか知らないこと\n料理","7=&HFF00FF=RGB(255,0,255)=ピンク・マゼンタ"]
[6,"魚の焼き方2","白身魚=10分くらい置く\n青身魚=1時間近く置く"]
[7,"英国の人口はどのくらいあるか知っていますか。\n","Do you know what is the population of England?\n"]
[8,"英国の人口はどのくらいあると思いますか。","What do you think is the population of England?"]
[9,"気体の状態方程式","p=-ρRT","p=気圧(hPa)  \nρ=密度(kg/m3)\n","Rd=気体定数=287(J/kg/K)\n(乾燥空気の場合)","ρ=n/Vとすると、p=-(n/V)RT  pV=-nRT"]
[10,"地球大気","N2=78.1%\nO2=20.9%    Ar=0.93%","CO2=0.03%→0.04%","高度約80kmまでほぼ一定"]

{"sheet":"Info2","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["No.","質問項目","答え1","答え2","答え3","理解･記憶の補助","ヒント","解説"]
[1,"プリンタ","Ｃａｎｏｎ　LBP3000","Canon　iP2700\n室内高温のためかフィード部分が固着気味になる→紙が詰まりながらフィードされる・途中で詰まってしまう","[対策]　解除しながら数枚印刷を続ける",null,2018.2]
[2,"クローンディスク作成","Cドライブのクローンを作成し、ドライブを換装する","HDDをSSDへ換装する場合等に実施",null,"クローン作成にはHDD→SSDで2時間くらいかかる。SSD→SSDで20分くらい。","2018.3"]
[3,"Cドライブの拡張(パーティションマージ)","被拡張領域(未割当領域)がCドライブのすぐ右隣にあれば、コントロールパネルの管理ツールで拡張可能。Cドライブで右クリック、パーティションのマージを実行。","右隣にない場合、AOMEI Partition Assistantを使う。被拡張領域がパーティションである場合、パーティションの削除を行い未割当領域としておく。","EaseU Partition Master(epm.exe解凍)を使用する。ウィザードのディスククローンウィザード実行、ディスクを決めたら処理が予約される。✔をクリックして予約処理を実行する。","本課題は、PCのCドライブをクローンコピーした場合の換装後ドライブに生じる問題","2018.3"]
[4,"CADソフト","建築関係企業　\nフリーソフト　JWCAD\n                 AR_CAD2010",null,null,null,"2018.9"]
[5," BS・110°CSアンテナ","マスプロ　BC45RL \nBS 4K・8K放送(3224MHz) 対応  CS対応\n"]
[6,"ウィットネジとインチネジ","ウィットネジは、1/2を除き山数・ネジピッチがインチネジ(ユニファイネジ)とほぼ同じである\nネジ山角度は異なる(ウィット55度、インチ60度)\n","ボルト長が短い場合は、ウィットネジとインチネジを互換できる(1/2を除く)\n",null,"インチネジはユニファイネジ(UNC)とも呼ばれる\nインチネジよりウィットネジの方が安価である"]
[7,"ソーラーライト吊り下げタイプ","100円ショップ　セリア　\n防滴構造(設計センス良い)"]
[8,"スマホのSIMのはずし方","SIMカードの見えてる樹脂面にテープ(養生テープ等)の小片を接着させ、指の腹で押さえながらテープを手前に引く→5mmほど抜けてきたら後は手で引き抜く"]

{"sheet":"Info3 ","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","質問項目","答え1","答え2","答え3","理解･記憶の補助","ヒント","解説"]

{"sheet":"Info4","index":3,"n_rows":1499,"n_cols":9,"rows_kept":1499,"cut":false,"hidden":false,"merged":[]}
["No.","質問項目","答え1","答え2","答え3","理解･記憶の補助","ヒント","解説"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,500]

{"sheet":"Info5","index":4,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","質問項目","答え1","答え2","答え3","理解･記憶の補助","ヒント","解説"]

{"sheet":"SearchResultSheet","index":5,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","質問","答え1","答え2","答え3","答え4","答え5","キーワード"]

{"sheet":"Result11","index":6,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]
[1,4,1,0]
[2,5,0,1]
[3,3,1,0]
[4,4,1,0]
[5,5,0,1]
[6,6,1,0]
[7,7,0,1]
[8,8,0,1]
[9,9,1,0]
[10,5,1,0]
[11,3,0,1]
[12,2,1,0]
[13,4,0,1]
[14,9,1,0]
[15,8,1,0]
[16,11,1,0]
[17,3,0,1]
[18,4,1,0]
[19,5,0,1]
[20,4,1,0]
[21,1,0,1]
[22,10,0,1]
[23,4,0,1]
[24,8,1,0]
[25,10,0,1]
[26,1,0,1]
[27,3,1,0]
[28,6,0,1]
[29,6,0,1]

{"sheet":"Result12","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]
[1,5,1,3]
[2,4,4,2]
[3,3,2,2]
[4,6,1,2]
[5,1,0,2]
[6,10,0,2]
[7,7,0,1]
[8,8,2,1]
[9,11,1,0]
[10,9,2,0]
[11,2,1,0]

{"sheet":"Result21","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]
[1,8,1,0]
[2,5,1,0]
[3,7,0,1]
[4,3,1,0]
[5,9,1,0]
[6,7,1,0]
[7,3,1,0]

{"sheet":"Result22","index":9,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]
[1,7,0,1]
[2,5,1,0]
[3,8,1,0]
[4,3,1,0]
[5,9,1,0]

{"sheet":"Result31","index":10,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result32","index":11,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result41","index":12,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result42","index":13,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result51","index":14,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result52","index":15,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result61","index":16,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"Result62","index":17,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","CorrectA","WrongA"]

{"sheet":"SearchResult","index":18,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","Qrow","Keyword"]

{"sheet":"SetData","index":19,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Number of answers",3,null,"Info1"]
["Correct Ratio (%)",85,null,"Info2"]
[null,null,null,"Info3 "]
[null,null,null,"Info4"]
[null,null,null,"Info5"]
[null,null,null,"SearchResultSheet"]
[null,null,null,"Result11"]
[null,null,null,"Result12"]
[null,null,null,"Result21"]
[null,null,null,"Result22"]
[null,null,null,"Result31"]
[null,null,null,"Result32"]
[null,null,null,"Result41"]
[null,null,null,"Result42"]
[null,null,null,"Result51"]
[null,null,null,"Result52"]
[null,null,null,"Result61"]
[null,null,null,"Result62"]
[null,null,null,"SearchResult"]
[null,null,null,"SetData"]
[null,null,null,"Manual"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Manual","index":20,"n_rows":140,"n_cols":3,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["取扱説明",null,"2025.5.25"]
[]
["1.QAExcelVBATCS***.xlsm (本ソフト)"]
["　Excel Sheetに記載されたテキストから問題を出題、解答を返すVBAソフトである"]
["　出題は任意に選んだアクティブSheet(出題元Sheet)から出題される、出題元Sheetの1行に1問題とその解答を記入しておく、行の第2列が問題テキスト、第3～7列が解答テキストに当たる"]
["　左から5つまでのSheetが出題元Sheetである、7つ目以降のSheet「Resultn1」Sheet「Resultn2」は解答結果データ処理用である(n=1～6)"]
["　最後尾前Sheet「SearchResult」は検索結果収納用、Sheet 「SetData」はSheet名取得用・正答率設定用である"]
["2.起動方法"]
["(1) Excelセキュリティレベルの設定"]
["　セキュリティがVBA・マクロの実行を拒否しなくなるまでセキュリティレベルを下げる"]
["　Excel2013では、セキュリティーセンターのActiveXの設定において「先に確認メッセージを表示してから、最低限の制限を適用してすべてのコントロールを有効にする」にチェックを入れる"]
["(2) 他ソフトとの競合"]
["　Excelを起動するVisualBasic(VB)アプリケーションを本ソフトより先に起動すると、本ソフトが正常に立ち上らないことがある、両者を並行起動したい場合は、本ソフトを起動後、VBアプリケーションを起動すること"]
["(3) 「開発」タブを開き「マクロ」をクリックする(Windows10)"]
["(4) マクロ名「QandAExcelVBA」を選択し「実行」をクリック"]
["　実行した時、現在開かれているSheetから出題する旨メッセージが出る"]
["  対象Sheetが違った場合はマクロを中断し、Sheetを選び直してマクロを再起動する"]
["3.使い方"]
["3.1出題モード"]
["下記4つの出題モードを準備している"]
["① お任せ出題"]
["② 問題行を指定して出題する"]
["③ 誤答した問題を出題する"]
["④ 検索ヒットした問題を出題する"]
["3.2出題・解答"]
["3.2.1「お任せ出題」モード"]
["(1) 「出題」ボタンを押す　　　"]
["  「出題」ボタン右のすべてのチェックボタンにチェックが入っていないモードである"]
["　上段テキストボックスに問題が表示される(問題は出題元Sheet 第2列のテキスト内容)"]
["　問題はランダムに番号(行番号=問題番号)が選択されて出題される"]
["　正答率が設定解答数以上で設定%以上に達した問題は、出題から除外される(「お任せ出題」モードのみ)"]
["(2) 解答する(自分の頭の中)"]
["(3) 「答え表示」ボタンを押す    "]
["　メニュー中段・下段テキストボックスに答えが表示される(答えは出題元Sheet第3,4,5,6,7列のテキスト内容)　　"]
["(4) 自分の解答した内容が正しければ「正答だった」を押す(押さなくても可)"]
["  正答率計算式　「正答数/問題数×100=　　(%)」　に問題数と正答数が追加され再計算される"]
["　Sheet「Resultn1」に行が追加され、問題番号(行番号)  正答欄に1 誤答欄に0 が追記される(出題元Sheet左からn=1→2→・・・→6)"]
["(5) 自分の解答した内容が間違っていたら「誤答だった」を押す(押さなくても可)"]
["  正答率計算式　「正答数/問題数×100=　　(%)」　に問題数が追加され再計算される"]
["　Sheet「Resultn1」に行が追加され、問題番号(行番号)  正答欄に0 誤答欄に1が追記される"]
["(6) 「出題」ボタンを押す(次問出題)"]
["　「正答だった」/「誤答だった」ボタンを押さなかった場合、「正答・誤答未判定です判定しますか(はい/いいえ)」の選択表示が出る"]
["　「はい」をクリックすると前問の正誤判定に戻る"]
["　「いいえ」をクリックすると次問を自動出題する(前問の正誤判定はパスされる)"]
["(7) 上記(2)へ戻る"]
["3.2.2「問題行を指定して出題する」モード"]
["(1) 「□問題行を指定して出題する」　にチェックを入れる"]
["(2) 「問題指定後、自動的に次の問題を出題できます、自動出題モードにしますか(はい/いいえ)」が表示される"]
["　「はい」をクリックすると自動出題(問題番号自動インクリメント)モードに設定される"]
["　「いいえ」をクリックすると手動出題(問題番号手動入力)モードに設定される"]
["(3) 「出題」ボタンを押す"]
["　「問題行を指定してください」の入力ボックスが出る"]
["　希望の問題行を入力する"]
["　掲載問題数(行)を超える出題番号が指定されたら「問題数を超えています」とのメッセージが出る(行指定出題モード時)"]
["　既に出題が実行されている場合「正答・誤答未判定です判定しますか(はい/いいえ)」の選択表示が出る、他モードの出題であるので「いいえ」をクリックする"]
["　上記(2)で「はい」を選択した場合、上記(3)で入力した行番号の次の行番号の問題が自動出題される"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(4) 「出題」ボタンを押す(次問出題)"]
["　上記(2)で「いいえ」を選択した場合、「問題行入力ボックス」が表示される、希望の問題行を入力する"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(5) 上記(4)へ戻る"]
["3.2.3「誤答した問題を出題する」モード"]
["(1) 事前に「解答結果集約」ボタンをクリックし、解答結果の正誤の集約をしておく"]
["　Sheet「Resultn2」にSheet「Resultn1」データを集約(名寄せ)した結果が保存される"]
["　Sheet「Resultn2」には誤答数が大きい順に問題行番号・正答回数・誤答回数が記入される"]
["(2) 「□誤答した問題を出題する」にチェックを入れる"]
["(3) 「難度が上位の問題をパスすることができます、パスする問題数を指定しますか(はい/いいえ)」と表示される"]
["　「はい」をクリックした場合、パスする問題数を入力する"]
["　「いいえ」をクリックした場合何も表示されない"]
["(4) 「出題」ボタンを押す"]
["　上記(3)で「いいえ」をクリックした場合、最上位難度の問題(誤答数が最も多い問題)から出題される"]
["　上記(3)で「はい」をクリックした場合、指定した問題数分難度の高い問題がパスされ残りの高難度順に出題される"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(5) 「出題」ボタンを押す(次問出題)"]
["　前問の1つ次の難度の問題が出題される(上記(3)ではい/いいえをクリックした場合とも)"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(6) 上記(5)へ戻る"]
["3.2.4「検索ヒットした問題を出題する」モード"]
["　MENU画面で「検索ヒットした問題を出題する」モードを選択して出題するケースと、検索ヒットした問題を集約した出題元シートから出題するケースがある"]
["3.2.4.1モードを選択して出題"]
["(1) 事前に「検索」ボタンをクリックし、検索したい用語を検索しておく"]
["　「検索」ボタンの下に、検索したキーワード、右のテキストボックスに検索ヒットした問題番号(行番号)が一覧表示される"]
["　検索対象は、アクティブな対象Sheet内のすべての文言である"]
["　検索の実行と同時に、検索ヒットしたすべての問題行の内容がSheet「SearchResultSheet」に抽出集約される"]
["(2) 「□検索ヒットした問題を出題する」　にチェックを入れる"]
["(3) 「最初から指定数の検索ヒット問題をパスすることができます、パスする問題数を指定しますか(はい/いいえ)」と表示される"]
["　「はい」をクリックした場合、パスする問題数を入力する"]
["　「いいえ」をクリックした場合何も表示されない"]
["(4) 「出題」ボタンを押す"]
["　出題は、出題元(検索元)Sheetから検索ヒットした問題番号を参照し表示する"]
["　上記(3)で「いいえ」をクリックした場合、検索ヒットした最初の問題が出題される"]
["　上記(3)で「はい」をクリックした場合、パスする問題数よりのちの問題から出題される"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(5) 「出題」ボタンを押す(次問出題)"]
["　前問の1つ次の問題が出題される(上記(3)ではい/いいえをクリックした場合とも)"]
["　以下、3.2.1上記(2)～(5)と同じ"]
["(6) 上記(5)へ戻る"]
["3.2.4.2検索結果シートから出題"]
["　検索実行時、検索ヒットしたすべての問題行の内容を若い番号順にSheet「SearchResultSheet」にコピーしている"]
["　Sheet「SearchResultSheet」には、出題元の検索ヒット行の行高さ・セル書式(Forecolor・Fontsize等)もコピーする、セルの列幅はコピーしない"]
["　Sheet「SearchResultSheet」を開いた状態で本VBAを再起動すると、検索ヒットした問題を出題元として3.1に示す出題モードでの出題が可能である"]
["　ただし、「検索」ボタンで検索は可能であるが、検索結果のの抽出集約は行わない(出題元(Sheetである「SearchResultSheet」Sheet」に新たな検索結果が上書きされるため)"]
["　解答結果の正誤評価データも作成されるが、本モード以外で次の検索が実行されると消去される、「全消去」ボタンでも消去される"]
["4.その他ボタンの機能"]
["(1) 「答え消去」"]
["　中段・下段のテキストボックス(答え欄)の表示を消去する"]
["(2) 「全消去」"]
["　出題モード選択情報を含むメニュー上の出題情報をすべて消去する"]
["　Sheet「SearchResult」に保存している検索結果データも消去される"]
["　Sheet「SearchResultSheet」以外のSheetを出題元Sheetとした場合、対応するSheet「Resultn1」 Sheet「Resultn2」は消去されない、Sheet「設定値保存」データも消去されない(変更もなし)"]
["　Sheet「SearchResultSheet」を出題元とした場合は、特例としてSheet「Resultn1」・ Sheet「Resultn2」・Sheet「SetData」データは消去される(検索行為は一時的なものであるから)"]
["(3) 「設定変更」"]
["　正答率が設定解答数以上で設定%以上に達した問題は、出題から除外される(「お任せ出題」モード時のみ)"]
["　「設定変更」で、設定解答数と正答率(%)を変更できる(初期設定　解答数=3 正答率=85%)"]
["(4) 「非表示」"]
["　出題メニュー画面を非表示にする(Excel表内容の閲覧・変更操作を見やすくするため)"]
["(5) 「終了」"]
["　本VBA(マクロ)を終了する"]
["　終了時Excelファイルの自動保存はされない、データの変更等あれば手動にて上書き保存すること"]
["5.出題列変更"]
["問題と解答を逆転させると、問題の認識を深められることがある。出題列固定を改め、出題列を可変とする機能を追加した。"]
["(1) VBAプログラム(マクロ)起動時、出題対象シート選択後、問とする列番号の選択画面表示。"]
["　　問とする列番号のデフォルトは第2列であるが、第3～7列を出題行とすることが可能。"]
["　　デフォルト以外を出題行とした場合、問題と解答の対応関係が崩れる(解答の一つが問となる)。"]
["(2) デフォルト以外から選択した場合、MENU解答欄には出題行の右隣りの列から右回りにその内容を表示する。"]
["　　解答列が第7列を超える場合は第2列へ戻り、右列へインクリメントする。"]
["6.禁止事項"]
["(1) Sheetの入れ替え禁止 "]
["　出題元Sheetと結果評価Sheetを並び順で区別しているため"]
["(2) Sheet名の変更禁止"]
["　左から5つまでのSheetが出題元Sheetである、7つ目以降の解答結果Sheetは解答結果データ処理用である"]
["　出題元の左5Sheetに限り名称の変更可"]
["(3) 出題元Sheet内の既述行の削除、途中の行追加禁止"]
["　出題・解答操作では、出題元Sheetの行番号を問題番号として判定している"]
["(4) 解答結果Sheet"]
["　Sheet「Resultn1」内データは手動削除しても構わない(途中行に空白がないように削除すること)"]
["　データは正誤の履歴であることを認識して削除すること"]
["7.作成者"]
[" 　 S.HIMAJIN"]
["　 本ソフトの無断転載禁止"]