edubun English
홈›스프레드시트·데이터

스프레드시트 기초

Microsoft Excel과 Google Sheets에서 스프레드시트가 어떻게 움직이는지 여섯 단원으로 배웁니다. 셀과 범위, 셀에 들어가는 값의 종류, 수식 쓰기, SUM으로 더하기, 복사하면 저절로 바뀌는 수식, 오류 값 읽는 법을 다룹니다. 단원마다 직접 입력해 보는 작은 스프레드시트가 있고, 과제는 입력하는 대로 채점됩니다.

진도
  1. 1셀, 행, 열, 범위
  2. 2숫자, 텍스트, 날짜
  3. 3첫 수식 쓰기
  4. 4SUM으로 더하기
  5. 5수식 복사와 상대 참조
  6. 6오류 값 읽기
이 과정의 출처 (2)
  • Microsoft Support, "Excel specifications and limits" (support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3: 1,048,576 rows by 16,384 columns, 15-digit precision, 255 arguments), "Calculation operators and precedence in Excel" (.../calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a: operators, order negation % ^ * / + - & comparisons, =5+2*3 is 11, ="1"+"2" is 3, ="A"&TRUE is ATRUE, #### for too little space), "SUM function" (.../sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89: up to 255 numbers, =A1+B1+C1 gives #VALUE! with text while SUM ignores text), "Switch between relative, absolute, and mixed references" (.../dfec08cd-ae65-4f56-839e-5f0d8d0baca9: =B4*C4 copied from D4 to D5 becomes =B5*C5), "Date systems in Excel" (.../e7fe7167-48a9-4b96-bb53-5612a800b487: July 5, 2011 is 40729 in the 1900 system and 39267 in the 1904 system, 1,462 days apart), "Remove or allow a circular reference" (.../8540bd0f-6e97-4483-bcf7-1b49cd50d123: warning, then 0 or the last value), VLOOKUP and IF pages (#N/A, #NAME? from missing quotes). Google Docs Editors Help: SUM (support.google.com/docs/answer/3093669: any number of arguments), DATE (answer/3092969: days counted from December 30, 1899), Keyboard shortcuts for Google Sheets (answer/181110: Ctrl+D fill down, Ctrl+R fill right, Ctrl+~ show all formulas, F4 absolute/relative), Files you can store in Google Drive (support.google.com/drive/answer/37603: up to 20 million cells per spreadsheet), ERROR.TYPE (answer/3238305: the error values). History: Smithsonian National Museum of American History, VisiCalc software and documentation, object nmah_1696121 (Bricklin and Frankston, Apple II, 1979)
  • ACM Interactions, "The first killer app: a history of spreadsheets" (2013: Lotus 1-2-3, Excel for the Macintosh in 1985)

확인한 날: 2026-10-17