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

Excel formulas and references

Lessons 1–2 · 2 lessons · N. I. Taylaqov (general editor), A. B. Akhmedov, M. D. Pardayeva, A. A. Abdug‘aniyev, U. M. Mirsanov. Informatics and Information Technologies, Grade 10, 1st edition. “Extremum-Press”, Tashkent, 2017
1

Calculating simple expressions

Textbook: pp. 5–7
GoalKnows cell addresses, the rule for writing a formula and the error values in an Excel sheet; calculates simple arithmetic expressions.
New words
cell address: the column letter followed by the row number, for example C45 · katak manziliformula: an entry that starts with = and is calculated by Excel · formulaformula bar: the line that shows and edits the content of the active cell · formulalar satrierror value: a code such as #DIV/0! that shows why a formula could not be calculated · xato qiymati
Explanation

In a spreadsheet a workbook consists of sheets. The columns of a sheet are named with letters (A to XFD, 16 384 in all) and the rows with numbers (1 to 1 048 576); a cell address is built from the column letter and the row number, for example C45. A formula always begins with the “=” sign, so that Excel understands the entry as an expression to calculate, not as text. The operations are + (add), – (subtract), * (multiply), / (divide) and ^ (power). Powers are done first, then multiplication and division, and addition and subtraction last; brackets change the order. The cell shows the result, while the formula itself is in the formula bar; the file extension is .xlsx. If a formula cannot be calculated, the cell shows an error value: #DIV/0! (division by zero), #NAME? (name not recognised), #VALUE! (wrong type of value), #REF! (reference to a cell that does not exist); the #### sign appears when a number does not fit in the column. This lesson was written for Excel 2010, but formulas work the same way in current Excel, LibreOffice Calc and Google Sheets.

Order: ^, then * and /, then + and –; brackets first
SignOperation
+add
–subtract
*multiply
/divide
^power
💡 Where will I use this?
In real life

At a chess club a player says “e4” and everyone finds the same square, because the letter gives the column and the number gives the row. A spreadsheet cell address works in the same way, so two people can find the very same number without a mix-up.

Who uses it

Accountants, teachers who keep lists and warehouse workers tell others exactly where a number is by giving its cell address.

Try it today

On paper, draw a grid of 4 columns and 4 rows, label the columns A–D and the rows 1–4, and ask a friend to find which square “C3” is.

Worked examples
B1fx=A1*A2+A1/A2
AB
11563.75
24
A1 holds 15 and A2 holds 4. The formula =A1*A2+A1/A2 gives 15·4 = 60, 15/4 = 3.75, and the sum is 63.75.
In =2+3*4^2 first 4^2 = 16, then 3·16 = 48, and finally 2 + 48 = 50. With brackets, =(2+3)*4^2 gives 5·16 = 80.
Class activity

“Predict the error”: the teacher writes three formulas: =5/0, ="Hello"+1 and =ABC(2). Students guess which error value each gives, and then the result is checked on the computer.

Practice
1
What is the name of the last column of an Excel sheet and how many rows are there?
2
B1 holds 12 and B2 holds 7. What result does the formula =B1*B2-B1 give?
3
If B1 = 0 in a formula that calculates A1 / B1, which error value appears and why?
4
Why must a formula begin with the “=” sign?
Story of the Week · The Khwarizmi WayThe Fact-check club: the first claimClose the week: all of this week’s subjects in one storyRead →