Exam Computer Science 2020 FIPI Problem 7

Опубликовано: 27 Июль 2026
на канале: Exploring the IT World / Oleg Shpagin / WISEPLAT
1,115
30

Hello friends! Task 7 from the Unified State Exam in Computer Science 2020. 😊 This task is about changing a formula when copying a cell in Excel. 😊

“A fragment of a spreadsheet is given. A formula was copied from cell B3 to cell C2. When copying, the cell addresses in the formula automatically changed. What is the numeric value of the formula in cell C2? =A$2 + D$3 Note. The $ sign denotes absolute addressing.”
How to solve?
Answer: Of course... watch the video 😊

#StayHome and learn #WithMe

All lessons of the Unified State Exam in Computer Science FIPI 2020
   • Все уроки ЕГЭ по информатике ФИПИ 2020 год  

#EGE lessons #EGE exams #EGE #computer science #exams
✅ Lessons from #OlegShpagin 👨🏼💻

Like if you liked the video 👍

►► Subscribe to our channel:    / @wiseplat  

Get ready for the Unified State Exam in Computer Science!

Want to do well on the Unified State Exam in Computer Science in the 11th grade? Watch these video lessons to prepare for exams by solving problems from the demo version of the Unified State Exam 2020 in Computer Science.
In this lesson, you will learn how to correlate fields of different tables!

Where to find us ►
--------------------------------------------
Join the VK group - https://vk.com/wiseplat 🚀
FaceBook group -   / wiseplat  
Twitter -   / wiseplatschool  

Popular playlists ►
--------------------------------------------
● All lessons of the Unified State Exam in Computer Science FIPI 2020
   • Все уроки ЕГЭ по информатике ФИПИ 2020 год  
● A series of lessons to prepare for the OGE, Unified State Exam in Computer Science
   • Серия уроков для подготовки к ОГЭ, ЕГЭ по ...  
● OGE Computer Science 2020
   • ОГЭ Информатика 2020  
● All lessons of the OGE in computer science FIPI 2020
   • Все уроки ОГЭ по информатике ФИПИ 2020 год  
● Lessons of the OGE in computer science FIPI 2020 Part 1
   • Уроки ОГЭ по информатике ФИПИ 2020 год Час...  
● Lessons of the OGE in computer science FIPI 2020 Part 2    • Уроки ОГЭ по информатике ФИПИ 2020 год Час...  
● OGE Computer Science 2019
   • ОГЭ Информатика 2019  
● Programming lessons for children on Scratch    • Программирование с нуля на Scratch  
● Programming lessons for children and teenagers on Python    • Уроки Python программирование для начинающ...  
● HTML/CSS lessons. Learn quickly and effectively!    • Уроки HTML, CSS  Как сделать галерею картинок  
● JavaScript lessons. Learn the basics of the language and practice right away.    • Уроки JavaScript от нуля до профи  
● jQuery lessons. For beginners, from scratch    • Уроки jQuery  Подключение к сайту и актива...  
● Bootstrap lessons for beginners, learn to do great things right away from scratch!    • Уроки Bootstrap для начинающих, с нуля  
● Computer hardware. Life hacks. Reviews. Know-how. Instructions. Recommendations.    • Компьютерное железо. Лайфхаки. Обзоры. Ноу...  
● Administration lessons for beginners, servers, networks, storage - their setup and maintenance.
   • Уроки администрирования для начинающих, се...  
● Computer security. Recommendations. Tips. Life hacks. Know-How.
   • Компьютерная безопасность. Рекомендации. С...  
● What's new in the computer world. Reviews. New gadgets. Smartphones. Equipment.
   • Новинки в компьютерном мире  

► Lessons on the Wiseplat website:
--------------------------------------------
✔ Community of programmers: https://wiseplat.org/
✔ Additional description, homework and much more can be found on the WISEPLAT website: https://wiseplat.org/

********************************
❤ If you liked the publication, subscribe to the channel!

👍 Like, then we will create more such content :)

✉ If you have questions or wishes, then write in the comments.
**********************************