Spreadsheet

Example of a spreadsheet holding data about a group of audio tracks.
A sample spreadsheet showing formula

A Spreadsheet is a computer program that imitates a paper worksheet.[1][2][3] It shows a large sheet (like a sheet of paper) that has many cells in a grid of rows and columns.[4] Users can put words or numbers into the cells, to make headings and store information (usually numbers). You can also move the grid lines around so that some cells are bigger than others, and change the color or size of text/font, the same way font/text is changed in a word processor. You can even put pictures in the worksheets, make multiple pages, and print out their results on real paper.[5][6][7]

The primary reason most people use spreadsheets is for automatic calculations. Spreadsheets can be designed to add up the items/amounts on a bill, calculate sales tax, and even calculate income tax. A user can add and subtract the numbers here, even if the numbers are not next to each other. This means the computer does all the math, and people only need to give the correct information.

Another strength of spreadsheets, is that they can produce diagrams, like graphs and pie-charts, based on the data the user enters. Sometimes the numbers make more sense when the computer turns them into a picture.

Basics

In 1969, a program called LANPAR was created.[8] It was like a digital table that could do math on big computers shared by many people. They named it LANPAR because those words meant something special.[8] Then, in 1979, a similar program called VisiCalc was made for smaller computers.[9] This helped make the Apple II computer really popular. Before Windows became common, a program called Lotus 1-2-3 was the most popular for working with these digital tables.[10] But now, Microsoft Excel is the most used one on Windows and Mac computers.[11][12][13] These digital table programs are now found in programs that help people do work in offices. In 2006, Google made their own digital table program that you can use on the internet. It's called Google Sheets and is part of Google Drive.[14]

A spreadsheet is like a digital table made up of little boxes called cells. These cells are put in rows (like lines in a book) and columns (like vertical lines). Each cell has a special name that tells its position, using letters for columns and numbers for rows. For example, a cell might be called "C10." This idea of giving cells names was first used in a program called LANPAR. Another program called VisiCalc used a similar way of naming cells. You can also talk about a group of cells that are next to each other, like a bunch of cells in a column. This group is called a range. To talk about a range, you use the names of the first and last cells in that group. For example, you can call the first ten cells in the first column "A1:A10." LANPAR did something special too. It allowed you to do calculations that depended on things you would write later. This was helpful and came back later in programs like Lotus 123 and Microsoft's MultiPlan Version 2.

In the new computer programs that work with tables, we put many tables together to make a big book called a workbook. This workbook is like a special computer file that holds all the information for the book, including the tables and the little boxes in the tables. Each table inside the workbook is called a worksheet or sheet for short. You can imagine these sheets like pages in a book. To switch between them, you can use tabs, just like flipping pages. But one program called Numbers does it differently. If you have many sheets in one book, you give each box a special name that tells which sheet it's in. For example, you might say "Sheet 1!C10" to talk about a box in Sheet 1. Sometimes, you can even use this naming to talk about boxes in other books too.

  • Microsoft Excel
  • LibreOffice Calc
  • Apple Numbers
  • Google Sheets
  • Lotus 1-2-3 IBM, for Windows, Mac OS X & Linux, original 1983, last 2010
  • Quattro Pro, for Windows, original 1989, last 2010
  • Gnumeric, for Windows & Linux, original 2002, last 2010
  • Kspread, Windows, Mac OS X & Linux, original 2007, last 2010
  • EditGrid, internet based, like Google Spreadsheets, 2008
  • OpenOffice.org Calc, last 2011

Old spreadsheet software

  • VisiCalc, original 1979
  • APLDOT modeling language: US Railway Association. 1976
  • LANPAR spreadsheet compiler: Bell Canada and AT&T, 1969
  • Autoplan/Autotab spreadsheet programming language: GE, 1968
  • BCL, or Business Computer Language: IBM, 1963
  • MultiPlan
  • T/Maker
  • Target Planner Calc for CP/M and TRS-DOS
  • Trapeze for Macintosh
  • Wingz for Macintosh

References

  1. ↑ "spreadsheet". Merriam-Webster Online Dictionary. Retrieved 23 June 2016.
  2. ↑ American Heritage Dictionary of the English Language (5th ed.). Houghton Mifflin Harcourt Publishing Company. 2011. A software interface consisting of an interactive grid made up of cells in which data or formulas are entered for analysis or presentation.
  3. ↑ Collins English Dictionary – Complete and Unabridged (12th ed.). HarperCollins Publishers. 2014. (Computer Science) a computer program that allows easy entry and manipulation of figures, equations, and text, used esp for financial planning and budgeting
  4. ↑ "spreadsheet". WhatIs.com. TechTarget. Retrieved 23 June 2016.
  5. ↑ "spreadsheet". Dictionary.com Unabridged. Random House, Inc. Retrieved 23 June 2016.
  6. ↑ Beal, Vangie (September 1996). "spreadsheet". webopedia. QuinStreet. Retrieved 23 June 2016.
  7. ↑ "Spreadsheet". Computer Hope. Archived from the original on 21 June 2016. Retrieved 23 June 2016.
  8. ↑ 8.0 8.1 Higgins, Hannah (2009-01-01). The Grid Book. MIT Press. ISBN 9780262512404.
  9. ↑ Charles Babcock, "What's The Greatest Software Ever Written?", Information Week, 11 Aug 2006 Archived 25 June 2017 at the Wayback Machine. Accessed 25 June 2014
  10. ↑ Lewis, Peter H. (1988-03-13). "The Executive computer; Lotus 1-2-3 Faces Up to the Upstarts". NYTimes.com. The New York Times Company. Retrieved 2012-10-14. Release 3.0 is being written in the computer language known as C, to provide easy transportability among PCs, Macs and mainframes.
  11. ↑ "Rivals Set Their Sights on Microsoft Office: Can They Topple the Giant? –Knowledge@Wharton". Wharton, University of Pennsylvania. Retrieved 2010-08-20.
  12. ↑ "spreadsheet analysis from winners, losers, and Microsoft". Utdallas.edu. Archived from the original on 2010-07-23. Retrieved 2010-08-20.
  13. ↑ "A". Utdallas.edu. Archived from the original on 2010-08-05. Retrieved 2010-08-20.
  14. ↑ Arrington, Michael (11 Oct 2006). "Google "Docs & Spreadsheets" Launches". TechCrunch. Retrieved 8 July 2023.

Read other articles:

1859 Louisiana gubernatorial election

This article relies largely or entirely on a single source. Relevant discussion may be found on the talk page. Please help improve this article by introducing citations to additional sources.Find sources: 1859 Louisiana gubernatorial election – news · newspapers · books · scholar · JSTOR (December 2014) 1859 Louisiana gubernatorial election ← 1855 November 7, 1859 1863 (Confederate) →   Nominee Thomas Overton Moore Thomas Je...

 

Jeffrey Polnaja

Jeffrey PolnajaJeffrey PolnajaLahir(1962-06-00)Juni 1962Bandung, IndonesiaPekerjaanPhotographer, Motivator, Penulis.Dikenal atasPenjelajah DuniaSitus webrideforpeace.net Jeffrey Polnaja (EYD: Jeffrey Polnaya, Bandung, Juni 1962) adalah orang Indonesia pertama yang berkeliling dunia mengendarai sepeda motor seorang diri.[1][2] Biografi Jeffrey Polnaja lahir di kota Bandung, Juni 1962.[3] Kegemaran bertualang sudah dimulai sejak muda, mulai dari mendaki gunung, terbang ...

 

Cannanore

Cet article est une ébauche concernant une localité indienne. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Cannanore Vue générale Administration Pays Inde État ou territoire Kerala District Cannanore Fuseau horaire IST (UTC+05:30) Démographie Population 63 797 hab. (2001) Géographie Coordonnées 11° 52′ 08″ nord, 75° 21′ 20″ est Localisation Géolocalis...

Shanésia Davis-Williams

Shanésia Davis-WilliamsNama lainShanesia Davis atau Shane Williams Shanésia Davis-Williams (lahir 30 September 1966) adalah aktris asal Amerika Serikat. Ia mulai dikenal setelah berperan sebagai Marissa Clark dalam serial televisi Early Edition. Filmografi Film With Honors (1994) Chicago Cab (1997) Uncle Nino (2003) Life Sentence (2004) The Weather Man (2005) Morning Due (2008) Film televisi Howard Beach: Making A Case For Murder (1989) Televisi Missing Persons (1993, 1 Episode) Early...

 

Rumah Limas

Rumah Limas, rumah tradisional Sumatera Selatan, di uang Rp 10.000 Rumah Limas merupakan rumah tradisional Sumatera Selatan. Selain ditandai dengan atapnya yang berbentuk limas, rumah tradisional ini memiliki lantai bertingkat-tingkat yang disebut Bengkilas atau Kijing dan hanya dipergunakan untuk kepentingan keluarga seperti hajatan.[1] Para tamu biasanya diterima diteras atau lantai kedua. Rumah Limas ini memiliki nama lain, yaitu Rumah Bari. Di Malaysia, rumah Limas ini juga banyak...

 

Naya-Micay Fault

Naya-Micay FaultFalla de Naya-MicayEtymologyNaya & Micay RiversLocationTumaco BasinCoordinates03°15′41.0″N 77°22′54.2″W / 3.261389°N 77.381722°W / 3.261389; -77.381722Country ColombiaRegionPacific/ChocóStateCauca, Valle del CaucaCharacteristicsPart ofPacific oblique faultsLength158.2 km (98.3 mi)Strike034.1 ± 12DipEastDip angleunknownDisplacement0.2–1 mm (0.0079–0.0394 in)/yrTectonicsPlateNorth AndeanStatusInactiveTypeObli...

هنري تشارلز كاري

هنري تشارلز كاري (بالإنجليزية: Henry Charles Carey)‏    معلومات شخصية الميلاد 15 ديسمبر 1793 [1][2]  فيلادلفيا[3]  الوفاة 13 أكتوبر 1879 (85 سنة) [1]  فيلادلفيا  مواطنة الولايات المتحدة  عضو في الأكاديمية الملكية السويدية للعلوم،  والأكاديمية الأمريكية للفن...

 

Zulfa Maharani

Zulfa MaharaniLahirZulfa Maharani Putri10 Desember 1999 (umur 24)Jakarta, IndonesiaKebangsaanIndonesiaAlmamaterInstitut Komunikasi dan Bisnis LSPRPekerjaanPemeranmodelTahun aktif2011—sekarang Zulfa Maharani Putri (lahir 10 Desember 1999) adalah pemeran dan model Indonesia.[1][2] Pendidikan Institut Komunikasi dan Bisnis LSPR, S-1 Ilmu Komunikasi (lulus)[3] Filmografi Film Tahun Judul Peran Catatan Ref. 2014 Kau dan Aku Cinta Indonesia Cahaya Larasati 2016 ...

 

趙家驤

追晉陸軍二級上將趙家驤將軍个人资料出生1910年 大清河南省衛輝府汲縣逝世1958年8月23日(1958歲—08—23)（47—48歲） † 中華民國福建省金門縣国籍 中華民國政党 中國國民黨获奖 青天白日勳章（追贈）军事背景效忠 中華民國服役 國民革命軍 中華民國陸軍服役时间1924年－1958年军衔 二級上將 （追晉）部队四十七師指挥東北剿匪總司令部參謀長陸軍�...

2018 FIVB Volleyball Men's Nations League

International volleyball tournament 2018 FIVB Volleyball Men's Nations LeagueLille, host city of the final roundTournament detailsHost nation FranceCityLille (final round)Dates25 May – 8 JulyTeams16 (from 4 confederations)Venue(s)22 (in 22 host cities)Champions Russia (1st title)Runners-up FranceThird place United StatesFourth place BrazilTournament awardsMVP Maxim MikhaylovBest Setter Benjamin ToniuttiBest OH Taylor Sander Dmitry VolkovBest MB Kévin Le R...

 

周處除三害 (電影)

周處除三害The Pig, The Snake and The Pigeon正式版海報基本资料导演黃精甫监制李烈黃江豐動作指導洪昰顥编剧黃精甫主演阮經天袁富華陳以文王淨李李仁謝瓊煖配乐盧律銘林孝親林思妤保卜摄影王金城剪辑黃精甫林雍益制片商一種態度電影股份有限公司片长134分鐘产地 臺灣语言國語粵語台語上映及发行上映日期 2023年10月6日 (2023-10-06)（台灣） 2023年11月2日 (2023-11-02)（香�...

 

منطقة أرغون

  منطقة أرغون   منطقة أرغون منطقة أرغون  خريطة الموقع تقسيم إداري البلد إسبانيا  [1][2] العاصمة سرقسطة  [لغات أخرى]‏  التقسيم الأعلى إسبانيا  خصائص جغرافية إحداثيات 41°N 1°W / 41°N 1°W / 41; -1   [3] أعلى قمة أنيتو  المساحة 47719 كيلومتر ...

Dominic Thiem

Austrian tennis player (born 1993) Dominic ThiemThiem at the 2023 Monte-Carlo MastersCountry (sports) AustriaResidenceLichtenwörth, AustriaBorn (1993-09-03) 3 September 1993 (age 30)Wiener Neustadt, AustriaHeight1.85 m (6 ft 1 in)[1]Turned pro2011PlaysRight-handed (one-handed backhand)CoachGünter Bresnik (2002–2019)Nicolás Massú (2019–2023)[2]Benjamin Ebrahimzadeh (2023–2024)[3] Mate Delić (2024)[4]Prize moneyUS$ 30...

 

Mathematics of Sudoku

Mathematical investigation of Sudoku This article is about the mathematical analysis of Sudoku puzzles. For solving and generating algorithms, see Sudoku solving algorithms. Some of this article's listed sources may not be reliable. Please help improve this article by looking for better, more reliable sources. Unreliable citations may be challenged and removed. (May 2024) (Learn how and when to remove this message) A 24-clue automorphic Sudoku with translational symmetry Mathematics can be us...

 

Kota Batu

Halaman ini berisi artikel tentang kota di Jawa Timur, Indonesia. Untuk kegunaan lain, lihat Batu (disambiguasi). 7°51′59.5″S 112°30′45.4″E / 7.866528°S 112.512611°E / -7.866528; 112.512611 Kota Batu Kota Wisata Batu (KWB)KotaTranskripsi bahasa daerah • JawaBatu (Gêdrig) باتو (Pégon) ꦧꦠꦸ (Hånåcåråkå) • Osob KiwalanUtab (Gêdrig) اوتاب (Pégon) ꦈꦠꦧ꧀ (Hånåcåråkå) • Tionghoa巴图 (Ji�...

Moustalevria

MoustalevriaAlternative namesMoustokouloura (cookies), mustopita (pie form), palouzes, kefteria, kourkoutaTypePuddingPlace of originGreeceMain ingredientsGrape must, flour Moustalevria (Greek: μουσταλευριά) or must jelly (also mustpie and mustcake) is a traditional Greek kind of pudding made of grape must mixed with flour and boiled until thick. Moustokouloura, must biscuits or must cookies are the biscuit (cookie) version. Historical information and names Moustalevria originated ...

 

Zeta Hydri

ζ Hydri Vị trí của ζ Hydri (khoanh tròn) Dữ liệu quan sát Kỷ nguyên J2000      Xuân phân J2000 Chòm sao Thủy Xà Xích kinh 02h 45m 32.63435s[1] Xích vĩ −67° 36′ 59.8268″[1] Cấp sao biểu kiến (V) 4.83[2] Các đặc trưngKiểu quang phổA2IV[2]Chỉ mục màu U-B+0.09[3]Chỉ mục màu B-V+0.06[3] Trắc lượng học thiên thểVận tốc...

 

Parábolas de Jesús

Representación de la parábola del hijo pródigo por Pompeo Batoni Las parábolas de Jesús son aquellas breves narraciones dichas por Jesús de Nazaret que encierran una educación moral y religiosa, revelando una verdad espiritual de forma comparativa. La parábola es un relato religioso corto que es fácil de comprender y brinda verdad espiritual. No son fábulas, pues en estas no intervienen personajes animales con características humanas, ni alegorías, pues se basan en hechos u observ...

Lyonnais

Not to be confused with Lyonesse or Olympique Lyonnais. This article is about a historical province of France. For other uses, see Lyonnais (disambiguation). This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Lyonnais – news · newspapers · books · scholar · JSTOR (February 2024) (Learn how and when to remove th...

 

أوست-كوت

أوست-كوت    علم شعار الإحداثيات 56°48′00″N 105°50′00″E / 56.8°N 105.83333333333°E / 56.8; 105.83333333333   تاريخ التأسيس 1631  تقسيم إداري  البلد روسيا[1][2]  خصائص جغرافية  المساحة 56 كيلومتر مربع  ارتفاع 300 متر  عدد السكان  عدد السكان 278 (1875)[3]21343 (1959)[...