{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[3,1,3,3],[25,1,25,3]]}
["番号",null,"名前"]
[]
["【１】D列の多いものの順にランク関数を使用して順番をつけ、あいうえお順に並べ替えなさい"]
[null,"みんなの結果",null,null,"順位"]
[null,"田口","タグチ",8,{"$f":"RANK(D5,$D$5:$D$10)","v":6}]
[null,"田中","タナカ",9,{"$f":"RANK(D6,$D$5:$D$10)","v":5}]
[null,"上田","ウエダ",14,4]
[null,"中田","ナカタ",16,3]
[null,"鶴丸","ツルマル",20,2]
[null,"黒北","クロキタ",50,1]
[]
[]
[]
[]
["【２】商品表を参照して商品名と単価が入るようにしなさい。　　　※hlookup関数を使用する"]
[null,null,"納品書"]
[]
[null,"商品コード","商品名","単価","数量","金額"]
[null,"A102",{"$f":"HLOOKUP(B19,$C$27:$G$29,2,FALSE)","v":"TV-16"},{"$f":"HLOOKUP(B19,$C$27:$G$29,3,FALSE)","v":1200},20,{"$f":"D19*E19","v":24000}]
[null,"B501",{"$f":"HLOOKUP(B20,$C$27:$G$29,2,FALSE)","v":"VP-20"},{"$f":"HLOOKUP(B20,$C$27:$G$29,3,FALSE)","v":600},50,{"$f":"D20*E20","v":30000}]
[null,"A101","TV-14",800,30,{"$f":"D21*E21","v":24000}]
[null,"B502","VP-25",1500,20,{"$f":"D22*E22","v":30000}]
[null,"C602","KX-46",2500,10,{"$f":"D23*E23","v":25000}]
[]
[]
[null,"商品表"]
[null,"商品コード","A101","A102","B501","B502","C602"]
[null,"商品名","TV-14","TV-16","VP-20","VP-25","KX-46"]
[null,"単価",800,1200,600,1500,2500]
[]
[]
[]
[]
[]
[]
["【３】80点以上はA、60点以上はB、40点以上はC、40点未満は不合格となるようにVLOOKUP関数を使って表示させなさい"]
[null,null,"得点","判定"]
[null,"田口",80,{"$f":"VLOOKUP(C38,$F$38:$G$41,2)","v":"A"},null,0,"不合格"]
[null,"田中",15,{"$f":"VLOOKUP(C39,$F$38:$G$41,2)","v":"不合格"},null,40,"C"]
[null,"上田",40,"C",null,60,"B"]
[null,"中田",45,"C",null,80,"A"]
[null,"鶴丸",98,"A"]
[null,"黒北",89,"A"]
[]
[]
["【４】１学期が４０点未満で追試も４０点未満のものに不合格といれなさい"]
[]
[null,null,"１学期","追試","判定"]
[null,"田口",35,35,{"$f":"IF(AND(C49<=40,D49<40),\"不合格\",\"\")","v":"不合格"}]
[null,"田中",73,null,{"$f":"IF(AND(C50<=40,D50<40),\"不合格\",\"\")","v":""}]
[null,"上田",36,39,"不合格"]
[null,"中田",75.599999999999994,null,""]
[null,"鶴丸",20,72.400000000000006,""]
[null,"黒北",73.599999999999994,null,""]
[]
[]
[]
[]
[]
["【５】組と番号を入れると氏名が表示されるようにindex関数を使用して入力しなさい"]
[null,"検索データ",null,null,"検索結果"]
[null,"組",2,null,"氏名"]
[null,"番号",2,null,{"$f":"INDEX(B66:D87,C63,C62)","v":"イ"}]
[]
[null,"１組","２組","３組"]
[1,"あ","ア","Ａ"]
[2,"い","イ","Ｂ"]
[3,"う","ウ","Ｃ"]
[4,"え","エ","Ｄ"]
[5,"お","オ","Ｅ"]
[6,"か","カ","Ｆ"]
[7,"き","キ","Ｇ"]
[8,"く","ク","Ｈ"]
[9,"け","ケ","Ｉ"]
[10,"こ","コ","Ｊ"]
[11,"さ","サ","Ｋ"]
[12,"し","シ","Ｌ"]
[13,"す","ス","Ｍ"]
[14,"せ","セ","Ｎ"]
[15,"そ","ソ","Ｏ"]
[16,"た","タ","Ｐ"]
[17,"ち","チ","Ｑ"]
[18,"つ","ツ","Ｒ"]
[19,"て","テ","Ｓ"]
[20,"と","ト","Ｔ"]
[21,"な","ナ","Ｕ"]
[22,"に","ニ"]
[]
[]
["【５】データベース関数を利用してメーカー別の売価合計を出しなさい"]
[]
[null,"テレビ大特化市販売価格表"]
[]
["番号","メーカー名","型番","数量","売価","売上数"]
[1,"Ａ","KU-20SW2",10,45000,{"$f":"D95*E95","v":450000}]
[2,"Ａ","KU-21VH1",15,47000,{"$f":"D96*E96","v":705000}]
[3,"Ｂ","TH-24WV30",24,105000,2520000]
[4,"Ｂ","TH-21ZA3",13,32800,426400]
[5,"Ｃ","24DW3ME",2,88500,177000]
[6,"Ｃ","21S21",1,29800,29800]
[7,"Ｄ","KC-24EX6",8,59600,476800]
[8,"Ｄ","KC-20HR6",5,62100,310500]
[9,"Ｄ","AV-20WVT5",3,62100,186300]
[]
[]
[null,"メーカー別売上合計"]
[null,"メーカー名","メーカー名","メーカー名","メーカー名"]
[null,"Ａ","Ｂ","Ｃ","Ｄ"]
[null,{"$f":"DSUM($A$94:$F$103,6,B107:B108)","v":1155000},{"$f":"DSUM($A$94:$F$103,6,C107:C108)","v":2946400},206800,973600]

{"sheet":"印刷","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,3],[15,4,16,4],[7,1,8,1],[1,2,1,3],[4,1,6,1]]}
[null,"番号",{"$f":"問題!B1","v":0}]
[null,"名前",{"$f":"問題!D1","v":0}]
[]
[]
[null,"【１】","C5",{"$f":"問題!C5","v":"タグチ"}]
[null,null,"C6",{"$f":"問題!C6","v":"タナカ"}]
[null,null,"E5",{"$f":"ViewFormula(問題!E5)","v":"=RANK(D5,$D$5:$D$10)"}]
[null,"【２】","商品名",{"$f":"ViewFormula(問題!C19)","v":"=HLOOKUP(B19,$C$27:$G$29,2,FALSE)"}]
[null,null,"単価",{"$f":"ViewFormula(問題!D19)","v":"=HLOOKUP(B19,$C$27:$G$29,3,FALSE)"}]
[null,"【３】","D38",{"$f":"ViewFormula(問題!D38)","v":"=VLOOKUP(C38,$F$38:$G$41,2)"}]
[null,"【４】","E49",{"$f":"ViewFormula(問題!E49)","v":"=IF(AND(C49<=40,D49<40),\"不合格\",\"\")"}]
[null,"【５】","E63",{"$f":"ViewFormula(問題!E63)","v":"=INDEX(B66:D87,C63,C62)"}]
[null,"【６】","A4",{"$f":"ViewFormula(問題!B109)","v":"=DSUM($A$94:$F$103,6,B107:B108)"}]