Предмет: Информатика, автор: Dyikksks

Срочно информатика 9кл даю 35баллов

Приложения:

vloganima: Это же эксель?

Ответы

Автор ответа: vloganima

0

Ответ:

=ЕСЛИ(B2>2;"Зачёт";"Нет зачёта")
=ЕСЛИ(ИЛИ(B2=5;B2=4;B2=3); "Зачёт"; "Нет зачёта")
=ЕСЛИ(И(B2>2;B2<=5);"Зачёт"; "Нет зачёта")
=ЕСЛИ(ИЛИ(B2=5;B3=4;B3=3);"Зачёт";ЕСЛИ(ИЛИ(B3=2;B3=1);"Нет зачёта";"Ошибка"))
=ЕСЛИ(B2=5;"Отлично!";ЕСЛИ(B2=4;"Хорошо!";ЕСЛИ(B2=3;"Удовлетворительно";ЕСЛИ(ИЛИ(B2=2;B2=1);"Плохо";"Ошибка"))))

Эксель:

Приложения:

a078df6e2e654a49db45206ac95fda9c.xlsx

Предыдущий вопрос

Следующий вопрос

Интересные вопросы

Предмет: Другие предметы, автор: anastasiyamats

РИСА ЛЮДИНИ,ЯКА ОХОЧЕ ДІЛИТИСЯ ТИМ ЩО МАЄ?БУДЬ-ЛАСКА ПІДКАЖІТЬ

2 года назад

Предмет: Английский язык, автор: BnpoLLecce

David White is our Geography teacher. He likes his job very much, but his wife, Mary, doesn't like her job. She's a Maths teacher in our school. She doesn't like her job because the students don't usually like her subject. Sometimes they don't like Geography either, but I think it's very interesting. We do a lot of interesting things in the class. Mr and Mrs White's daughter, Zoe, is in my class. She says that her dad helps at home. He sometimes does the shopping and takes the rubbish out and he always feeds the dog. He often cooks dinner, too. Zoe usually washes up, and vacuums the floor. Mr White never washes the car because his son Andy does it. Andy is at our school, too. Mary teaches Zoe and Andy Maths and they both like it. Andy doesn't do Geography, he does French instead.

3. Read about Mr White and mark the sentences true (T) or false (F).

1. The Geography teacher doesn't like his job. __________
2. The Maths teacher's name is Mary White. __________
3. A lot of students like Maths. __________
4. All the students think Geography is interesting. __________
5. Zoe sometimes feeds the dog. __________
6. Zoe normally washes up. __________
7. Andy always cleans the car. __________
8. Zoe doesn't like Maths. __________
9. David and Mary are Zoe's teachers. ___________
10. Andy learns French. ___________

2 года назад

Предмет: Русский язык, автор: bushuevapolina0

помогите подобрать профессиализмы и термины к профессии Продавец

2 года назад

Предмет: Алгебра, автор: Levdzyuban

Помогите пожалуйста .Запишите в ответе номера верных равенств 1)4÷6/7=3/14 2)0,4×3/2=0,6 3)3/2+0,6-2,1 4)1,2/1-1/2=0,8

8 лет назад

Предмет: Химия, автор: ILSPro

Напишите структурную формулу ацетата магния и ацетата цинка

8 лет назад