Using mathematical operations and functions in MS Excel

Lessons 21–22 · 2 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

Answers are for parents and teachers.

What does =SQRT(A1)+MOD(A2; 4) equal for A1 = 81, A2 = 10?

What is the result of joining LEFT("Informatika"; 2) and RIGHT("Informatika"; 3)?

Find the perimeter 2*(A1+B1) of a rectangle with A1 = 12, B1 = 8.

Can the number of pupils in A1 be split into teams of 5 with nobody left over? Write a formula for B1.

In shop A apples cost 16,000 so‘m per kg; in shop B a 2 kg bag costs 30,000 so‘m. Where is 1 kg cheaper? Show the calculation.