Электрондық кесте / spreadsheet



бет3/4
Дата04.03.2023
өлшемі314,79 Kb.
#71494
түріБағдарламасы
1   2   3   4
2.4 Функциялар / Functions

Мақсаты: Excel бағдарламасында функция мәндерін кесте түрінде есептеп шығаруды үйрену.

Goal: To Learn how to calculate the values ​​of functions in Excel table.







ТАПСЫРМА BB1

TASK BB1

To check whether the student has passed the certification:
Cell C3 is marked. The Insert→Function command is executed. In this case, it is necessary to take into account the following factors:
you choose. In the next window of the function logical
to calculate the value in cell B3, compare the conditional value of 45% :
We write as B3>=45%. According to the agreement:
The name of the name is written: "attested"; the name of the name is written: "not attested" ;
Click OK;
This formula is copied to the remaining cells.
!!!!!!!!!!!!minimum of 10 last names




To check whether the student has passed the certification:
Cell C3 is marked. The Insert→Function command is executed. In this case, it is necessary to take into account the following factors:
you choose. In the next window of the function logical
to calculate the value in cell B3, compare the conditional value of 45% :
We write as B3>=45%. According to the agreement:
The name of the name is written: "attested"; the name of the name is written: "not attested" ;
Click OK;
This formula is copied to the remaining cells.
!!!!!!!!!!!!minimum of 10 last names






Достарыңызбен бөлісу:
1   2   3   4




©emirsaba.org 2024
әкімшілігінің қараңыз

    Басты бет