{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["quiz71","quiz72"],"not_rendered":{"charts":0,"images":0,"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":"quiz71","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,7]]}
["数学，英語，理科，社会の4教科の合計をF列に計算しなさい．また，合計が320点以上であれば「A」，280点以上320点未満であれば「B」，240点以上280点未満であれば「C」，240点未満であれば「D」とG列に表示させなさい．この処理を，判定をIF文とSELECT文でおこなうプロシジャーを作成しなさい．"]
[]
[]
["No","数学","英語","理科","社会","合計","判定"]
[1,84,78,90,73,325,"A"]
[2,90,84,77,59,310,"B"]
[3,42,49,60,58,209,"D"]
[4,73,59,80,76,288,"B"]
[5,86,94,80,73,333,"A"]
[6,26,45,59,38,168,"D"]
[7,60,70,64,83,277,"C"]
[8,82,70,72,69,293,"B"]
[9,54,69,49,71,243,"C"]
[10,69,85,76,63,293,"B"]
[11,35,20,47,28,130,"D"]
[12,75,82,83,85,325,"A"]

{"sheet":"quiz72","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,7]]}
["数学，英語，理科，社会の4教科の合計をF列に計算しなさい．また，合計が320点以上であれば「A」，280点以上320点未満であれば「B」，240点以上280点未満であれば「C」，240点未満であれば「D」とG列に表示させなさい．この処理を，判定をIF文でおこなうプロシジャーを作成しなさい．"]
[]
[]
["No","数学","英語","理科","社会","合計","判定"]
[1,84,78,90,73,325,"A"]
[2,90,84,77,59,310,"B"]
[3,42,49,60,58,209,"D"]
[4,73,59,80,76,288,"B"]
[5,86,94,80,73,333,"A"]
[6,26,45,59,38,168,"D"]
[7,60,70,64,83,277,"C"]
[8,82,70,72,69,293,"B"]
[9,54,69,49,71,243,"C"]
[10,69,85,76,63,293,"B"]
[11,35,20,47,28,130,"D"]
[12,75,82,83,85,325,"A"]