☰ Contents · Computing

Cross-sheet references and functions

Lessons 5–6 · 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 is =LCM(4,6,10)?
2
What is =FACT(6)?
3
Write a formula that adds the cells A1 on the sheets “Yanvar” and “Fevral”.
4
Prices are 12 000, 8 500 and 15 000 so‘m and quantities are 3, 2 and 1 pieces. How many so‘m does SUMPRODUCT calculate as the total?
5
Under what name does the GCD function appear in a Russian-language Excel, and what is the argument separator?