{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["실습1-문제","실습1-정답","기출-문제","기출-정답","dcount함수설명"],"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":"실습1-문제","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,"No","품명","주문수량","단가","금액"]
[null,1,"모니터",20,100,{"$f":"D3*E3","v":2000}]
[null,1,"CD",40,200,8000]
[null,1,"CD",60,200,12000]
[null,2,"모니터",20,100,2000]
[null,2,"CD",40,200,8000]
[null,2,"키보드",50,300,15000]
[]
[null,null,"품목별 주문 건수"]
[null,null,"품명","품명","품명"]
[null,null,"모니터","CD","키보드"]

{"sheet":"실습1-정답","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,"No","품명","주문수량","단가","금액"]
[null,1,"모니터",20,100,{"$f":"D3*E3","v":2000}]
[null,1,"CD",40,200,8000]
[null,1,"CD",60,200,12000]
[null,2,"모니터",20,100,2000]
[null,2,"CD",40,200,8000]
[null,2,"키보드",50,300,15000]
[]
[null,null,"품목별 주문 건수"]
[null,null,"품명","품명","품명"]
[null,null,"모니터","CD","키보드"]
[null,null,{"$f":"DCOUNTA(B2:F8,2,C11:C12)","v":2},{"$f":"DCOUNTA(B2:F8,2,D11:D12)","v":3},{"$f":"DCOUNTA(B2:F8,2,E11:E12)","v":1}]

{"sheet":"기출-문제","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3]]}
[null,"중간고사보다 기말고사 성적이 향상된 사람의 수"]
[null,null,"성적향상자 수"]
[]
[]
[]
[null,"학번","수강과목","중간고사","기말고사"]
[null,"03G124","액세스",71,86]
[null,"03G204","액세스",77,63]
[null,"04L789","윈도우",83,87]
[null,"03M171","윈도우",56,81]
[null,"03M174","액세스",86,85]

{"sheet":"기출-정답","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3]]}
[null,"중간고사보다 기말고사 성적이 향상된 사람의 수"]
[null,null,"성적향상자 수"]
[null,{"$f":"E7>D7","v":true},{"$f":"DCOUNTA(B6:E11,2,B2:B3)","v":3}]
[]
[]
[null,"학번","수강과목","중간고사","기말고사"]
[null,"03G124","액세스",71,86]
[null,"03G204","액세스",77,63]
[null,"04L789","윈도우",83,87]
[null,"03M171","윈도우",56,81]
[null,"03M174","액세스",86,85]

{"sheet":"dcount함수설명","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,5,7,9]]}
["나라","대륙","조편성","득점",null,"DCOUNT함수는 숫자가 들어있는 셀의 갯수를 세어주는 함수입니다.\n\n셀에 숫자가 아닌 한글, 영어, 기호가 들어있으면 함숫값은 나타나지 않습니다.\n\n\n"]
["브","남","a"]
["스","유","a",2]
["크","유","a",44]
["네","유","b"]
["칠","남","b"]
["카","아","a"]
["콜","남","c"]
["코","아","c",1]
["호","아","b"]
["그","유","a"]
[]
[]
[null,null,null,null,null,"대륙","dcount"]
[null,null,null,null,null,"유",{"$f":"DCOUNT(A1:D11,4,F14:F15)","v":2},"=DCOUNT(A1:D11,4,F14:F15)"]
[null,null,null,null,null,null,{"$f":"DCOUNT(A1:D11,3,F14:F15)","v":0},"=DCOUNT(A1:D11,3,F14:F15)"]