컴퓨터적 사고와 이해

I. 데이터 입력 및 편집
1.1 엑셀기능 살펴보기 ··················································································· 13
1.2 데이터 입력 ······························································································ 15
1.3 데이터 채우기 ·························································································· 24
1.4 셀 복사하기 ······························································································ 28
1.5 찾기 및 바꾸기 ························································································ 34

II. 통합문서 관리 및 인쇄
2.1 메모 ············································································································ 39
2.2 워크시트 편집 ·························································································· 44
2.3 행/열 편집 ······························································································· 50
2.4 페이지 레이아웃 ······················································································· 56
2.5 인쇄 ············································································································ 62
2.6 통합문서 관리 ·························································································· 66

III. 서식 및 레이아웃
3.1 글꼴서식 ···································································································· 81
3.2 맞춤서식 ···································································································· 85
3.3 표시형식 ···································································································· 88
3.4 스타일 ········································································································ 92

IV. 데이터 관리
4.1 데이터 유효성검사 ················································································ 115
4.2 중복된 항목 제거 ·················································································· 128
4.3 텍스트 나누기 ························································································ 130
4.4 데이터 정렬 및 필터 ············································································ 133
4.5 외부 데이터 가져오기 ··········································································· 144

V. 수식 및 함수
5.1 수식작성 ·································································································· 151
5.2 셀참조 ······································································································ 153
5.3 이름정의 ·································································································· 165
5.4 기본함수 ·································································································· 170
5.5 조건부 함수 ···························································································· 182
5.6 논리함수 ·································································································· 193
5.7 찾기/참조함수 ························································································· 201
5.8 문자열 함수 ···························································································· 206

VI. 차트 및 디자인
6.1 차트작성 및 디자인 편집 ····································································· 215
6.2 스파크라인 ······························································································ 223
6.3 일러스트레이션 삽입 및 편집 ····························································· 226

문제 해설 ············································································································· 237
참고문헌 ··············································································································· 261
찾아보기 ··············································································································· 263