{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["分析","施設予約状況","利用時間前年比","前年比","集計","知識試験"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"利用時間前年比","index":2,"reason":"not_a_worksheet"}],"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":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"列ラベル"]
["行ラベル","その他","会員","学生","総計"]
["工作室"]
["合計 / 時間",8,null,6,14]
["合計 / 利用料金",12000,null,3000,15000]
["多目的室A"]
["合計 / 時間",null,11,1,12]
["合計 / 利用料金",null,11000,500,11500]
["多目的室B"]
["合計 / 時間",null,5,9,14]
["合計 / 利用料金",null,5000,4500,9500]
["調理室"]
["合計 / 時間",2,12,null,14]
["合計 / 利用料金",3000,12000,null,15000]
["和室"]
["合計 / 時間",19,null,null,19]
["合計 / 利用料金",28500,null,null,28500]
["全体の 合計 / 時間",29,28,16,73]
["全体の 合計 / 利用料金",43500,28000,8000,79500]

{"sheet":"施設予約状況","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
["氏名","高知　太郎",null,null,null,null,null,"施設コード表"]
[null,null,null,null,null,null,null,"施設コード","施設名"]
[null,null,"検索条件",null,"利用状況表",null,null,11,"多目的室A"]
[null,null,"施設コード",null,"利用件数","売上料金",null,12,"多目的室B"]
[null,null,11,null,{"$f":"DCOUNT(B14:I44,E14,C4:C5)","v":9},{"$f":"DSUM(B14:I44,I14,C4:C5)","v":40500},null,21,"調理室"]
[null,null,null,null,null,null,null,22,"工作室"]
[null,null,null,null,null,null,null,23,"和室"]
[null,null,"始","2023-06-12",null,"一時間あたりの利用金額"]
[null,null,"至",{"$f":"D8+7","v":"2023-06-19"},null,"学生：500円　会員：1,000円　その他：1,500円"]
[]
[]
[]
[null,"施設予約表"]
[null,"予約番号","予約日","曜日","施設コード","施設名","利用者種別","時間","利用料金"]
[null,30,"2023-06-12",{"$f":"C15","v":45089},11,{"$f":"VLOOKUP(E15,$H$2:$I$7,2,0)","v":"多目的室A"},"その他",3,{"$f":"IF(G15=\"学生\",500,IF(G15=\"会員\",1000,1500))*H15","v":4500}]
[null,2,"2023-06-18",45095,12,"多目的室B","学生",7,3500]
[null,11,"2023-06-12",45089,22,"工作室","その他",5,7500]
[null,1,"2023-06-13",45090,11,"多目的室A","その他",3,4500]
[null,5,"2023-06-18",45095,23,"和室","会員",10,10000]
[null,6,"2023-06-12",45089,21,"調理室","会員",8,8000]
[null,7,"2023-06-13",45090,11,"多目的室A","学生",1,500]
[null,18,"2023-06-13",45090,21,"調理室","その他",9,13500]
[null,4,"2023-06-13",45090,23,"和室","その他",9,13500]
[null,10,"2023-06-16",45093,12,"多目的室B","学生",9,4500]
[null,12,"2023-06-15",45092,21,"調理室","その他",2,3000]
[null,29,"2023-06-15",45092,22,"工作室","その他",8,12000]
[null,13,"2023-06-17",45094,21,"調理室","会員",12,12000]
[null,14,"2023-06-15",45092,11,"多目的室A","会員",3,3000]
[null,15,"2023-06-18",45095,21,"調理室","学生",9,4500]
[null,16,"2023-06-16",45093,22,"工作室","学生",6,3000]
[null,17,"2023-06-19",45096,12,"多目的室B","学生",12,6000]
[null,3,"2023-06-15",45092,23,"和室","その他",8,12000]
[null,19,"2023-06-12",45089,23,"和室","会員",5,5000]
[null,20,"2023-06-15",45092,11,"多目的室A","会員",2,2000]
[null,21,"2023-06-14",45091,12,"多目的室B","学生",7,3500]
[null,22,"2023-06-14",45091,21,"調理室","会員",6,6000]
[null,23,"2023-06-16",45093,11,"多目的室A","会員",6,6000]
[null,9,"2023-06-17",45094,23,"和室","その他",11,16500]
[null,25,"2023-06-15",45092,12,"多目的室B","会員",5,5000]
[null,26,"2023-06-15",45092,11,"多目的室A","学生",1,500]
[null,27,"2023-06-19",45096,21,"調理室","学生",12,6000]
[null,28,"2023-06-18",45095,11,"多目的室A","会員",6,6000]
[null,24,"2023-06-18",45095,12,"多目的室B","その他",3,4500]
[null,8,"2023-06-19",45096,11,"多目的室A","その他",9,13500]

{"sheet":"前年比","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"利用時間　前年比"]
[]
[null,"施設名","2022年6月","2023年6月"]
[null,"多目的室A",234,201]
[null,"多目的室B",225,236]
[null,"調理室",122,134]
[null,"工作室",192,146]
[null,"和室",208,237]

{"sheet":"集計","index":4,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"4月　利用件数",null,null,null,null,null,"4月～6月　利用件数"]
[null,"施設名","会員","その他",null,null,null,"施設名","学生","会員","その他"]
[null,"多目的室A",21,25,null,null,null,"多目的室A",39,72,63]
[null,"多目的室B",18,16,null,null,null,"多目的室B",33,67,41]
[null,"工作室",9,9,null,null,null,"工作室",20,36,22]
[null,"和室",30,26,null,null,null,"和室",28,65,53]
[null,null,null,null,null,null,null,"調理室",15,33,20]
[null,"5月　利用件数"]
[null,"施設名","その他","会員","学生"]
[null,"多目的室A",20,27,19]
[null,"多目的室B",15,29,18]
[null,"工作室",7,10,10]
[null,"和室",10,15,19]
[null,"調理室",10,18,9]
[]
[null,"6月　利用件数"]
[null,"施設名","会員","学生","その他"]
[null,"多目的室A",24,20,18]
[null,"多目的室B",20,15,10]
[null,"調理室",15,6,10]
[null,"工作室",17,10,6]
[null,"和室",20,9,17]

{"sheet":"知識試験","index":5,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"【問題Ⅵ","下の問題に解答しなさい。解答は解答欄に入力しなさい。"]
[]
[null,1,"Excelで数式を用いて計算を行う際に、「べき乗」を表す演算記号は次の中のどれですか？"]
[]
[null,null,"①"," *",null,"②","^",null,"③",">",null,"④","#",null,null,"解答","②"]
[]
[null,2,"数式の中で、参照されているセルが「F$４」と表示されている場合、列は相対参照、行は（　　　）されている。（　　　）に中に入る適切な語句は次の中のどれですか？"]
[]
[null,null,"①","絶対参照",null,"②","複合参照",null,"③","相対参照",null,"④","相互参照",null,null,"解答","①"]
[]
[null,3,"Excelでセルの値を別のシートや別のブックから参照する際に使う記号は何ですか？"]
[]
[null,null,"①"," *",null,"②","$",null,"③","%",null,"④"," !",null,null,"解答","④"]
[]
[null,4,"数式「＝INT(-10.１)」の結果は次の中のどれになりますか？"]
[]
[null,null,"①",10,null,"②",-10,null,"③",11,null,"④",-11,null,null,"解答","④"]
[]
[null,5,"Excelの関数「INDEX」は何を行いますか？"]
[]
[null,null,"①","指定されたセル範囲から特定の位置の値を返す",null,"②","指定されたセル範囲を合計する",null,"③","指定されたセル範囲に見出し（インデックス）をつける",null,"④","指定されたセル範囲に検索をかける",null,null,"解答","①"]
[]
[null,6,"セルA1には、［セルの書式設定］ダイアログボックスの［表示形式］タブにおいて、ユーザー定義の表示形式を「0\"人\"」と設定してあるとき、そのセルA1に数値「3.4」を入力すると、（　　　）のように表示される。（　　　　）に中に入る適切な値は次の中のどれですか？"]
[]
[null,null,"①","0人",null,"②","３人",null,"③","3.4人",null,"④","4人",null,null,"解答","②"]
[]
[null,7,"［フィルターオプションの設定］ダイアログボックスを用いて、OR条件でレコードを抽出する場合には、検索条件範囲内の（　　　）行に検索条件の条件式を入力すればよい。（　　　）の中に入る適切な語句は次の中のどれですか？"]
[]
[null,null,"①","同じ",null,"②","異なる",null,null,null,null,null,null,null,null,"解答","②"]
[]
[null,8,"［挿入］タブの［図形］ボタンの中の［二等辺三角形形］を選択し、（　　　）キーを押しながらドラッグすると、正三角形を描画することができる。（　　　）の中に入る適切な語句は次の中のどれですか？"]
[]
[null,null,"①","Esc",null,"②","Ctrl",null,"③","Shift",null,"④","Alt",null,null,"解答","③"]
[]
[null,9,"ExcelでセルA1に表示されている数値を小数第2位まで表示するための数式はどれですか？"]
[]
[null,null,"①","=ROUND(A1, 1) ",null,"②","=ROUND(A1, 2)",null,"③","=ROUND(A1, 0.01)",null,"④","=ROUND(A1, 0.001)",null,null,"解答","②"]
[]
[null,10,"Excelの関数「VLOOKUP」は何を行いますか？"]
[]
[null,null,"①","指定された値を検索し、該当するセルの値を返す",null,null,null,null,"②","セルの値を指定された値に変更する",null,null,null,null,null,"解答","①"]
[null,null,"③","セルの値を指定された範囲内で検索し、一致するセルのアドレスを返す ",null,null,null,null,"④","セルの内容を指定された値で割る"]