{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["기본-빈칸","기본-정답","기출-문제","기출-정답"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,5],[9,2,9,4]]}
[null,null,"과일 판매 현황"]
[null,"번호","품명","수량","단가","금액"]
[null,1,"모니터",10,50,{"$f":"D3*E3","v":500}]
[null,2,"키보드",20,100,2000]
[null,3,"마우스",30,200,6000]
[null,4,"모니터",10,200,2000]
[null,5,"키보드",20,250,5000]
[null,6,"마우스",10,400,4000]
[]
[null,null,"품목별 금액의 평균"]
[null,null,"품명","품명","품명"]
[null,null,"모니터","키보드","마우스"]

{"sheet":"기본-정답","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,5],[9,2,9,4]]}
[null,null,"과일 판매 현황"]
[null,"번호","품명","수량","단가","금액"]
[null,1,"모니터",10,50,{"$f":"D3*E3","v":500}]
[null,2,"키보드",20,100,2000]
[null,3,"마우스",30,200,6000]
[null,4,"모니터",10,200,2000]
[null,5,"키보드",20,250,5000]
[null,6,"마우스",10,400,4000]
[]
[null,null,"품목별 금액의 평균"]
[null,null,"품명","품명","품명"]
[null,null,"모니터","키보드","마우스"]
[null,null,{"$f":"DAVERAGE(B2:F8,5,C11:C12)","v":1250},{"$f":"DAVERAGE(B2:F8,5,D11:D12)","v":3500},{"$f":"DAVERAGE(B2:F8,5,E11:E12)","v":5000}]

{"sheet":"기출-문제","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"성별","구매실적\n합계평균"]
[null,"남"]
[]
[null,"이름","성별","구매실적합계"]
[null,"이미옥","여",14250]
[null,"이도현","여",15200]
[null,"박정진","남",18950]
[null,"정현석","남",340000]
[null,"김태정","남",546420]
[null,"황선철","여",336250]

{"sheet":"기출-정답","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"성별","구매실적\n합계평균"]
[null,"남",{"$f":"DAVERAGE(B4:D10,3,B1:B2)","v":301790}]
[]
[null,"이름","성별","구매실적합계"]
[null,"이미옥","여",14250]
[null,"이도현","여",15200]
[null,"박정진","남",18950]
[null,"정현석","남",340000]
[null,"김태정","남",546420]
[null,"황선철","여",336250]