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

EXCEL
Постройте графики функций у = sin ( х ) , у = cos ( х ) на отрезке [-5; 5] с шагом 0,5
Желательно кинуть готовый файлик, 100 баллов

Ответы

Автор ответа: valgrisa
1

Ответ:

файл

Объяснение:

заполняем таблицу для графиков:

вводим начальное значение x, затем вводим второе значение x (начальное значение плюс шаг), выделяем обе ячейки и используя маркер заполнения (квадратик в правом нижнем углу) протягиваем до конечного значения x

вводим формулы для у (используем относительные ссылки, см. скрин 2), выделяем их и копируем до конечного значения x

при желании форматируем таблицу

строим графики:

выделяем таблицу, вкладка Вставка, группа Диаграммы, Точечная, Точечная с гладкими кривыми и маркерами

при желании форматируем графики

Приложения:
Похожие вопросы
Предмет: Английский язык, автор: velibekova0320
Срочно!!!! Нужен краткий пересказ.
It is a wonderful world we live in. For thousands of years the Earth has given support to all forms of life – human beings, animals, birds, fishes, insects and plants. But now human beings are killing our planet. Many species of animals and birds have disappeared. Millions of animals die every year because man has polluted their natural homes. Besides, every year people cut down more trees, build more roads, and use more land for farming. This leaves fewer jungles, fields and forests for wildlife. The country air, once clean and fresh, now may be polluted by power stations and factories. Some of our rivers are now empty of fish. And in some rivers you can even see a thick foam caused by chemical waste. All over the words the forests are disappearing. People cut the trees down because they need wood and paper or new places for farms and houses. Forests the size of Belgium are destroyed every year. It’s an international disaster. Even if new trees are planted, it takes many year for them to grow. Go to the seaside and you’ll see the pollution around you. There is a lot of litter on the beaches. Some of it was left by people and some was brought by the water. Pollution is very dangerous for people, wildlife and the environment. We live among litter and wastes which we have created ourselves – fumes of cars, throwaway packaging, etc. They pollute themselves with cigarettes, alcohol and junk food. These are some of the world’s most serious environmental problems. And it’s no good pretending they don’t exist – they do. What’s more, they are getting worse all the time! What will happen if we don’t try to solve these problems? Scientists have made predictions and they are alarming.
Предмет: Английский язык, автор: Аноним
Предмет: Математика, автор: nikita8277