☰ Contents · Computing

Mathematical and product functions

Lessons 13–14 · 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
What is =SQRT(49)+ABS(-3)?
2
If the value of x is in A2, write the formula that calculates y = sin(sin x).
3
What is =POWER(5,3)?
4
A2:A4 hold prices 2 500, 3 000, 1 200 and B2:B4 hold quantities 4, 3, 5. What is the SUMPRODUCT result in so‘m?
5
Why does the table of z = sin x + cos y use a mixed reference such as =SIN(B$1)+COS($A2)?