☰ Contents · Computing

Text and logical functions

Lessons 9–10 · 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 does =LEN("Excel jadvali") give (count the space too)?
2
A1 holds “Nodira” and B1 holds “Rahimova”. What formula gives “Rahimova N.”? (Do not use LEFT – type the initial by hand.)
3
What does =IF(OR(3>5,4>2),"yes","no") give?
4
A seller with sales of 3 000 000 so‘m, below 5 000 000, gets a 3% bonus. How many so‘m is the bonus?
5
Write an IF formula for B2 that gives “qabul” if the student scores at least 60 and “rad” otherwise.