AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ 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" ?
Story of the Week · The Khwarizmi WayA fertiliser test for seedlingsClose the week: all of this week’s subjects in one storyRead →