{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["解説","課題","課題２","課題３","課題４","課題５","解答","解答２","解答３","解答４","解答５"],"not_rendered":{"charts":0,"images":10,"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":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[27,8,27,9],[17,1,17,3],[17,7,17,9],[26,8,26,9],[2,4,2,8],[3,4,3,8],[16,1,16,5],[1,1,1,5],[10,3,14,3],[32,1,32,2],[44,1,44,6],[42,1,43,6],[36,2,37,6],[38,2,38,6],[39,2,39,6],[32,5,33,5],[32,4,33,4],[36,1,37,1]]}
[]
[null,"関数の使い方見本  (CS三級レベル)"]
[null,"品名","売上","順位","白地の部分を変更してみてください。"]
[null,"A商品",2500,{"$f":"RANK(C4,$C$4:$C$10,0)","v":6},"緑の部分に式が入っています。"]
[null,"B商品",15000,3]
[null,"C商品",2000,7]
[null,"D商品",16000,2]
[null,"E商品",9800,4]
[null,"F商品",7500,5]
[null,"G商品",80000,1]
[null,"合計",{"$f":"SUM(C4:C10)","v":132800}]
[null,"平均",{"$f":"AVERAGE(C4:C10)","v":18971.428571428572}]
[null,"最高",{"$f":"MAX(C4:C10)","v":80000}]
[null,"最低",{"$f":"MIN(C4:C10)","v":2000}]
[null,"種類数",{"$f":"COUNT(C4:C10)","v":7}]
[]
[null,"関数の使い方見本  (CS二級レベル)"]
[null,"売上結果",null,null,"掛率",0.75,null,"商品データ"]
[null,"品名","価格","売価","仕入価","利益",null,"品名","価格","仕入価"]
[null,"A-10515C",{"$f":"VLOOKUP(B20,$H$20:$J$24,2,FALSE)","v":18000},{"$f":"ROUNDUP($F$18*C20,-3)-200","v":13800},{"$f":"VLOOKUP(B20,$H$20:$J$24,3,FALSE)","v":12500},{"$f":"D20-E20","v":1300},null,"A-10515C",18000,12500]
[null,"E-A15B24",72500,54800,50000,4800,null,"D-30780A",64800,45000]
[null,"A-10523C",98000,73800,41000,32800,null,"E-A15B24",72500,50000]
[null,"E-A15B24",72500,54800,50000,4800,null,"A-10523C",98000,41000]
[null,"D-30780A",64800,48800,45000,3800,null,"E-A15C16",9800,7100]
[null,"D-30780A",64800,48800,45000,3800]
[null,"D-30780A",64800,48800,45000,3800]
[null,"A-10523C",98000,73800,41000,32800,null,"最大利益品",{"$f":"INDEX(B20:B29,MATCH(MAX(F20:F29),F20:F29,FALSE))","v":"A-10523C"}]
[null,"D-30780A",64800,48800,45000,3800,null,"最小利益品",{"$f":"INDEX(B20:B29,MATCH(MIN(F20:F29),F20:F29,FALSE))","v":"E-A15C16"}]
[null,"E-A15C16",9800,7800,7100,700]
[null,"合　計",{"$f":"SUM(C20:C29)","v":628000},{"$f":"SUM(D20:D29)","v":474000},{"$f":"SUM(E20:E29)","v":381600},{"$f":"SUM(F20:F29)","v":92400}]
[]
[]
[null,"実務レベル",null,null,"コード",1,null,null,null,"コード","名前","住所","電話番号","ランク","担当","販売額","請求額","購入日",null,"ランク","値引率"]
[null,null,null,null,null,null,null,null,null,1,"近井 瑪瑙","東京都目黒区","090-1111-2222","A","１課",5200,{"$f":"ROUNDUP(P34*(1-VLOOKUP(N34,$T$34:$U$37,2,FALSE)),-2)","v":5100},"2008-01-15",null,"S",0.05]
[null,null,null,null,null,null,null,null,null,2,"目地 潔","東京都品川区","080-1234-5678","S","２課",103300,98200,"2008-01-16",null,"A",0.03]
[null,null,null,null,null,null,null,null,null,3,"塁川 鈴女","千葉県千葉市","090-3131-2121","B","３課",21100,20900,"2008-01-17",null,"B",0.01]
[null,"ご芳名",{"$f":"INDEX($J$34:$R$53,$F$33,2)&\"　様\"","v":"近井 瑪瑙　様"},null,null,null,null,null,null,4,"節川 桜子","東京都東村山市","070-5678-8765","A","３課",69700,67700,"2008-01-17",null,"C",0]
[null,null,null,null,null,null,null,null,null,5,"岸川 森羅","大阪府大阪市","090-0011-9977","A","２課",66500,64600,"2008-01-18"]
[null,"ご 住 所",{"$f":"INDEX($J$34:$R$53,$F$33,3)","v":"東京都目黒区"},null,null,null,null,null,null,6,"猫山 狗雄","東京都葛飾区","110-623-4318","B","３課",81800,81000,"2008-01-18"]
[null,"ご連絡先",{"$f":"INDEX($J$34:$R$53,$F$33,4)","v":"090-1111-2222"},null,null,null,null,null,null,7,"井山 毬藻","埼玉県所沢市","090-4444-5555","C","１課",68500,68500,"2008-01-19"]
[null,null,null,null,null,null,null,null,null,8,"椎名 涅槃","東京都太田区","090-9852-1675","A","１課",82800,80400,"2008-01-19"]
[null,"今回の請求額",null,null,null,null,null,null,null,9,"比地 鱒雄","千葉県流山市","070-4532-9513","B","２課",9000,9000,"2008-01-20"]
[null,{"$f":"\"金 \"&TEXT(INDEX($J$34:$R$53,$F$33,8),\"[DBNum2][$-411]G/標準\")&\" 円也\"","v":"金 伍阡壱百 円也"},null,null,null,null,null,null,null,10,"杉菜 土筆","茨城県つくば市","0120-15-2764","A","１課",62200,60400,"2008-01-21"]
[null,null,null,null,null,null,null,null,null,11,"鶴多 朱鷺","千葉県柏市","110-119-4567","B","３課",33400,33100,"2008-01-22"]
[null,{"$f":"\"ＡＢＣ商事　担当課　\"&INDEX($J$34:$O$53,$F$33,6)","v":"ＡＢＣ商事　担当課　１課"},null,null,null,null,null,null,null,12,"袈裟地 燕","神奈川県鎌倉市","090-7351-9435","B","１課",49100,48700,"2008-01-23"]
[null,null,null,null,null,null,null,null,null,13,"藤山 深雪","東京都板橋区","080-3517-6482","C","２課",52500,52500,"2008-01-24"]
[null,null,null,null,null,null,null,null,null,14,"仁和 海豚","千葉県千葉市","0120-45-6250","B","３課",64400,63800,"2008-01-24"]
[null,null,null,null,null,null,null,null,null,15,"雪山 清美","東京都新宿区","070-5462-8451","A","１課",5200,5100,"2008-01-25"]
[null,null,null,null,null,null,null,null,null,16,"立冬 霜月","茨城県土浦市","090-4682-1564","B","２課",64300,63700,"2008-01-26"]
[null,null,null,null,null,null,null,null,null,17,"冬至 蜜柑","神奈川県逗子市","119-456-2543","S","１課",77000,73200,"2008-01-27"]
[null,null,null,null,null,null,null,null,null,18,"沓崎 睦月","埼玉県さいたま市","090-0034-2651","C","２課",20500,20500,"2008-01-28"]
[null,null,null,null,null,null,null,null,null,19,"牛山 弥生","東京都練馬区","080-1245-7896","A","３課",54700,53100,"2008-01-29"]
[null,null,null,null,null,null,null,null,null,20,"鉄火 真紀","神奈川県厚木市","0120-58-1567","B","３課",64700,64100,"2008-01-29"]

{"sheet":"課題","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["下図のとおりの表を作成しなさい。"]
["条件"]
["・15行の行高は35、16-34行は行高12"]
["・A列の幅は2、B列の幅は3、C:L列の幅は自動とする"]
["・タイトルは24P、MS明朝体、文字色は白、セル背景は黒、B:Lを結合し中寄せ、枠線は太線の黒"]
["・B16:L35の文字サイズは１０ポイント"]
["・B16:L34の罫線は外枠を太線にする"]
["・グループ名は縦書きで上下左右に中央揃え"]
["・セル装飾は図のとおりとする"]
["・小計行の合計や平均は各グループでの合計や平均を表示させて下さい。"]
["・順位は合計値で決定してください。"]
["・データの不足部は全て式で補うこと。"]
["・「今日の日付」は閲覧時の日付が自動的に表示されること。"]
[]
[null,null,"本日の営業成績"]
[null,null,"氏名","商品A","商品B","商品C","商品D","合計","平均","最高","最低","順位"]
[null,"グループA","近井 瑪瑙",73000,61000,76000,81000]
[null,null,"目地 潔",43000,105000,43000,50000]
[null,null,"塁川 鈴女",72000,119000,76000,90000]
[null,null,"節川 桜子",94000,118000,123000,78000]
[null,null,"岸川 森羅",128000,82000,51000,53000]
[null,null,"猫山 狗雄",127000,39000,59000,118000]
[null,null,"小　計"]
[null,"グループB","井山 毬藻",102000,111000,98000,74000]
[null,null,"椎名 涅槃",121000,104000,64000,118000]
[null,null,"比地 鱒雄",65000,123000,37000,80000]
[null,null,"杉菜 土筆",84000,39000,107000,89000]
[null,null,"鶴多 朱鷺",40000,126000,46000,55000]
[null,null,"袈裟地 燕",73000,101000,125000,63000]
[null,null,"小　計"]
[null,"合計"]
[null,"平均"]
[null,"最高"]
[null,"最低"]
[null,null,null,null,null,null,null,"今日の日付："]

{"sheet":"課題２","index":2,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["下図のとおりの表を作成しなさい。"]
["条件"]
["・15-32行の行高は15、タイトル行は30"]
["・タイトルはMS明朝の24P、文字色は白、セルはB:Oを結合しセンタリング、セル色は緑、枠は黒い太線とします。"]
["・タイトル以外の文字サイズは10.5ポイント"]
["・Ａ列の幅は２、Ｂ列とO列の幅は8.5、C:N列の幅は6とする。"]
["・順位は最高タイムで競います。"]
["・当然ながら、早い方が最高タイムです。"]
["・ブービーはビリから２番目のことです。"]
["・表彰者のデータは１８－２９行のセルを参照してください。"]
["・表彰者の名前欄は判らなければ無回答でもかまいません。"]
[]
[]
[null,"レース結果"]
[]
[null,"氏名","タイム",null,null,null,null,"結果",null,null,null,null,"表彰者"]
[null,null,"1回目","2回目","3回目","4回目","5回目","最高","平均","走行数","順位",null,"順位","タイム","名前"]
[null,"藤山 深雪",10.72,11.19,11.39,11.65,11.39,null,null,null,null,null,"優勝"]
[null,"仁和 海豚",11.21,11.05,null,null,11.53,null,null,null,null,null,"準優勝"]
[null,"雪山 清美",9.9,9.31,9.31,9.15,10.56,null,null,null,null,null,"３位"]
[null,"立冬 霜月",11.72,11.47,11.7,null,12.37,null,null,null,null,null,"ブービー"]
[null,"冬至 蜜柑",11.24,11.16,10.52,10.19,10.67]
[null,"沓崎 睦月",10.210000000000001,9.23,9.08,10.49,9.89,null,null,null,null,null,"日付："]
[null,"牛山 弥生",9.35,10.09,10.95,10.84,9.49]
[null,"鉄火 真紀",11.01,11.81,11.94,11.94,10.71]
[null,"烈川 怒涛",null,12.39,11.25,12.94]
[null,"夏至 孔雀",11.05,10.38,11.33,11.68,11.55]
[null,"沼地 鯉蔵",10.27,null,11.53,11.11,11.01]
[null,"醍醐 ミカ",10.65,10.93,10.99,11.58]
[null,"最高"]
[null,"平均"]
[null,"走行数"]

{"sheet":"課題３","index":3,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15行の行高は30、16-30行は行高12"]
["・A列の幅は2、B:C列の幅は4、D:KとM:N列の幅は5、L列は８とする"]
["・タイトルは24P、MSゴシック体、文字色は青で太文字、インデント５の均等割付"]
["・タイトルのセルはB:Nを結合し、背景は縦横メッシュの黄色い網掛け、枠線は太線の黒"]
["・タイトル以外の文字サイズは１０ポイント"]
["・他のセル装飾は図のとおりとする"]
["・一日目と二日目の評価は時間が８時間未満の場合に「×」が表示されるようにしてください。"]
["・総合の評価は一日目と二日目の評価のどちらかに×が有れば「(-_-#)」が表示されるようにしてください。"]
["・総合の氏名欄は苗字と名前の間に半角スペースを入れること。"]
["・データの不足部は白地の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[null,"活動参加時間"]
[null,"参加者",null,"一日目",null,null,null,"二日目",null,null,null,"２日間総合"]
[null,"姓","名","開始","終了","時間","評価","開始","終了","時間","評価","氏名","時間","評価"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"平均時間",null,null,null,"平均時間",null,null,null,"平均"]

{"sheet":"課題４","index":4,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15-31行の行高は自動とする"]
["・A列の幅は2、B列の幅は８、C:S列の幅は3.5、T:W列は自動調整とする"]
["・C19:S19は縦書きとする"]
["・B15:W31のフォントは10Pとする"]
["・B15:F17、G15:G17、H15:J16、H17:J17、K15:V15、K16:V16、K17:V17、T30:T31、U30:V30、U31:V31をそれぞれセル結合しなさい"]
["・他のセル装飾は図のとおりとする"]
["・来期待遇、成否、可否は「基準」に従い、W列を参照して式を作ってください。"]
["・データの不足部はB19:S29の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[]
[]
[null,"今期の採択状況です。\n欠席の多い委員は解任\nさせていただきます。",null,null,null,null,"基準","採択基準",null,null,"投票成立は、投票率が右の比率を超えていること。",null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,"可決は出席委員の賛成が右の値を超えていること",null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,"来期待遇",null,null,"出席率がが右の値を超えていなければ「解任」",null,null,null,null,null,null,null,null,null,null,null,0.5]
[]
[null," 　　委員名\n\n項目","村多","近井","目地","塁川","節川","岸川","猫山","井山","椎名","比地","杉菜","鶴多","袈裟地","三輪","藤山","仁和","雪山","投票率","成否","賛成数","可否"]
[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,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,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,"出席率"]
[null,"来期待遇"]

{"sheet":"課題５","index":5,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15-32行の行高は13とする"]
["・A列の幅は2、B:C列の幅は4、D:N列の幅は5とする"]
["・タイトル以外のB15:N32のフォントは10Pとする"]
["・タイトルのセルは背景を紫、フォントをMSP明朝の20P、白、太文字とする"]
["・他のセル装飾は図のとおりとする"]
["・平均は関数を用いて小数点以下第１位に四捨五入すること"]
["・判定は判定基準の値未満の場合に「◆」と表示し、総合は判定に１個でも◆が有れば「◆」が表示されるようにすること"]
["・順位は合計得点で決定すること"]
["・データの不足部は白地の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[]
[null,"Excel 試験結果",null,null,null,null,null,null,null,"判定","学科１","学科２","実技１","実技２"]
[null,null,null,null,null,null,null,null,null,"基準",80,60,60,75]
[]
[null,"姓","名","得点",null,null,null,null,"判定"]
[null,null,null,"学科１","学科２","実技１","実技２","合計","学科１","学科２","実技１","実技２","総合","順位"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"平均"]

{"sheet":"解答","index":6,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,8,34,11],[14,1,14,11],[16,1,22,1],[23,1,29,1],[29,11,33,11],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
["下図のとおりの表を作成しなさい。"]
["条件"]
["・15行の行高は35、16-34行は行高12"]
["・A列の幅は2、B列の幅は3、C:L列の幅は自動とする"]
["・タイトルは24P、MS明朝体、文字色は白、セル背景は黒、B:Lを結合し中寄せ、枠線は太線の黒"]
["・B16:L35の文字サイズは１０ポイント"]
["・B16:L34の罫線は外枠を太線にする"]
["・グループ名は縦書きで上下左右に中央揃え"]
["・セル装飾は図のとおりとする"]
["・小計行の合計や平均は各グループでの合計や平均を表示させて下さい。"]
["・順位は合計値で決定してください。"]
["・データの不足部は全て式で補うこと。"]
["・「今日の日付」は閲覧時の日付が自動的に表示されること。"]
[]
[null,"本日の営業成績"]
[null,null,"氏名","商品A","商品B","商品C","商品D","合計","平均","最高","最低","順位"]
[null,"グループA","近井 瑪瑙",73000,61000,76000,81000,{"$f":"SUM(D17:G17)","v":291000},{"$f":"AVERAGE(D17:G17)","v":72750},{"$f":"MAX(D17:G17)","v":81000},{"$f":"MIN(D17:G17)","v":61000},{"$f":"RANK(H17,($H$17:$H$22,$H$24:$H$29),0)","v":10}]
[null,null,"目地 潔",43000,105000,43000,50000,241000,60250,105000,43000,{"$f":"RANK(H18,($H$17:$H$22,$H$24:$H$29),0)","v":12}]
[null,null,"塁川 鈴女",72000,119000,76000,90000,357000,89250,119000,72000,{"$f":"RANK(H19,($H$17:$H$22,$H$24:$H$29),0)","v":5}]
[null,null,"節川 桜子",94000,118000,123000,78000,413000,103250,123000,78000,{"$f":"RANK(H20,($H$17:$H$22,$H$24:$H$29),0)","v":1}]
[null,null,"岸川 森羅",128000,82000,51000,53000,314000,78500,128000,51000,{"$f":"RANK(H21,($H$17:$H$22,$H$24:$H$29),0)","v":8}]
[null,null,"猫山 狗雄",127000,39000,59000,118000,343000,85750,127000,39000,{"$f":"RANK(H22,($H$17:$H$22,$H$24:$H$29),0)","v":6}]
[null,null,"小　計",{"$f":"SUM(D17:D22)","v":537000},{"$f":"SUM(E17:E22)","v":524000},{"$f":"SUM(F17:F22)","v":428000},{"$f":"SUM(G17:G22)","v":470000},{"$f":"SUM(H17:H22)","v":1959000},{"$f":"AVERAGE(I17:I22)","v":81625},{"$f":"MAX(J17:J22)","v":128000},{"$f":"MIN(K17:K22)","v":39000}]
[null,"グループB","井山 毬藻",102000,111000,98000,74000,{"$f":"SUM(D24:G24)","v":385000},{"$f":"AVERAGE(D24:G24)","v":96250},{"$f":"MAX(D24:G24)","v":111000},{"$f":"MIN(D24:G24)","v":74000},{"$f":"RANK(H24,($H$17:$H$22,$H$24:$H$29),0)","v":3}]
[null,null,"椎名 涅槃",121000,104000,64000,118000,407000,101750,121000,64000,{"$f":"RANK(H25,($H$17:$H$22,$H$24:$H$29),0)","v":2}]
[null,null,"比地 鱒雄",65000,123000,37000,80000,305000,76250,123000,37000,{"$f":"RANK(H26,($H$17:$H$22,$H$24:$H$29),0)","v":9}]
[null,null,"杉菜 土筆",84000,39000,107000,89000,319000,79750,107000,39000,{"$f":"RANK(H27,($H$17:$H$22,$H$24:$H$29),0)","v":7}]
[null,null,"鶴多 朱鷺",40000,126000,46000,55000,267000,66750,126000,40000,{"$f":"RANK(H28,($H$17:$H$22,$H$24:$H$29),0)","v":11}]
[null,null,"袈裟地 燕",73000,101000,125000,63000,362000,90500,125000,63000,{"$f":"RANK(H29,($H$17:$H$22,$H$24:$H$29),0)","v":4}]
[null,null,"小　計",{"$f":"SUM(D24:D29)","v":485000},{"$f":"SUM(E24:E29)","v":604000},{"$f":"SUM(F24:F29)","v":477000},{"$f":"SUM(G24:G29)","v":479000},{"$f":"SUM(H24:H29)","v":2045000},{"$f":"AVERAGE(I24:I29)","v":85208.333333333328},{"$f":"MAX(J24:J29)","v":126000},{"$f":"MIN(K24:K29)","v":37000}]
[null,"合計",null,{"$f":"SUM(D17:D22,D24:D29)","v":1022000},{"$f":"SUM(E17:E22,E24:E29)","v":1128000},905000,949000,4004000,1001000,1396000,661000]
[null,"平均",null,{"$f":"AVERAGE(D17:D22,D24:D29)","v":85166.666666666672},94000,75416.666666666672,79083.333333333328,333666.66666666669,83416.666666666672,116333.33333333333,55083.333333333336]
[null,"最高",null,{"$f":"MAX(D17:D22,D24:D29)","v":128000},126000,125000,118000,413000,103250,128000,78000]
[null,"最低",null,{"$f":"MIN(D17:D22,D24:D29)","v":40000},{"$f":"MIN(E17:E22,E24:E29)","v":39000},37000,50000,241000,60250,81000,37000]
[null,null,null,null,null,null,null,"今日の日付：",{"$f":"TODAY()","v":"2017-02-03"}]

{"sheet":"解答２","index":7,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,7,31,10],[13,1,13,14],[15,1,16,1],[15,2,15,6],[15,7,15,10],[15,12,15,14],[22,13,22,14]]}
["下図のとおりの表を作成しなさい。"]
["条件"]
["・15-32行の行高は15、タイトル行は30"]
["・タイトルはMS明朝の24P、文字色は白、セルはB:Oを結合しセンタリング、セル色は緑、枠は黒い太線とします。"]
["・タイトル以外の文字サイズは10.5ポイント"]
["・Ａ列の幅は２、Ｂ列とO列の幅は8.5、C:N列の幅は6とする。"]
["・順位は最高タイムで競います。"]
["・当然ながら、早い方が最高タイムです。"]
["・ブービーはビリから２番目のことです。"]
["・表彰者のデータは１８－２９行のセルを参照してください。"]
["・表彰者の名前欄は判らなければ無回答でもかまいません。"]
["・「日付」は閲覧時の日付が自動的に表示されること。"]
[]
[null,"レース結果"]
[]
[null,"氏名","タイム",null,null,null,null,"結果",null,null,null,null,"表彰者"]
[null,null,"1回目","2回目","3回目","4回目","5回目","最高","平均","走行数","順位",null,"順位","タイム","名前"]
[null,"藤山 深雪",10.72,11.19,11.39,11.65,11.39,{"$f":"MIN(C18:G18)","v":10.72},{"$f":"AVERAGE(C18:G18)","v":11.267999999999999},{"$f":"COUNT(C18:G18)","v":5},{"$f":"RANK(H18,$H$18:$H$29,1)","v":9},null,"優勝",{"$f":"MIN(H18:H29)","v":9.08},{"$f":"INDEX($B$18:$B$29,MATCH(N18,$H$18:$H$29,FALSE))","v":"沓崎 睦月"}]
[null,"仁和 海豚",11.21,11.05,null,null,11.53,{"$f":"MIN(C19:G19)","v":11.05},{"$f":"AVERAGE(C19:G19)","v":11.263333333333334},{"$f":"COUNT(C19:G19)","v":3},{"$f":"RANK(H19,$H$18:$H$29,1)","v":10},null,"準優勝",{"$f":"SMALL(H18:H29,2)","v":9.15},{"$f":"INDEX($B$18:$B$29,MATCH(N19,$H$18:$H$29,FALSE))","v":"雪山 清美"}]
[null,"雪山 清美",9.9,9.31,9.31,9.15,10.56,9.15,9.6460000000000008,5,2,null,"３位",{"$f":"SMALL(H18:H29,3)","v":9.35},{"$f":"INDEX($B$18:$B$29,MATCH(N20,$H$18:$H$29,FALSE))","v":"牛山 弥生"}]
[null,"立冬 霜月",11.72,11.47,11.7,null,12.37,11.47,11.815,4,12,null,"ブービー",{"$f":"LARGE(H18:H29,2)","v":11.25},{"$f":"INDEX($B$18:$B$29,MATCH(N21,$H$18:$H$29,FALSE))","v":"烈川 怒涛"}]
[null,"冬至 蜜柑",11.24,11.16,10.52,10.19,10.67,10.19,10.756,5,4]
[null,"沓崎 睦月",10.210000000000001,9.23,9.08,10.49,9.89,9.08,9.7800000000000011,5,1,null,"日付：",{"$f":"TODAY()","v":"2017-02-03"}]
[null,"牛山 弥生",9.35,10.09,10.95,10.84,9.49,9.35,10.144,5,3]
[null,"鉄火 真紀",11.01,11.81,11.94,11.94,10.71,10.71,11.481999999999999,5,8]
[null,"烈川 怒涛",null,12.39,11.25,12.94,null,11.25,12.193333333333333,3,11]
[null,"夏至 孔雀",11.05,10.38,11.33,11.68,11.55,10.38,11.197999999999999,5,6]
[null,"沼地 鯉蔵",10.27,null,11.53,11.11,11.01,10.27,10.979999999999999,4,5]
[null,"醍醐 ミカ",10.65,10.93,10.99,11.58,null,10.65,11.0375,4,7]
[null,"最高",{"$f":"MIN(C18:C29)","v":9.35},{"$f":"MIN(D18:D29)","v":9.23},{"$f":"MIN(E18:E29)","v":9.08},{"$f":"MIN(F18:F29)","v":9.15},{"$f":"MIN(G18:G29)","v":9.49}]
[null,"平均",{"$f":"AVERAGE(C18:C29)","v":10.666363636363636},{"$f":"AVERAGE(D18:D29)","v":10.81909090909091},{"$f":"AVERAGE(E18:E29)","v":10.908181818181818},{"$f":"AVERAGE(F18:F29)","v":11.157},{"$f":"AVERAGE(G18:G29)","v":10.916999999999998}]
[null,"走行数",{"$f":"COUNT(C18:C29)","v":11},{"$f":"COUNT(D18:D29)","v":11},{"$f":"COUNT(E18:E29)","v":11},{"$f":"COUNT(F18:F29)","v":10},{"$f":"COUNT(G18:G29)","v":10}]

{"sheet":"解答３","index":8,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,1,14,13],[15,1,15,2],[15,3,15,6],[15,7,15,10],[15,11,15,13],[29,1,29,2],[29,3,29,4],[29,7,29,8]]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15行の行高は30、16-30行は行高12"]
["・A列の幅は2、B:C列の幅は4、D:KとM:N列の幅は5、L列は８とする"]
["・タイトルは24P、MSゴシック体、文字色は青で太文字、インデント５の均等割付"]
["・タイトルのセルはB:Nを結合し、背景は縦横メッシュの黄色い網掛け、枠線は太線の黒"]
["・タイトル以外の文字サイズは１０ポイント"]
["・他のセル装飾は図のとおりとする"]
["・一日目と二日目の評価は時間が８時間未満の場合に「×」が表示されるようにしてください。"]
["・総合の評価は一日目と二日目の評価のどちらかに×が有れば「(-_-#)」が表示されるようにしてください。"]
["・総合の氏名欄は苗字と名前の間に半角スペースを入れること。"]
["・データの不足部は白地の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[null,"活動参加時間"]
[null,"参加者",null,"一日目",null,null,null,"二日目",null,null,null,"２日間総合"]
[null,"姓","名","開始","終了","時間","評価","開始","終了","時間","評価","氏名","時間","評価"]
[null,"秋野","野菊","08:26:00","16:30:00",{"$f":"E18-D18","v":"08:04:00"},{"$f":"IF(F18<1/3,\"×\",\"\")","v":""},"08:30:00","16:28:00",{"$f":"I18-H18","v":"07:58:00"},{"$f":"IF(J18<1/3,\"×\",\"\")","v":"×"},{"$f":"B18&\" \"&C18","v":"秋野 野菊"},{"$f":"SUM(F18,J18)","v":"16:02:00"},{"$f":"IF(G18&K18<>\"\",\"(-_-#)\",\"\")","v":"(-_-#)"}]
[null,"江差","俊介","08:55:00","17:01:00",{"$f":"E19-D19","v":"08:06:00"},{"$f":"IF(F19<1/3,\"×\",\"\")","v":""},"08:57:00","17:02:00",{"$f":"I19-H19","v":"08:05:00"},{"$f":"IF(J19<1/3,\"×\",\"\")","v":""},{"$f":"B19&\" \"&C19","v":"江差 俊介"},"16:11:00",{"$f":"IF(G19&K19<>\"\",\"(-_-#)\",\"\")","v":""}]
[null,"平和","千代","07:52:00","16:05:00","08:13:00","","07:55:00","16:05:00","08:10:00","","平和 千代","16:23:00",""]
[null,"村多","杜氏","08:20:00","16:31:00","08:11:00","","08:21:00","16:29:00","08:08:00","","村多 杜氏","16:19:00",""]
[null,"近井","瑪瑙","08:28:00","16:20:00","07:52:00","×","08:28:00","16:48:00","08:20:00","","近井 瑪瑙","16:12:00","(-_-#)"]
[null,"目地","潔","09:18:00","17:36:00","08:18:00","","09:18:00","17:33:00","08:15:00","","目地 潔","16:33:00",""]
[null,"塁川","鈴女","08:14:00","16:21:00","08:07:00","","08:16:00","16:20:00","08:04:00","","塁川 鈴女","16:11:00",""]
[null,"節川","桜子","08:41:00","16:46:00","08:05:00","","08:43:00","16:51:00","08:08:00","","節川 桜子","16:13:00",""]
[null,"岸川","森羅","08:10:00","16:14:00","08:04:00","","08:07:00","16:21:00","08:14:00","","岸川 森羅","16:18:00",""]
[null,"猫山","狗雄","08:11:00","16:06:00","07:55:00","×","08:02:00","16:00:00","07:58:00","×","猫山 狗雄","15:53:00","(-_-#)"]
[null,"井山","毬藻","07:54:00","16:03:00","08:09:00","","07:56:00","16:06:00","08:10:00","","井山 毬藻","16:19:00",""]
[null,"椎名","涅槃","08:25:00","16:47:00","08:22:00","","08:25:00","16:45:00","08:20:00","","椎名 涅槃","16:42:00",""]
[null,null,null,"平均時間",null,{"$f":"AVERAGE(F18:F29)","v":"08:07:10"},"","平均時間",null,{"$f":"AVERAGE(J18:J29)","v":"08:09:10"},"","平均",{"$f":"AVERAGE(M18:M29)","v":"16:16:20"},""]

{"sheet":"解答４","index":9,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,1,16,5],[14,6,16,6],[14,7,15,9],[14,10,14,21],[15,10,15,21],[16,7,16,9],[16,10,16,21]]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15-31行の行高は自動とする"]
["・A列の幅は2、B列の幅は８、C:S列の幅は3.5、T:W列は自動調整とする"]
["・C18:S18とC30:S30は縦書きとする"]
["・B15:W31のフォントは10Pとする"]
["・B15:F17、G15:G17、H15:J16、H17:J17、K15:V15、K16:V16、K17:V17、T30:T31、U30:V30、U31:V31をそれぞれセル結合しなさい"]
["・他のセル装飾は図のとおりとする"]
["・来期待遇、成否、可否は「基準」に従い、W列を参照して式を作ってください。"]
["・データの不足部はB19:S29の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[]
[]
[null,"今期の採択状況です。\n欠席の多い委員は解任\nさせていただきます。",null,null,null,null,"基準","採択基準",null,null,"投票成立は、投票率が右の比率を超えていること。",null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,"可決は出席委員の賛成が右の値を超えていること",null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,"来期待遇",null,null,"出席率がが右の値を超えていなければ「解任」",null,null,null,null,null,null,null,null,null,null,null,0.5]
[]
[null," 　　委員名\n\n項目","村多","近井","目地","塁川","節川","岸川","猫山","井山","椎名","比地","杉菜","鶴多","袈裟地","三輪","藤山","仁和","雪山","投票率","成否","賛成数","可否"]
[null,"議題１","○","×","○","×",null,"○","○","×","○","×","○","×",null,"○","×",null,"×",{"$f":"COUNTA(C20:S20)/COUNTA($C$19:$S$19)","v":0.82352941176470584},{"$f":"IF(T20>$W$15,\"成立\",\"不成立\")","v":"成立"},{"$f":"COUNTIF(C20:S20,\"○\")","v":7},{"$f":"IF(COUNTA(C20:S20)*$W$16<V20,\"可決\",\"否決\")","v":"否決"}]
[null,"議題２",null,"○","○","×","×","○","○","×","○","×","○","○","×","×","○","×","○",{"$f":"COUNTA(C21:S21)/COUNTA($C$19:$S$19)","v":0.94117647058823528},"成立",{"$f":"COUNTIF(C21:S21,\"○\")","v":9},"可決"]
[null,"議題３",null,"×","○","○",null,"×","○","×","○","×","○",null,"×","×","×","○",null,0.76470588235294112,"不成立",6,"否決"]
[null,"議題５","×","×","×","○","×","○","○","○","○","×","○",null,"×","○","○","○","×",0.94117647058823528,"成立",9,"可決"]
[null,"議題６",null,"×","×","×","×","×","×","×","×","×","○",null,"×","×","×","×","○",0.88235294117647056,"成立",2,"否決"]
[null,"議題７",null,"○","○","○",null,"○","○",null,"○",null,"○",null,"×","○","○","○","○",0.70588235294117652,"不成立",11,"可決"]
[null,"議題８",null,"○","○","○","×","○","×","×","○","×","○","×",null,"○","×",null,"×",0.82352941176470584,"成立",7,"否決"]
[null,"議題１０",null,"×","○","○",null,"×","○",null,"×","×","○",null,"×","○","×","○","×",0.76470588235294112,"不成立",6,"否決"]
[null,"議題１１","○","○","○","○",null,"○","○","○","○","×","○",null,"×","○","×","○",null,0.82352941176470584,"成立",11,"可決"]
[null,"議題１２","○","○","○","○","×","×","○","○","×","×","○","×","×","○","○",null,"○",0.94117647058823528,"成立",10,"可決"]
[null,"出席率",{"$f":"COUNTA(C20:C29)/COUNTA($B$20:$B$29)","v":0.4},{"$f":"COUNTA(D20:D29)/COUNTA($B$20:$B$29)","v":1},1,1,0.5,1,1,0.8,1,0.9,1,0.4,0.8,1,1,0.7,0.8]
[null,"来期待遇",{"$f":"IF(C30<=$W$17,\"解任\",\"\")","v":"解任"},{"$f":"IF(D30<=$W$17,\"解任\",\"\")","v":""},"","","解任","","","","","","","解任","","","","",""]

{"sheet":"解答５","index":10,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[14,1,15,7],[17,1,18,1],[17,2,18,2],[17,3,17,7],[17,8,17,13],[31,1,31,2]]}
["下図のとおりの表をB15から下に作成しなさい。"]
["条件"]
["・15-32行の行高は13とする"]
["・A列の幅は2、B:C列の幅は4、D:N列の幅は5とする"]
["・タイトル以外のB15:N32のフォントは10Pとする"]
["・タイトルのセルは背景を紫、フォントをMSP明朝の20P、白、太文字とする"]
["・他のセル装飾は図のとおりとする"]
["・平均は関数を用いて小数点以下第１位に四捨五入すること"]
["・判定は判定基準の値未満の場合に「◆」と表示し、総合は判定に１個でも◆が有れば「◆」が表示されるようにすること"]
["・順位は合計得点で決定すること"]
["・データの不足部は白地の部分は入力し、他の部分は全て式で補うこと。"]
[]
[]
[]
[null,"Excel 試験結果",null,null,null,null,null,null,null,"判定","学科１","学科２","実技１","実技２"]
[null,null,null,null,null,null,null,null,null,"基準",80,60,60,75]
[]
[null,"姓","名","得点",null,null,null,null,"判定"]
[null,null,null,"学科１","学科２","実技１","実技２","合計","学科１","学科２","実技１","実技２","総合","順位"]
[null,"藤山","深雪",97,98,91,78,{"$f":"SUM(D20:G20)","v":364},{"$f":"IF(D20<K$16,\"◆\",\"\")","v":""},"","","",{"$f":"IF(I20&J20&K20&L20<>\"\",\"◆\",\"\")","v":""},{"$f":"RANK(H20,$H$20:$H$31,0)","v":4}]
[null,"仁和","海豚",35,16,100,100,{"$f":"SUM(D21:G21)","v":251},"◆","◆","","","◆",{"$f":"RANK(H21,$H$20:$H$31,0)","v":11}]
[null,"雪山","清美",100,92,76,100,368,"","","","","",3]
[null,"立冬","霜月",81,85,99,98,363,"","","","","",5]
[null,"冬至","蜜柑",90,90,92,100,372,"","","","","",2]
[null,"沓崎","睦月",87,88,75,86,336,"","","","","",6]
[null,"牛山","弥生",100,100,99,74,373,"","","","◆","◆",1]
[null,"鉄火","真紀",76,85,95,73,329,"◆","","","◆","◆",7]
[null,"烈川","怒涛",78,55,0,94,227,"◆","◆","◆","","◆",12]
[null,"夏至","孔雀",87,64,60,77,288,"","","","","",10]
[null,"沼地","鯉蔵",83,80,79,85,327,"","","","","",8]
[null,"醍醐","ミカ",100,96,65,48,309,"","","","◆","◆",9]
[null,"平均",null,{"$f":"ROUND(AVERAGE(D20:D31),1)","v":84.5},{"$f":"ROUND(AVERAGE(E20:E31),1)","v":79.099999999999994},{"$f":"ROUND(AVERAGE(F20:F31),1)","v":77.599999999999994},{"$f":"ROUND(AVERAGE(G20:G31),1)","v":84.4},{"$f":"ROUND(AVERAGE(H20:H31),1)","v":325.60000000000002}]