{"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":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,9,4,10],[2,9,2,10]]}
[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,"【ルール】方法は問わないが、VBAのコード記述を含めて所要時間とする。"]
[null,"問題","下表の「空白セル」をマクロ（VBA）で「定休日」に変更せよ"]
[]
[null,null,"日付","曜日","新宿店","渋谷店","銀座店","池袋店","吉祥寺店",null,"定休日"]
[null,null,"2020-12-01",{"$f":"TEXT(C11,\"aaa\")","v":"火"},860,null,900,1100,980]
[null,null,"2020-12-02",{"$f":"TEXT(C12,\"aaa\")","v":"水"},null,1050,1150,1200,1080]
[null,null,"2020-12-03","木",1000,900,950,1050,980]
[null,null,"2020-12-04","金",1100,1000,1150,1210,1190]
[null,null,"2020-12-05","土",950,1200,860,900,920]
[null,null,"2020-12-06","日",850,800,1000,1100]
[null,null,"2020-12-07","月",920,950,980,null,1020]
[null,null,"2020-12-08","火",1250,null,1100,1000,1000]
[null,null,"2020-12-09","水",null,980,1200,950,1030]
[null,null,"2020-12-10","木",1200,1000,1020,900,950]
[null,null,"2020-12-11","金",1100,1190,1300,1050,900]
[null,null,"2020-12-12","土",1000,1200,1480,1100,1150]
[null,null,"2020-12-13","日",980,850,null,1080]
[null,null,"2020-12-14","月",950,880,980,null,1000]
[null,null,"2020-12-15","火",860,null,900,1100,980]
[null,null,"2020-12-16","水",null,1050,1150,1200,1080]
[null,null,"2020-12-17","木",1000,900,950,1050,980]
[null,null,"2020-12-18","金",1100,1000,1150,1210,1190]
[null,null,"2020-12-19","土",950,1200,860,900,920]
[null,null,"2020-12-20","日",850,800,1000,1100]
[null,null,"2020-12-21","月",920,950,980,null,1020]
[null,null,"2020-12-22","火",1250,null,1100,1000,1000]
[null,null,"2020-12-23","水",null,980,1200,950,1030]
[null,null,"2020-12-24","木",1200,1000,1020,900,950]
[null,null,"2020-12-25","金",1100,1190,1300,1050,900]
[null,null,"2020-12-26","土",1000,1200,1480,1100,1150]
[null,null,"2020-12-27","日",980,850,null,1080]
[null,null,"2020-12-28","月",950,880,980,null,1000]
[null,null,"2020-12-29","火",860,null,900,1100,980]
[null,null,"2020-12-30","水",null,1050,1150,1200,1080]
[null,null,"2020-12-31","木",1000,900,950,1050,980]