{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["유효성1","유효성2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,4,5,5],[5,8,5,9],[5,10,5,11]]}
[null,"1. 다음의 지시사항으로 유효성 검사규칙을 작성하시오."]
[null,"▶ 각 표의 날짜 영역에 2020년 날짜만 입력 가능하도록 설정."]
[null,"▶ 각 표의 현찰과 송금 영역의 모든 숫자에 1.9부터 1500.9 까지만 입력 가능하도록 설정."]
[]
[null,"환율 미국(USD)",null,null,null,null,null,"환율 중국(CNY)"]
[null,"날짜","현찰",null,"송금(전신환)",null,null,"날짜","현찰",null,"송금(전신환)"]
[null,null,"사실때","파실때","보내실때","받으실때",null,null,"사실때","파실때","보내실때","받으실때"]
[null,"2020-06-01",1182.8399999999999,1142.1600000000001,1173.8,1151.2,null,"2020-05-01",191.53,170.05,180.79,177.21]
[null,"2020-07-01",1190.47,1149.53,1181.4000000000001,1158.5999999999999,null,"2020-01-01",189.99,168.7,179.34,175.8]
[null,"2020-08-01",1214.28,1172.52,1205,1181.8,null,"2020-02-01",190.46,169.1,179.78,176.22]
[null,"2020-09-01",1210.82,1169.18,1201.5999999999999,1178.4000000000001,null,"2020-03-01",188.57,167.43,178,174.48]
[null,"2020-10-01",1208.28,1166.72,1199.0999999999999,1175.9000000000001,null,"2020-04-01",189.37,168.15,178.75,175.23]

{"sheet":"유효성2","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[null,"2. find 함수를 이용하여 이메일 형식을 입력하도록 유효성 검사규칙을 설정하시오."]
[null,"u 이메일 주소 안에 반드시 @ 입력 (단, 첫글자는 @ 입력 불가능)"]
[]
[null,"[표1]"]
[null,"반","성명","성별","생년월일","이메일","출석일수"]
[null,"믿음반","김종헌","남","2007-05-21","kjh01@gmail.com",13]
[null,"믿음반","김종헌","남","2007-08-10","kjh01@gmail.com",12]
[null,"믿음반","김주형","남","2007-06-29","kjh03@gmail.com",15]
[null,"믿음반","박건우","남","2007-02-24","pkw@gmail.com",14]
[null,"믿음반","박연우","남","2007-09-11","pyw@gmail.com",13]
[null,"믿음반","전지호","남","2007-09-21","jjh@gmail.com",15]
[null,"믿음반","김서영","여","2007-02-08","ksy@gmail.com",15]
[null,"믿음반","송예린","여","2007-03-02","syl@gmail.com",15]
[null,"소망반","박진우","남","2007-02-03","pjw@gmail.com",10]
[null,"소망반","임형빈","남","2007-01-03","lhb@gmail.com",12]