edubun
日本語
English한국어EspañolPortuguêsFrançaisDeutschItalianoРусский日本語
ホーム›表計算とデータ

表計算の基本

Microsoft Excel と Google スプレッドシートで表計算がどう動くかを学ぶ6つのユニットです。セルと範囲、セルに入る値の種類、数式の書き方、SUM による合計、自動で調整される数式のコピー、エラー値の読み方を扱います。各ユニットには動く小さなスプレッドシートがあり、入力するとすぐに課題が確かめられます。

進み具合
  1. 1セル、行、列、範囲
  2. 2数値、文字列、日付
  3. 3はじめての数式
  4. 4SUM で合計する
  5. 5数式のコピー：相対参照
  6. 6エラー値を読む
このコースの出典 (15)
  • 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)
  • Wikipedia, VisiCalc and Lotus 1-2-3 (VisiCalc used A1 notation; Lotus 1-2-3 launched 1983)

確認日: 2026-10-17