☰ 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
Answers are for parents and teachers.
1
If A1 = 9 and A2 = 4, what result does =(A1+A2)*(A1-A2) give?
2
Prices are written from B2 downward and the VAT rate is in E1. Write the formula for C2 that calculates the VAT and can be copied down.
3
What is the price in so‘m, including 12% VAT, of a product that costs 15 000 so‘m?
4
Which error value does the formula ="Ali"*2 give, and why?
5
How do the references B2, $B2, B$2 and $B$2 differ? Describe each in one sentence.