☰ Contents · Computing

Logic in a spreadsheet: practical lesson

Lessons 32 · 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
Answers are for parents and teachers.
1
What does =IF(A1>=10; A1-10; 10-A1) give when A1 = 4?
2
What does =IF(AND(A1>0; B1>0); A1*B1; 0) give when A1 = 3 and B1 = –2?
3
What does RIGHT("kompyuter"; 3) give?
4
Is 2100 a leap year? Explain.
5
What is wrong in the formula =IF(A1>5;"big";"small" ?