☰ Contents · Computing

Using logic in a spreadsheet

Lessons 31 · 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(OR(A1<0; A1>23); 1; 0) give when A1 = 23?
2
What does =IF(A1>=90; 5; IF(A1>=70; 4; IF(A1>=50; 3; 2))) give when A1 = 65?
3
What is LEN("kompyuter")?
4
What negation can be written instead of OR(A1<0; A1>23), and what does it mean?
5
What does =IF(A1>0; A1; -A1) give when A1 = –6?