{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Q"],"not_rendered":{"charts":0,"images":2,"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":"Q","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,9,4,10],[2,9,2,10],[11,2,11,3],[12,2,12,3],[16,2,16,3],[14,2,14,3],[11,4,11,5],[12,4,12,5],[16,4,16,5],[14,4,14,5],[9,2,9,3],[9,4,9,5],[15,2,15,3],[15,4,15,5],[18,2,18,3],[17,2,17,3],[17,4,17,5],[18,4,18,5],[11,0,19,0],[13,2,13,3],[13,4,13,5],[11,8,11,10],[16,8,16,10],[19,2,19,3],[19,4,19,5]]}
[null,"アビバからの挑戦状"]
[null,"問題タイプ：スピードエクセル★★"]
[null,null,null,null,null,null,null,null,null,"所要時間"]
[null,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"2020-11-13T13:36:16"]
[]
[null,null,"【ルール】方法は問わない。不正解の場合終了にはならない。"]
[null,"問題","下表の粗利試算で、粗利が１億を超えるのは「販売個数」何個以上のとき？(制限時間30秒)　※数式は入っています。"]
[]
[null,null,"回答：販売個数"]
[]
[null,null,"販売個数",null,52000,null,null,null,"販売個数別 お客様還元率"]
[null,null,"単価",null,1980,null,null,null,0,"～49,999",0]
[null,null,"お客様還元率",null,{"$f":"IFERROR(VLOOKUP($E$12,$I$13:$K$15,3,1),0)","v":0.03},null,null,null,50000,"～99,999",0.03]
[null,null,"お客様還元額",null,{"$f":"-(E12*E13*E14)","v":-3088800},null,null,null,100000,"～",0.05]
[null,null,"売上",null,{"$f":"(E12*E13)+E15","v":99871200}]
[null,null,null,null,null,null,null,null,"販売個数別 原価単価"]
[null,null,"原価 単価",null,{"$f":"IFERROR(VLOOKUP($E$12,$I$18:$K$20,3,1),0)","v":575},null,null,null,0,"～49,999",600]
[null,null,"原価",null,{"$f":"E12*E18","v":29900000},null,null,null,40000,"～79,999",575]
[null,null,"粗利",null,{"$f":"E16-E19","v":69971200},null,null,null,80000,"～",550]