{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["売上集計","若者詳細","分析","購入者詳細","年代別好きな具","人気具材","目標","知識試験"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":54,"n_cols":9,"rows_kept":54,"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,null,"高知駅前店","子ども",{"$f":"DSUM(B14:G54,G14,G5:H6)","v":1150}]
[null,"曜日・天気別売上金額集計表"]
[null,null,"月","火","水","木","金","土","日"]
[null,"晴",{"$f":"SUMIFS($G$15:$G$54,$C$15:$C$54,C$8,$D$15:$D$54,$B9)","v":1120},{"$f":"SUMIFS($G$15:$G$54,$C$15:$C$54,D$8,$D$15:$D$54,$B9)","v":1100},200,1740,720,4090,2940]
[null,"曇",{"$f":"SUMIFS($G$15:$G$54,$C$15:$C$54,C$8,$D$15:$D$54,$B10)","v":500},1020,200,0,500,0,1100]
[null,"雨・雪",600,400,1990,600,0,400,930]
[]
[null,"３店舗おにぎり売上表（6/16～6/22）"]
[null,"日","曜日","天気","店舗","年齢層","売上",null,"店舗"]
[null,"2024-06-16",{"$f":"TEXT(B15,\"aaa\")","v":"日"},"晴","高知駅前店","高齢者",400,null,"高知駅前店"]
[null,"2024-06-16",{"$f":"TEXT(B16,\"aaa\")","v":"日"},"曇","桟橋店","子ども",900,null,"桟橋店"]
[null,"2024-06-16","日","雨・雪","旭店","若者",180,null,"旭店"]
[null,"2024-06-16","日","晴","桟橋店","中高年",200]
[null,"2024-06-16","日","晴","桟橋店","子ども",500,null,"年齢層"]
[null,"2024-06-16","日","曇","高知駅前店","中高年",200,null,"子ども"]
[null,"2024-06-16","日","晴","桟橋店","中高年",800,null,"若者"]
[null,"2024-06-16","日","雨・雪","高知駅前店","子ども",750,null,"中高年"]
[null,"2024-06-16","日","晴","高知駅前店","高齢者",840,null,"高齢者"]
[null,"2024-06-16","日","晴","桟橋店","高齢者",200]
[null,"2024-06-17","月","晴","桟橋店","中高年",300]
[null,"2024-06-17","月","晴","旭店","子ども",400]
[null,"2024-06-17","月","雨・雪","桟橋店","子ども",600]
[null,"2024-06-17","月","晴","高知駅前店","若者",420]
[null,"2024-06-17","月","曇","旭店","子ども",500]
[null,"2024-06-18","火","晴","桟橋店","若者",300]
[null,"2024-06-18","火","晴","高知駅前店","中高年",200]
[null,"2024-06-18","火","雨・雪","高知駅前店","高齢者",400]
[null,"2024-06-18","火","晴","桟橋店","高齢者",600]
[null,"2024-06-18","火","曇","旭店","中高年",600]
[null,"2024-06-18","火","曇","旭店","高齢者",420]
[null,"2024-06-19","水","雨・雪","高知駅前店","子ども",400]
[null,"2024-06-19","水","雨・雪","桟橋店","若者",840]
[null,"2024-06-19","水","雨・雪","旭店","若者",750]
[null,"2024-06-19","水","曇","高知駅前店","高齢者",200]
[null,"2024-06-19","水","晴","桟橋店","子ども",200]
[null,"2024-06-20","木","晴","高知駅前店","高齢者",840]
[null,"2024-06-20","木","晴","桟橋店","高齢者",200]
[null,"2024-06-20","木","晴","桟橋店","中高年",300]
[null,"2024-06-20","木","晴","旭店","子ども",400]
[null,"2024-06-20","木","雨・雪","桟橋店","子ども",600]
[null,"2024-06-21","金","晴","高知駅前店","若者",420]
[null,"2024-06-21","金","曇","旭店","子ども",500]
[null,"2024-06-21","金","晴","桟橋店","若者",300]
[null,"2024-06-22","土","晴","高知駅前店","中高年",200]
[null,"2024-06-22","土","雨・雪","高知駅前店","高齢者",400]
[null,"2024-06-22","土","晴","桟橋店","高齢者",840]
[null,"2024-06-22","土","晴","高知駅前店","高齢者",750]
[null,"2024-06-22","土","晴","高知駅前店","若者",800]
[null,"2024-06-22","土","晴","旭店","中高年",1500]

{"sheet":"若者詳細","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["No.","店舗","性別","年齢層","購入アイテム","単価\n(税抜)","個数","購入金額\n(税込)","支払方法"]
[32,"高知駅前店","女","若者","こんぶ",200,1,216,"キャッシュレス決済"]
[39,"高知駅前店","女","若者","ツナマヨ",200,4,864,"クレジット"]
[14,"高知駅前店","男","若者","こんぶ",200,1,216,"キャッシュレス決済"]

{"sheet":"分析","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["店舗","高知駅前店"]
[]
["合計 / 個数",null,"購入アイテム"]
["年齢層","性別","こんぶ","ツナマヨ","塩むすび","鮭","梅","総計"]
["高齢者","女",null,2,null,null,null,2]
[null,"男",4,null,null,5,3,12]
["高齢者 集計",null,4,2,null,5,3,14]
["子ども","女",null,2,null,null,null,2]
[null,"男",null,null,null,null,3,3]
["子ども 集計",null,null,2,null,null,3,5]
["若者","女",1,4,null,null,null,5]
[null,"男",1,null,null,null,null,1]
["若者 集計",null,2,4,null,null,null,6]
["中高年","女",null,1,1,null,null,2]
[null,"男",null,1,null,null,null,1]
["中高年 集計",null,null,2,1,null,null,3]
["総計",null,6,10,1,5,6,28]

{"sheet":"購入者詳細","index":3,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"おにぎり購入者詳細データ"]
[null,"調査日程：6月16日～6月22日"]
[]
[null,"No.","店舗","性別","年齢層","購入アイテム","単価\n(税抜)","個数","購入金額\n(税込)","支払方法"]
[null,1,"高知駅前店","女","高齢者","ツナマヨ",{"$f":"VLOOKUP(F6,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G6*H6*1.08,0)","v":432},"現金",null,"おにぎり具材","単価(税抜)"]
[null,2,"桟橋店","男","子ども","塩むすび",{"$f":"VLOOKUP(F7,$L$7:$M$13,2,0)","v":150},3,{"$f":"ROUNDDOWN(G7*H7*1.08,0)","v":486},"現金",null,"ツナマヨ",200]
[null,21,"旭店","男","高齢者","こんぶ",{"$f":"VLOOKUP(F8,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G8*H8*1.08,0)","v":216},"現金",null,"明太子・たらこ",420]
[null,4,"桟橋店","女","中高年","ツナマヨ",{"$f":"VLOOKUP(F9,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G9*H9*1.08,0)","v":216},"クレジット",null,"こんぶ",200]
[null,5,"桟橋店","男","子ども","塩むすび",{"$f":"VLOOKUP(F10,$L$7:$M$13,2,0)","v":150},2,{"$f":"ROUNDDOWN(G10*H10*1.08,0)","v":324},"現金",null,"おかか",180]
[null,6,"高知駅前店","女","中高年","塩むすび",{"$f":"VLOOKUP(F11,$L$7:$M$13,2,0)","v":150},1,{"$f":"ROUNDDOWN(G11*H11*1.08,0)","v":162},"現金",null,"鮭",250]
[null,7,"桟橋店","男","中高年","鮭",{"$f":"VLOOKUP(F12,$L$7:$M$13,2,0)","v":250},4,{"$f":"ROUNDDOWN(G12*H12*1.08,0)","v":1080},"キャッシュレス決済",null,"梅",180]
[null,8,"高知駅前店","男","子ども","梅",{"$f":"VLOOKUP(F13,$L$7:$M$13,2,0)","v":180},3,{"$f":"ROUNDDOWN(G13*H13*1.08,0)","v":583},"現金",null,"塩むすび",150]
[null,9,"高知駅前店","男","高齢者","こんぶ",{"$f":"VLOOKUP(F14,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G14*H14*1.08,0)","v":432},"キャッシュレス決済"]
[null,10,"桟橋店","女","高齢者","鮭",{"$f":"VLOOKUP(F15,$L$7:$M$13,2,0)","v":250},1,{"$f":"ROUNDDOWN(G15*H15*1.08,0)","v":270},"クレジット",null,"支払方法"]
[null,11,"桟橋店","女","中高年","明太子・たらこ",{"$f":"VLOOKUP(F16,$L$7:$M$13,2,0)","v":420},1,{"$f":"ROUNDDOWN(G16*H16*1.08,0)","v":453},"キャッシュレス決済",null,"クレジット"]
[null,12,"旭店","女","子ども","ツナマヨ",{"$f":"VLOOKUP(F17,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G17*H17*1.08,0)","v":432},"現金",null,"現金"]
[null,13,"桟橋店","男","子ども","ツナマヨ",{"$f":"VLOOKUP(F18,$L$7:$M$13,2,0)","v":200},3,{"$f":"ROUNDDOWN(G18*H18*1.08,0)","v":648},"現金",null,"キャッシュレス決済"]
[null,14,"高知駅前店","男","若者","こんぶ",{"$f":"VLOOKUP(F19,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G19*H19*1.08,0)","v":216},"キャッシュレス決済"]
[null,30,"旭店","男","子ども","ツナマヨ",{"$f":"VLOOKUP(F20,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G20*H20*1.08,0)","v":432},"現金"]
[null,16,"桟橋店","男","若者","明太子・たらこ",{"$f":"VLOOKUP(F21,$L$7:$M$13,2,0)","v":420},1,{"$f":"ROUNDDOWN(G21*H21*1.08,0)","v":453},"キャッシュレス決済"]
[null,17,"高知駅前店","女","中高年","ツナマヨ",{"$f":"VLOOKUP(F22,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G22*H22*1.08,0)","v":216},"クレジット"]
[null,18,"高知駅前店","男","高齢者","鮭",{"$f":"VLOOKUP(F23,$L$7:$M$13,2,0)","v":250},2,{"$f":"ROUNDDOWN(G23*H23*1.08,0)","v":540},"現金"]
[null,19,"桟橋店","女","高齢者","明太子・たらこ",{"$f":"VLOOKUP(F24,$L$7:$M$13,2,0)","v":420},2,{"$f":"ROUNDDOWN(G24*H24*1.08,0)","v":907},"現金"]
[null,15,"旭店","男","子ども","梅",{"$f":"VLOOKUP(F25,$L$7:$M$13,2,0)","v":180},2,{"$f":"ROUNDDOWN(G25*H25*1.08,0)","v":388},"キャッシュレス決済"]
[null,33,"旭店","女","子ども","梅",{"$f":"VLOOKUP(F26,$L$7:$M$13,2,0)","v":180},2,{"$f":"ROUNDDOWN(G26*H26*1.08,0)","v":388},"キャッシュレス決済"]
[null,22,"高知駅前店","女","子ども","ツナマヨ",{"$f":"VLOOKUP(F27,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G27*H27*1.08,0)","v":432},"現金"]
[null,23,"桟橋店","男","若者","こんぶ",{"$f":"VLOOKUP(F28,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G28*H28*1.08,0)","v":432},"キャッシュレス決済"]
[null,20,"旭店","男","中高年","塩むすび",{"$f":"VLOOKUP(F29,$L$7:$M$13,2,0)","v":150},3,{"$f":"ROUNDDOWN(G29*H29*1.08,0)","v":486},"キャッシュレス決済"]
[null,25,"高知駅前店","男","高齢者","鮭",{"$f":"VLOOKUP(F30,$L$7:$M$13,2,0)","v":250},1,{"$f":"ROUNDDOWN(G30*H30*1.08,0)","v":270},"キャッシュレス決済"]
[null,26,"桟橋店","女","子ども","ツナマヨ",{"$f":"VLOOKUP(F31,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G31*H31*1.08,0)","v":216},"現金"]
[null,27,"高知駅前店","男","高齢者","こんぶ",{"$f":"VLOOKUP(F32,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G32*H32*1.08,0)","v":432},"キャッシュレス決済"]
[null,28,"桟橋店","男","高齢者","鮭",{"$f":"VLOOKUP(F33,$L$7:$M$13,2,0)","v":250},1,{"$f":"ROUNDDOWN(G33*H33*1.08,0)","v":270},"クレジット"]
[null,29,"桟橋店","女","中高年","塩むすび",{"$f":"VLOOKUP(F34,$L$7:$M$13,2,0)","v":150},1,{"$f":"ROUNDDOWN(G34*H34*1.08,0)","v":162},"キャッシュレス決済"]
[null,40,"旭店","女","中高年","明太子・たらこ",{"$f":"VLOOKUP(F35,$L$7:$M$13,2,0)","v":420},5,{"$f":"ROUNDDOWN(G35*H35*1.08,0)","v":2268},"キャッシュレス決済"]
[null,31,"桟橋店","男","子ども","ツナマヨ",{"$f":"VLOOKUP(F36,$L$7:$M$13,2,0)","v":200},3,{"$f":"ROUNDDOWN(G36*H36*1.08,0)","v":648},"現金"]
[null,32,"高知駅前店","女","若者","こんぶ",{"$f":"VLOOKUP(F37,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G37*H37*1.08,0)","v":216},"キャッシュレス決済"]
[null,3,"旭店","男","若者","こんぶ",{"$f":"VLOOKUP(F38,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G38*H38*1.08,0)","v":216},"クレジット"]
[null,34,"桟橋店","男","若者","明太子・たらこ",{"$f":"VLOOKUP(F39,$L$7:$M$13,2,0)","v":420},1,{"$f":"ROUNDDOWN(G39*H39*1.08,0)","v":453},"キャッシュレス決済"]
[null,35,"高知駅前店","男","中高年","ツナマヨ",{"$f":"VLOOKUP(F40,$L$7:$M$13,2,0)","v":200},1,{"$f":"ROUNDDOWN(G40*H40*1.08,0)","v":216},"クレジット"]
[null,36,"高知駅前店","男","高齢者","鮭",{"$f":"VLOOKUP(F41,$L$7:$M$13,2,0)","v":250},2,{"$f":"ROUNDDOWN(G41*H41*1.08,0)","v":540},"現金"]
[null,37,"桟橋店","女","高齢者","こんぶ",{"$f":"VLOOKUP(F42,$L$7:$M$13,2,0)","v":200},2,{"$f":"ROUNDDOWN(G42*H42*1.08,0)","v":432},"現金"]
[null,38,"高知駅前店","男","高齢者","梅",{"$f":"VLOOKUP(F43,$L$7:$M$13,2,0)","v":180},3,{"$f":"ROUNDDOWN(G43*H43*1.08,0)","v":583},"現金"]
[null,39,"高知駅前店","女","若者","ツナマヨ",{"$f":"VLOOKUP(F44,$L$7:$M$13,2,0)","v":200},4,{"$f":"ROUNDDOWN(G44*H44*1.08,0)","v":864},"クレジット"]
[null,24,"旭店","男","若者","梅",{"$f":"VLOOKUP(F45,$L$7:$M$13,2,0)","v":180},3,{"$f":"ROUNDDOWN(G45*H45*1.08,0)","v":583},"現金"]

{"sheet":"人気具材","index":5,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"コンビニおにぎりで最も好きな具は何ですか？"]
[null,null,"20代","30代","40代","50代以上","全体"]
[null,"ツナマヨ",0.24,0.32,0.28000000000000003,0.2,0.27]
[null,"明太子・たらこ",0.24,0.22,0.28000000000000003,0.28999999999999998,0.26]
[null,"こんぶ",0.28000000000000003,0.2,0.21,0.24,0.23]
[null,"おかか",0.08,0.1,7.0000000000000007E-2,0.06,0.08]
[null,"鮭",0.04,0.04,0.06,0.08,0.05]
[null,"梅",0.03,0.01,0.03,0.04,0.03]
[null,"塩むすび",0.03,0.04,0.01,0.02,0.02]
[null,"その他",0.06,7.0000000000000007E-2,0.06,7.0000000000000007E-2,0.06]
[null,"合計",{"$f":"SUM(C4:C11)","v":1},{"$f":"SUM(D4:D11)","v":1},{"$f":"SUM(E4:E11)","v":1.0000000000000002},{"$f":"SUM(F4:F11)","v":1},{"$f":"SUM(G4:G11)","v":1}]

{"sheet":"目標","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2023年度　おにぎり売上実績"]
[]
[null,null,"高知駅前店","桟橋店","旭店","合計"]
[null,"販売個数",24354,19562,16753,{"$f":"SUM(C5:E5)","v":60669}]
[null,"売上金額",4870800,4499260,3518130,{"$f":"SUM(C6:E6)","v":12888190}]
[]
[]
[null,"2024年度　おにぎり売上目標",null,null,"目標売上向上率",0.16385621254807692]
[]
[null,null,"高知駅前店","桟橋店","旭店","合計"]
[null,"販売個数",25000,20000,17000,{"$f":"SUM(C12:E12)","v":62000}]
[null,"売上金額",{"$f":"C6+C6*$F$9","v":5668910.8400791734},{"$f":"D6+D6*$F$9","v":5236491.7028690604},4094597.4570517661,{"$f":"SUM(C13:E13)","v":15000000}]

{"sheet":"知識試験","index":7,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"【問題Ⅵ","下の問題に解答しなさい。解答は解答欄に入力しなさい。"]
[]
[null,"1","数式の中で、参照されているセルが「$F6」と表示されている場合、列は絶対参照、行は（　　　）されている。（　　　）に中に入る適切な語句は次の中のどれですか？"]
[]
[null,null,"①","絶対参照",null,"②","複合参照",null,"③","相対参照",null,"④","相互参照",null,null,"解答","③"]
[]
[]
[null,"2","数式「＝INT(-10.5)」の結果は次の中のどれになりますか？"]
[]
[null,null,"①",10,null,"②",-10,null,"③",11,null,"④",-11,null,null,"解答","④"]
[]
[null,"3","Ctrlキーを押しながら、（　　　）キーを押すと、印刷プレビュー画面が表示される。"]
[]
[null,null,"①","C",null,"②","S",null,"③","P",null,"④","I",null,null,"解答","③"]
[]
[null,"4","［並べ替え］ダイアログボックスにおいて、漢字混じりの文字列が入力されている列を並べ替えのキーに指定する場合、ふりがなを使用するかどうか選択して、並べ替えを行うことができる？できない？"]
[]
[null,null,"①","できる",null,"②","できない",null,null,null,null,null,null,null,null,"解答","①"]
[]
[null,"5","列幅が狭く、計算結果を表示する桁数が足りない場合、セルには（　　　）のように表示される。"]
[]
[null,null,"①","&&&&&",null,"②","#####",null,"③","*****",null,"④",{"$error":"#REF!"},null,null,"解答","②"]
[]
[null,"6","図形を描画するとき、（　　　）キーを押しながらドラッグすると、セルの枠線に位置を合わせて描画することができる。"]
[]
[null,null,"①","Esc",null,"②","Ctrl",null,"③","Shift",null,"④","Alt",null,null,"解答","④"]
[]
[null,"7","数値「2024」が入力されているセルを選択し、［ホーム］タブの［数値の値の書式］ボックスから［会計］をクリックすると、(　　　)のように表示される。"]
[]
[null,null,"①","2,024",null,"②","￥2,024",null,"③","\\   2,024 ",null,"④","２千円",null,null,"解答","③"]
[]
[null,"8","セルA1に文字列「数学期末テスト結果」が入力されているとき、数式「＝RIGHT（A1,4）」の結果は、(　　　）である。"]
[]
[null,null,"①","スト結果",null,"②","数学期末",null,"③","数学期末テ",null,"④","テスト結果",null,null,"解答","①"]
[]
[null,"9","(　　　)キーを押すと、実行中のマクロを途中で中止することができる。"]
[]
[null,null,"①","Esc",null,"②","Ctrl",null,"③","Shift",null,"④","Alt",null,null,"解答","①"]
[]
[null,"10","セルA6に数式「＝SUM(A1：A5）が入力されているとき、（　　　）と、数式が入力されているセルに「＃REF！」とエラー値が表示される。"]
[]
[null,null,"①","セルA1からA5に「０」を入力する",null,null,null,null,"②","セルA1からA5を空白にする",null,null,null,null,null,"解答","③"]
[]
[null,null,"③","行1から行5を削除する。",null,null,null,null,"④","列Aを削除する。"]