{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["売上状況（解答）","商品マスター","売上分析（解答）","集計表 (解答)","３月商品別グラフ","集計データ","仕入計画（解答）","知識試験"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"３月商品別グラフ","index":4,"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":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["氏名"]
[]
[null,null,null,null,null,null,null,null,"担当者名"]
[null,null,null,null,null,null,null,null,"佐藤"]
[]
[null,null,null,null,null,null,null,null,"地域","件数","金額"]
[null,null,null,null,null,null,null,null,"高知",{"$f":"COUNTIFS($I$13:$I$62,$I$4,$J$13:$J$62,I7)","v":4},{"$f":"SUMIFS($H$13:$H$62,$I$13:$I$62,$I$4,$J$13:$J$62,I7)","v":505000}]
[null,null,null,null,null,null,null,null,"愛媛",{"$f":"COUNTIFS($I$13:$I$62,$I$4,$J$13:$J$62,I8)","v":0},{"$f":"SUMIFS($H$13:$H$62,$I$13:$I$62,$I$4,$J$13:$J$62,I8)","v":0}]
[null,null,null,null,null,null,null,null,"香川",4,550000]
[null,null,null,null,null,null,null,null,"徳島",{"$f":"COUNTIFS($I$13:$I$62,$I$4,$J$13:$J$62,I10)","v":2},220000]
[null,"売上状況確認表"]
[null,"日付","顧客名","商品コード","商品名","数量","単価","売上額","営業担当","地域","判定"]
[null,"2025-03-01","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D13,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},5,{"$f":"VLOOKUP(D13,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F13*G13","v":150000},"鈴木","高知",{"$f":"IF(H13>=300000,\"◎\",IF(H13>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-02","大和電販株式会社","P003",{"$f":"VLOOKUP(D14,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},4,{"$f":"VLOOKUP(D14,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F14*G14","v":100000},"佐藤","徳島",{"$f":"IF(H14>=300000,\"◎\",IF(H14>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-03","大和電販株式会社","P001",{"$f":"VLOOKUP(D15,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},2,{"$f":"VLOOKUP(D15,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F15*G15","v":170000},"鈴木","香川",{"$f":"IF(H15>=300000,\"◎\",IF(H15>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-03","大和電販株式会社","P004",{"$f":"VLOOKUP(D16,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},5,{"$f":"VLOOKUP(D16,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F16*G16","v":150000},"鈴木","愛媛",{"$f":"IF(H16>=300000,\"◎\",IF(H16>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-04","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D17,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},3,{"$f":"VLOOKUP(D17,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F17*G17","v":90000},"佐藤","高知",{"$f":"IF(H17>=300000,\"◎\",IF(H17>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-04","シンエイ電機株式会社","P001",{"$f":"VLOOKUP(D18,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},1,{"$f":"VLOOKUP(D18,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F18*G18","v":85000},"鈴木","高知",{"$f":"IF(H18>=300000,\"◎\",IF(H18>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-05","誠電機株式会社","P004",{"$f":"VLOOKUP(D19,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},3,{"$f":"VLOOKUP(D19,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F19*G19","v":90000},"田中","高知",{"$f":"IF(H19>=300000,\"◎\",IF(H19>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-05","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D20,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},2,{"$f":"VLOOKUP(D20,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F20*G20","v":50000},"鈴木","高知",{"$f":"IF(H20>=300000,\"◎\",IF(H20>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-05","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D21,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},1,{"$f":"VLOOKUP(D21,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F21*G21","v":30000},"高橋","愛媛",{"$f":"IF(H21>=300000,\"◎\",IF(H21>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-06","シンエイ電機株式会社","P001",{"$f":"VLOOKUP(D22,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D22,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F22*G22","v":255000},"高橋","香川",{"$f":"IF(H22>=300000,\"◎\",IF(H22>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-06","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D23,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},2,{"$f":"VLOOKUP(D23,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F23*G23","v":50000},"鈴木","愛媛",{"$f":"IF(H23>=300000,\"◎\",IF(H23>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-07","大和電販株式会社","P002",{"$f":"VLOOKUP(D24,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},1,{"$f":"VLOOKUP(D24,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F24*G24","v":60000},"佐藤","香川",{"$f":"IF(H24>=300000,\"◎\",IF(H24>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-10","誠電機株式会社","P004",{"$f":"VLOOKUP(D25,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},2,{"$f":"VLOOKUP(D25,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F25*G25","v":60000},"田中","愛媛",{"$f":"IF(H25>=300000,\"◎\",IF(H25>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-10","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D26,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},3,{"$f":"VLOOKUP(D26,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F26*G26","v":90000},"佐藤","香川",{"$f":"IF(H26>=300000,\"◎\",IF(H26>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-11","誠電機株式会社","P001",{"$f":"VLOOKUP(D27,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},5,{"$f":"VLOOKUP(D27,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F27*G27","v":425000},"高橋","香川",{"$f":"IF(H27>=300000,\"◎\",IF(H27>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-12","大和電販株式会社","P002",{"$f":"VLOOKUP(D28,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},4,{"$f":"VLOOKUP(D28,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F28*G28","v":240000},"田中","香川",{"$f":"IF(H28>=300000,\"◎\",IF(H28>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-12","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D29,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},4,{"$f":"VLOOKUP(D29,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F29*G29","v":120000},"高橋","高知",{"$f":"IF(H29>=300000,\"◎\",IF(H29>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-12","誠電機株式会社","P004",{"$f":"VLOOKUP(D30,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},5,{"$f":"VLOOKUP(D30,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F30*G30","v":150000},"佐藤","高知",{"$f":"IF(H30>=300000,\"◎\",IF(H30>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-13","大和電販株式会社","P001",{"$f":"VLOOKUP(D31,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D31,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F31*G31","v":255000},"田中","高知",{"$f":"IF(H31>=300000,\"◎\",IF(H31>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-14","シンエイ電機株式会社","P001",{"$f":"VLOOKUP(D32,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D32,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F32*G32","v":255000},"高橋","香川",{"$f":"IF(H32>=300000,\"◎\",IF(H32>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-14","誠電機株式会社","P004",{"$f":"VLOOKUP(D33,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},4,{"$f":"VLOOKUP(D33,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F33*G33","v":120000},"田中","高知",{"$f":"IF(H33>=300000,\"◎\",IF(H33>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-15","誠電機株式会社","P003",{"$f":"VLOOKUP(D34,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},2,{"$f":"VLOOKUP(D34,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F34*G34","v":50000},"高橋","愛媛",{"$f":"IF(H34>=300000,\"◎\",IF(H34>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-16","誠電機株式会社","P004",{"$f":"VLOOKUP(D35,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},1,{"$f":"VLOOKUP(D35,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F35*G35","v":30000},"鈴木","愛媛",{"$f":"IF(H35>=300000,\"◎\",IF(H35>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-18","大和電販株式会社","P002",{"$f":"VLOOKUP(D36,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},5,{"$f":"VLOOKUP(D36,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F36*G36","v":300000},"佐藤","香川",{"$f":"IF(H36>=300000,\"◎\",IF(H36>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-19","シンエイ電機株式会社","P001",{"$f":"VLOOKUP(D37,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D37,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F37*G37","v":255000},"田中","徳島",{"$f":"IF(H37>=300000,\"◎\",IF(H37>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-19","誠電機株式会社","P001",{"$f":"VLOOKUP(D38,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},4,{"$f":"VLOOKUP(D38,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F38*G38","v":340000},"鈴木","高知",{"$f":"IF(H38>=300000,\"◎\",IF(H38>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-19","誠電機株式会社","P003",{"$f":"VLOOKUP(D39,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},4,{"$f":"VLOOKUP(D39,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F39*G39","v":100000},"田中","愛媛",{"$f":"IF(H39>=300000,\"◎\",IF(H39>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-20","誠電機株式会社","P001",{"$f":"VLOOKUP(D40,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D40,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F40*G40","v":255000},"高橋","高知",{"$f":"IF(H40>=300000,\"◎\",IF(H40>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-20","誠電機株式会社","P003",{"$f":"VLOOKUP(D41,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},1,{"$f":"VLOOKUP(D41,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F41*G41","v":25000},"佐藤","高知",{"$f":"IF(H41>=300000,\"◎\",IF(H41>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-21","誠電機株式会社","P001",{"$f":"VLOOKUP(D42,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},3,{"$f":"VLOOKUP(D42,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F42*G42","v":255000},"鈴木","香川",{"$f":"IF(H42>=300000,\"◎\",IF(H42>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-21","誠電機株式会社","P004",{"$f":"VLOOKUP(D43,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},3,{"$f":"VLOOKUP(D43,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F43*G43","v":90000},"鈴木","愛媛",{"$f":"IF(H43>=300000,\"◎\",IF(H43>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-22","誠電機株式会社","P001",{"$f":"VLOOKUP(D44,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},1,{"$f":"VLOOKUP(D44,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F44*G44","v":85000},"鈴木","香川",{"$f":"IF(H44>=300000,\"◎\",IF(H44>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-23","誠電機株式会社","P002",{"$f":"VLOOKUP(D45,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},2,{"$f":"VLOOKUP(D45,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F45*G45","v":120000},"高橋","高知",{"$f":"IF(H45>=300000,\"◎\",IF(H45>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-24","シンエイ電機株式会社","P002",{"$f":"VLOOKUP(D46,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},7,{"$f":"VLOOKUP(D46,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F46*G46","v":420000},"鈴木","徳島",{"$f":"IF(H46>=300000,\"◎\",IF(H46>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-24","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D47,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},1,{"$f":"VLOOKUP(D47,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F47*G47","v":25000},"田中","愛媛",{"$f":"IF(H47>=300000,\"◎\",IF(H47>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-24","大和電販株式会社","P003",{"$f":"VLOOKUP(D48,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},2,{"$f":"VLOOKUP(D48,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F48*G48","v":50000},"鈴木","愛媛",{"$f":"IF(H48>=300000,\"◎\",IF(H48>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-25","大和電販株式会社","P001",{"$f":"VLOOKUP(D49,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},5,{"$f":"VLOOKUP(D49,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F49*G49","v":425000},"高橋","愛媛",{"$f":"IF(H49>=300000,\"◎\",IF(H49>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-26","シンエイ電機株式会社","P001",{"$f":"VLOOKUP(D50,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},4,{"$f":"VLOOKUP(D50,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F50*G50","v":340000},"高橋","高知",{"$f":"IF(H50>=300000,\"◎\",IF(H50>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-26","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D51,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},5,{"$f":"VLOOKUP(D51,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F51*G51","v":125000},"高橋","香川",{"$f":"IF(H51>=300000,\"◎\",IF(H51>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-27","大和電販株式会社","P001",{"$f":"VLOOKUP(D52,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},2,{"$f":"VLOOKUP(D52,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F52*G52","v":170000},"田中","徳島",{"$f":"IF(H52>=300000,\"◎\",IF(H52>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-27","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D53,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},4,{"$f":"VLOOKUP(D53,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F53*G53","v":100000},"佐藤","香川",{"$f":"IF(H53>=300000,\"◎\",IF(H53>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-27","シンエイ電機株式会社","P002",{"$f":"VLOOKUP(D54,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},1,{"$f":"VLOOKUP(D54,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F54*G54","v":60000},"鈴木","愛媛",{"$f":"IF(H54>=300000,\"◎\",IF(H54>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-27","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D55,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},1,{"$f":"VLOOKUP(D55,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F55*G55","v":25000},"高橋","徳島",{"$f":"IF(H55>=300000,\"◎\",IF(H55>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-28","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D56,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},2,{"$f":"VLOOKUP(D56,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F56*G56","v":60000},"田中","徳島",{"$f":"IF(H56>=300000,\"◎\",IF(H56>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-29","シンエイ電機株式会社","P002",{"$f":"VLOOKUP(D57,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},4,{"$f":"VLOOKUP(D57,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F57*G57","v":240000},"佐藤","高知",{"$f":"IF(H57>=300000,\"◎\",IF(H57>=200000,\"○\",\"\"))","v":"○"}]
[null,"2025-03-29","シンエイ電機株式会社","P003",{"$f":"VLOOKUP(D58,商品マスター!$A$2:$C$5,2,0)","v":"プリンタ"},1,{"$f":"VLOOKUP(D58,商品マスター!$A$2:$C$5,3,0)","v":25000},{"$f":"F58*G58","v":25000},"田中","香川",{"$f":"IF(H58>=300000,\"◎\",IF(H58>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-30","誠電機株式会社","P002",{"$f":"VLOOKUP(D59,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},8,{"$f":"VLOOKUP(D59,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F59*G59","v":480000},"田中","高知",{"$f":"IF(H59>=300000,\"◎\",IF(H59>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-30","誠電機株式会社","P001",{"$f":"VLOOKUP(D60,商品マスター!$A$2:$C$5,2,0)","v":"ノートPC"},4,{"$f":"VLOOKUP(D60,商品マスター!$A$2:$C$5,3,0)","v":85000},{"$f":"F60*G60","v":340000},"高橋","高知",{"$f":"IF(H60>=300000,\"◎\",IF(H60>=200000,\"○\",\"\"))","v":"◎"}]
[null,"2025-03-31","大和電販株式会社","P002",{"$f":"VLOOKUP(D61,商品マスター!$A$2:$C$5,2,0)","v":"タブレット"},2,{"$f":"VLOOKUP(D61,商品マスター!$A$2:$C$5,3,0)","v":60000},{"$f":"F61*G61","v":120000},"佐藤","徳島",{"$f":"IF(H61>=300000,\"◎\",IF(H61>=200000,\"○\",\"\"))","v":""}]
[null,"2025-03-31","シンエイ電機株式会社","P004",{"$f":"VLOOKUP(D62,商品マスター!$A$2:$C$5,2,0)","v":"モニター"},3,{"$f":"VLOOKUP(D62,商品マスター!$A$2:$C$5,3,0)","v":30000},{"$f":"F62*G62","v":90000},"高橋","高知",{"$f":"IF(H62>=300000,\"◎\",IF(H62>=200000,\"○\",\"\"))","v":""}]

{"sheet":"商品マスター","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["商品コード","商品名","単価"]
["P001","ノートPC",85000]
["P002","タブレット",60000]
["P003","プリンタ",25000]
["P004","モニター",30000]

{"sheet":"売上分析（解答）","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["※このシートにピボットテーブルを作成してください。"]
[null,null,"地域"]
["商品名","値","愛媛","香川","高知","徳島","総計"]
["タブレット"]
[null,"合計 / 数量",1,10,14,9,34]
[null,"合計 / 売上額",60000,600000,840000,540000,2040000]
["ノートPC"]
[null,"合計 / 数量",5,17,19,5,46]
[null,"合計 / 売上額",425000,1445000,1615000,425000,3910000]
["プリンタ"]
[null,"合計 / 数量",11,10,3,5,29]
[null,"合計 / 売上額",275000,250000,75000,125000,725000]
["モニター"]
[null,"合計 / 数量",12,3,27,2,44]
[null,"合計 / 売上額",360000,90000,810000,60000,1320000]
["全体の 合計 / 数量",null,29,40,63,21,153]
["全体の 合計 / 売上額",null,1120000,2385000,3340000,1150000,7995000]

{"sheet":"集計表 (解答)","index":3,"n_rows":73,"n_cols":6,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["営業担当者地域別集計"]
[]
["営業担当","地域","商品名","単価","数量","売上額"]
["高橋","愛媛","モニター",30000,1,{"$f":"D4*E4","v":30000}]
["高橋","愛媛","プリンタ",25000,2,{"$f":"D5*E5","v":50000}]
["高橋","愛媛","ノートPC",85000,5,{"$f":"D6*E6","v":425000}]
[null,"愛媛 集計",null,null,{"$f":"SUBTOTAL(9,E4:E6)","v":8},{"$f":"SUBTOTAL(9,F4:F6)","v":505000}]
["高橋","香川","ノートPC",85000,3,{"$f":"D8*E8","v":255000}]
["高橋","香川","ノートPC",85000,5,{"$f":"D9*E9","v":425000}]
["高橋","香川","ノートPC",85000,3,{"$f":"D10*E10","v":255000}]
["高橋","香川","プリンタ",25000,5,{"$f":"D11*E11","v":125000}]
[null,"香川 集計",null,null,{"$f":"SUBTOTAL(9,E8:E11)","v":16},{"$f":"SUBTOTAL(9,F8:F11)","v":1060000}]
["高橋","高知","モニター",30000,4,{"$f":"D13*E13","v":120000}]
["高橋","高知","ノートPC",85000,3,255000]
["高橋","高知","タブレット",60000,2,120000]
["高橋","高知","ノートPC",85000,4,340000]
["高橋","高知","ノートPC",85000,4,340000]
["高橋","高知","モニター",30000,3,90000]
[null,"高知 集計",null,null,{"$f":"SUBTOTAL(9,E13:E18)","v":20},{"$f":"SUBTOTAL(9,F13:F18)","v":1265000}]
["高橋","徳島","プリンタ",25000,1,{"$f":"D20*E20","v":25000}]
[null,"徳島 集計",null,null,{"$f":"SUBTOTAL(9,E20:E20)","v":1},{"$f":"SUBTOTAL(9,F20:F20)","v":25000}]
["高橋 集計",null,null,null,{"$f":"SUBTOTAL(9,E4:E20)","v":45},{"$f":"SUBTOTAL(9,F4:F20)","v":2855000}]
["佐藤","香川","タブレット",60000,1,{"$f":"D23*E23","v":60000}]
["佐藤","香川","モニター",30000,3,{"$f":"D24*E24","v":90000}]
["佐藤","香川","タブレット",60000,5,{"$f":"D25*E25","v":300000}]
["佐藤","香川","プリンタ",25000,4,{"$f":"D26*E26","v":100000}]
[null,"香川 集計",null,null,{"$f":"SUBTOTAL(9,E23:E26)","v":13},{"$f":"SUBTOTAL(9,F23:F26)","v":550000}]
["佐藤","高知","モニター",30000,3,{"$f":"D28*E28","v":90000}]
["佐藤","高知","モニター",30000,5,{"$f":"D29*E29","v":150000}]
["佐藤","高知","プリンタ",25000,1,{"$f":"D30*E30","v":25000}]
["佐藤","高知","タブレット",60000,4,{"$f":"D31*E31","v":240000}]
[null,"高知 集計",null,null,{"$f":"SUBTOTAL(9,E28:E31)","v":13},{"$f":"SUBTOTAL(9,F28:F31)","v":505000}]
["佐藤","徳島","プリンタ",25000,4,{"$f":"D33*E33","v":100000}]
["佐藤","徳島","タブレット",60000,2,{"$f":"D34*E34","v":120000}]
[null,"徳島 集計",null,null,{"$f":"SUBTOTAL(9,E33:E34)","v":6},{"$f":"SUBTOTAL(9,F33:F34)","v":220000}]
["佐藤 集計",null,null,null,{"$f":"SUBTOTAL(9,E23:E34)","v":32},{"$f":"SUBTOTAL(9,F23:F34)","v":1275000}]
["田中","愛媛","モニター",30000,2,{"$f":"D37*E37","v":60000}]
["田中","愛媛","プリンタ",25000,4,{"$f":"D38*E38","v":100000}]
["田中","愛媛","プリンタ",25000,1,{"$f":"D39*E39","v":25000}]
[null,"愛媛 集計",null,null,{"$f":"SUBTOTAL(9,E37:E39)","v":7},{"$f":"SUBTOTAL(9,F37:F39)","v":185000}]
["田中","香川","タブレット",60000,4,{"$f":"D41*E41","v":240000}]
["田中","香川","プリンタ",25000,1,{"$f":"D42*E42","v":25000}]
[null,"香川 集計",null,null,{"$f":"SUBTOTAL(9,E41:E42)","v":5},{"$f":"SUBTOTAL(9,F41:F42)","v":265000}]
["田中","高知","モニター",30000,3,{"$f":"D44*E44","v":90000}]
["田中","高知","ノートPC",85000,3,{"$f":"D45*E45","v":255000}]
["田中","高知","モニター",30000,4,{"$f":"D46*E46","v":120000}]
["田中","高知","タブレット",60000,8,{"$f":"D47*E47","v":480000}]
[null,"高知 集計",null,null,{"$f":"SUBTOTAL(9,E44:E47)","v":18},{"$f":"SUBTOTAL(9,F44:F47)","v":945000}]
["田中","徳島","ノートPC",85000,3,{"$f":"D49*E49","v":255000}]
["田中","徳島","ノートPC",85000,2,{"$f":"D50*E50","v":170000}]
["田中","徳島","モニター",30000,2,{"$f":"D51*E51","v":60000}]
[null,"徳島 集計",null,null,{"$f":"SUBTOTAL(9,E49:E51)","v":7},{"$f":"SUBTOTAL(9,F49:F51)","v":485000}]
["田中 集計",null,null,null,{"$f":"SUBTOTAL(9,E37:E51)","v":37},{"$f":"SUBTOTAL(9,F37:F51)","v":1880000}]
["鈴木","愛媛","モニター",30000,5,{"$f":"D54*E54","v":150000}]
["鈴木","愛媛","プリンタ",25000,2,50000]
["鈴木","愛媛","モニター",30000,1,30000]
["鈴木","愛媛","モニター",30000,3,90000]
["鈴木","愛媛","プリンタ",25000,2,50000]
["鈴木","愛媛","タブレット",60000,1,60000]
[null,"愛媛 集計",null,null,{"$f":"SUBTOTAL(9,E54:E59)","v":14},{"$f":"SUBTOTAL(9,F54:F59)","v":430000}]
["鈴木","香川","ノートPC",85000,2,{"$f":"D61*E61","v":170000}]
["鈴木","香川","ノートPC",85000,3,{"$f":"D62*E62","v":255000}]
["鈴木","香川","ノートPC",85000,1,{"$f":"D63*E63","v":85000}]
[null,"香川 集計",null,null,{"$f":"SUBTOTAL(9,E61:E63)","v":6},{"$f":"SUBTOTAL(9,F61:F63)","v":510000}]
["鈴木","高知","モニター",30000,5,{"$f":"D65*E65","v":150000}]
["鈴木","高知","ノートPC",85000,1,{"$f":"D66*E66","v":85000}]
["鈴木","高知","プリンタ",25000,2,{"$f":"D67*E67","v":50000}]
["鈴木","高知","ノートPC",85000,4,{"$f":"D68*E68","v":340000}]
[null,"高知 集計",null,null,{"$f":"SUBTOTAL(9,E65:E68)","v":12},{"$f":"SUBTOTAL(9,F65:F68)","v":625000}]
["鈴木","徳島","タブレット",60000,7,{"$f":"D70*E70","v":420000}]
[null,"徳島 集計",null,null,{"$f":"SUBTOTAL(9,E70:E70)","v":7},{"$f":"SUBTOTAL(9,F70:F70)","v":420000}]
["鈴木 集計",null,null,null,{"$f":"SUBTOTAL(9,E54:E70)","v":39},{"$f":"SUBTOTAL(9,F54:F70)","v":1985000}]
["総計",null,null,null,{"$f":"SUBTOTAL(9,E4:E70)","v":153},{"$f":"SUBTOTAL(9,F4:F70)","v":7995000}]

{"sheet":"集計データ","index":5,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["商品別売上集計"]
[]
[null,"高知","愛媛","香川","徳島","平均"]
["タブレット",840000,60000,600000,540000,{"$f":"AVERAGE(B4:E4)","v":510000}]
["ノートPC",1615000,425000,1445000,425000,{"$f":"AVERAGE(B5:E5)","v":977500}]
["プリンタ",75000,275000,250000,125000,181250]
["モニター",810000,360000,90000,60000,330000]
["平均",{"$f":"AVERAGE(B4:B7)","v":835000},280000,596250,{"$f":"AVERAGE(E4:E7)","v":287500},499687.5]

{"sheet":"仕入計画（解答）","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,4]]}
[]
[null,"仕入計画表"]
[null,"商品名","仕入単価","売価","利益","仕入台数","仕入金額","総利益"]
[null,"ノートPC",65000,85000,20000,7,{"$f":"C4*F4","v":455000},{"$f":"E4*F4","v":140000}]
[null,"タブレット",45000,60000,15000,6,{"$f":"C5*F5","v":270000},{"$f":"E5*F5","v":90000}]
[null,"プリンタ",20000,30000,10000,5,{"$f":"C6*F6","v":100000},{"$f":"E6*F6","v":50000}]
[null,"モニター",25000,30000,5000,7,{"$f":"C7*F7","v":175000},{"$f":"E7*F7","v":35000}]
[null,"合計",null,null,null,{"$f":"SUM(F4:F7)","v":25},{"$f":"SUM(G4:G7)","v":1000000},{"$f":"SUM(H4:H7)","v":315000}]

{"sheet":"知識試験","index":7,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"【問題Ⅵ","下の問題に解答しなさい。解答は解答欄に入力しなさい。"]
[]
[null,"1","列全体を選択するショートカットキーとして正しいのは次のうちどれか答えなさい。"]
[]
[null,null,"①"," alt+ Space",null,"②"," Ctrl + Space",null,"③","Shift + Space",null,"④"," Ctrl + Shift + Enter",null,null,"解答","②"]
[]
[]
[null,"2","新しいワークシートを挿入するショートカットとして正しいのは次のうちどれか答えなさい。"]
[]
[null,null,"①","Alt + F1",null,"②","Ctrl + Shift + N",null,"③"," Shift + F11",null,"④","Ctrl + Shift + Insert",null,null,"解答","③"]
[]
[null,"3","ROUND関数の桁数（第2引数）に「-1」を指定すると四捨五入される桁は次のうちどれか答えなさい。"]
[]
[null,null,"①","小数点第1位を四捨五入",null,"②","1の位を四捨五入",null,"③","10の位を四捨五入",null,"④","エラーになる",null,null,"解答","②"]
[]
[null,"4","＜図1＞において、セルF２に「=B２&C２&D２」と入力した場合の結果はどのようになる。"]
[]
[null,null,"＜図１＞",null,null,null,null,null,"①","3つの値が文字列として連結"]
[null,null,null,null,null,null,null,null,"②","各セルの合計"]
[null,null,null,null,null,null,null,null,"③","複数セルの平均",null,null,null,null,null,"解答","①"]
[null,null,null,null,null,null,null,null,"④","エラーになる"]
[]
[null,"5","ショートカットキーの【Ctrl + ; 】で挿入されるのは次のうちどれか答えなさい。"]
[]
[null,null,"①"," 現在の時刻",null,"②","現在の日付",null,"③","セルのコメント",null,"④","シート名",null,null,"解答","②"]
[]
[null,"6","Excelファイルにパスワードを設定する方法として正しいのは次のうちどれか答えなさい。"]
[]
[null,null,"①","「校閲」→「シート保護」",null,null,null,null,"②","「ファイル」→「情報」→「ブックの保護」",null,null,null,null,null,"解答","②"]
[null,null,"③","「データ」→「データの入力規則」",null,null,null,null,"④","「ファイル」→「情報」→「ブックの管理」"]
[]
[null,"7","複数のシートを一括で印刷する方法として正しいのは次のうちどれか答えなさい。"]
[]
[null,null,"①","シートを複数選択して印刷",null,null,null,null,"②","ファイルを保存してから印刷",null,null,null,null,null,"解答","①"]
[null,null,"③","シートを並べ替えてから印刷",null,null,null,null,"④","ページレイアウトタブで設定"]
[]
[null,"8","グラフの「凡例」とは次のうちどれか答えなさい。"]
[]
[null,null,"①","グラフの背景色を示す設定",null,null,null,null,"②","グラフを印刷するための区切り",null,null,null,null,null,"解答","④"]
[null,null,"③","軸のタイトルを変更する操作",null,null,null,null,"④","各系列が何を表すかを示す案内"]
[]
[null,"9","TEXT関数で「2025/05/09」の日付を「2025年05月09日」にしたいときの書式は次のうちどれか答えなさい。"]
[]
[null,null,"①","yyyy\"年\"mm\"月\"dd\"日\"",null,null,"②","yyyy年mm月dd日",null,null,"③","\"yyyy年mm月dd日\"",null,null,null,"解答","③"]
[]
[]
[null,"10","「=$A$1」と「=A1」の違いを答えなさい。"]
[]
[null,null,"①","コピーしたときに参照先が変わるかどうか",null,null,null,null,"②","見た目だけの違い",null,null,null,null,null,"解答","①"]