Lesson 9 - Mixed Cell Reference
- Home
- / Fun With Excel
Mixed cell reference is a mixture of both relative and absolute cell reference. Here is mixed cell reference, either row is fixed and column is free or column is fixed and row is free.
Like in case of,
= $A5 + B$1
Here in this formula, column A is fixed while row 5 will be changed when we copied formula. Similarly, row 1 is fixed while column B is free and can be changed by copying a formula from one place to another.
Making your own notes makes things easier to understand and memorize. Well, in next lesson you will going to learn inserting Charts in worksheet.
Charts are a graphical method to represent the report or data to make it easier to understand. Charts can be used be –
You can insert charts in your worksheet of your choice. Follow these steps to insert charts –
Vinay Bhatt is the Founder of LearnInCreation, an education and technology platform focused on making computer science and digital learning simple, practical, and accessible. He holds a B.Sc. degree from Kumaun University and has professional certifications in Full Stack Web Development, Digital Marketing, and Ethical Hacking. Passionate about education and technology, he creates beginner-friendly courses, practical learning resources, and projects that help students develop real-world skills and prepare for their careers.
LearnInCreation helps students learn computer science and technology through easy-to-understand courses, practical projects, books, e-books like learning resources, enabling them to build skills for academic success and future careers.
Watch old videos of computer lessons, Subscribe us on Youtube
