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

Elements of a spreadsheet

Lessons 20 · 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
20

Elements of a spreadsheet

Textbook: pp. 92–97
GoalKnows the cell, its address, a block of cells, data types, and relative and absolute references, and copies formulas.
New words
cell address: column letter plus row number, e.g. B3 · katakcha adresirange (block) of cells: a rectangle of cells written with a colon, e.g. C2:D4 · katakchalar blokirelative reference: an address that changes when the formula is copied · nisbiy murojaatabsolute reference: an address with $ signs that stays fixed when copied · absolyut murojaat
Explanation

A table consists of cells at the crossing of rows and columns; each cell’s address is made from the column letter and row number (B3, AZ105). The selected cell is called the current cell. A block (range) of cells is written with two opposite corner addresses: C2:D4 means cells C2, C3, C4, D2, D3, D4. A cell can contain text, a number, a date, a time, a formula or a function; a formula always begins with “=” (=A1+7*B2). If a number does not fit, ##### is shown – widen the column. To edit, select the cell and press F2; to clear, press Delete; Alt+Enter starts a new line inside a cell; formatting (font, colour, border, number type) is in the Ctrl+1 window. A reference is the use of another cell’s address in a formula. A relative reference changes when copied: copying =A4+C2 from B5 to B6 gives =A5+C3. In an absolute reference the $ sign fixes the address: $B$4 never changes; in $B4 the column is fixed, in B$4 the row. The F4 key switches the reference type while editing. A cell or block can be given a name (in the Name Box) and the name used in formulas instead of the address.

B3fx=A1+7*B2
ABCD
11
22
315
4
💡 Where will I use this?
In real life

In class a pupil gave their seat exactly as “third row, second desk”. With such an address nobody was confused and the teacher found it at once.

Who uses it

Mapmakers, accountants and programmers find a place by an address or coordinates.

Try it today

Draw a grid in your notebook with columns A, B, C and rows 1, 2, 3, place three small items on it and write their addresses.

Worked examples
CellFormula
C2=B1+$D$2
E5=D4+$D$2
Relative copy: let C2 hold =B1+$D$2. Copying it to E5 (2 columns right, 3 rows down) changes B1 to D4 while $D$2 stays: =D4+$D$2.
CellFormula
C3=B$2*$A3
E6=D$2*$A6
Mixed reference: copying =B$2*$A3 from C3 to E6 (2 columns right, 3 rows down): B$2 → D$2 (row fixed), $A3 → $A6 (column fixed). Result: =D$2*$A6.
Class activity

“Cell battle”: pairs find hidden addresses in a table (for example “column 3, row 5” – C5) and then give each other formula-copying puzzles.

Practice
1
How many cells are in the block C4:D6 and which are they?
2
B2 holds =A1*C1. What is it after copying to B3?
3
B3 holds =A2+$E$1. What is it after copying to D5?
4
Why is an absolute reference ($F$3) used for the total in a percentage formula?
Story of the Week · The Khwarizmi WayA warm mat for seedlingsClose the week: all of this week’s subjects in one storyRead →