AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Contents · Computing

Purpose and capabilities of a spreadsheet

Lessons 19 · 1 lessons · B. Boltayev, A. Azamatov, A. Asqarov, M. Sodiqov, G. Azamatova. Fundamentals of Informatics and Computer Technology, Grade 8. Second edition. “O‘zbekiston milliy ensiklopediyasi” State Scientific Publishing House, Tashkent, 2015
19

Purpose and capabilities of a spreadsheet

Textbook: pp. 88–91
GoalKnows the purpose, capabilities and history of a spreadsheet and the structure of a workbook, and moves around a sheet.
New words
spreadsheet: a program that presents data in a table and automates calculations · elektron jadvalworkbook: a spreadsheet file that contains one or more sheets · ishchi kitobworksheet (sheet): one table of rows and columns inside a workbook · varaqformula: an expression that starts with = and calculates a value from numbers and cell addresses · formula
Explanation

A spreadsheet is a program for presenting and processing data in table form, and above all for automating calculations. For example, a shop totals the sales of 200 products every day: on a calculator this is very laborious, and if one price changes everything must be redone; in a spreadsheet the formula is written once and the result updates itself when the data changes. Its capabilities: presenting and formatting data in a table, formulas and standard functions, automatic filling of cells, search and replace, sorting and filtering, and building charts from the data. The first spreadsheet program, VisiCalc, was created in 1979 by Dan Bricklin and Bob Frankston; the most widespread today are Microsoft Excel, the free LibreOffice Calc and the online Google Sheets. The file is called a workbook (in Excel the extension is .xlsx, in old versions .xls) and consists of one or more sheets. A sheet’s columns are labelled with letters (A, B, ..., Z, AA, ..., XFD – 16,384 in all) and its rows with numbers (1 to 1,048,576); old Excel (up to 2003) had 256 columns and 65,536 rows. Operations: + (add), – (subtract), * (multiply), / (divide), ^ (power) and brackets; the decimal separator (comma or point) depends on regional settings. Moving around: arrow keys, PgUp/PgDn, Home, End, Ctrl+Home (to A1) and Ctrl+End (to the last cell).

VersionColumnsRows
current Excel16,384 (A…XFD)1,048,576
Excel up to 200325665,536
💡 Where will I use this?
In real life

Pupils recorded the pages they read in a week in a table: days in the columns, pupils in the rows. From the table the total for each day and for each pupil was easy to find.

Who uses it

Accountants, teachers, researchers and shop staff keep records in tables.

Try it today

Draw a table with three columns and four rows, fill it with invented numbers and work out the total for each row.

Worked examples
Family budget: 12 months with 6 kinds of spending each. On a calculator you would add 6 numbers 12 times; in a spreadsheet one formula is written and copied across, and if any amount changes the result updates itself.
A current sheet has 16,384 · 1,048,576 = 17,179,869,184 cells (about 17 billion) – more than twice the population of the Earth.
Class activity

“Calculator vs spreadsheet”: half of the group adds 8 numbers on a calculator, half in a spreadsheet; then one number is changed and they compare how fast each method updates.

Practice
1
What was the first spreadsheet program called, when was it made and by whom?
2
How many columns are there from A to Z? And from AA to AZ? How many in total?
3
What is the current extension of an Excel file and what is the file called?
4
Why is a spreadsheet more convenient than a calculator?
Story of the Week · The Khwarizmi WayA warm plate to keep steps ice-freeClose the week: all of this week’s subjects in one storyRead →