In the previous blogs, we learned about Relative Cell Reference and Absolute Cell Refrence in Excel. This blog will provide some practice Exercises on Absolute and Mixed Cell References.

New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.

1. Please find attached the sample dataset, it contains Courses, Fee and Early Bird discount of 10%

The value on Cell C3 (Fee after discount) is 900 and is calculated as =B3-(B3*E1).

Objective: You have to calculate C3 and autofill the remaining cells. if you get incorrect values or errors, correct the calculation on C3 and do autofill again to get the correct values as shown below.

2. Please find below sample dataset, it contains courses and Fees on specific days of the months. The courses get discounts too (Column E)

The value on Cell F2 (Net Fee 5th of Month) is 950 and is calculated as =B2-(B2*E2).

Objective: Calculate F2 and autofill this value horizontally and vertically, you will get an error. You have to fix the calculation in F2 and then autofill it horizontally and vertically to the get the correct values as shown below:

3. Please find below sample dataset, it contains Amount in dollars and conversion rate for different currencies.

The calculation in cell B4 (INR) is =A4*F2.

Objective: Autofill this calculation vertically and horizontally. If you get an error, fix the calculation in B4 and then autofill vertically and horizontally to get the correct results as shown below:

These exercises will use the concepts of absolute and mixed cell references. You can place your calculations in the comments.

Want to Improve Your Excel Skills?

Build practical Excel skills with hands-on, instructor-led training at Ohio Computer Academy. Learn Excel formulas, functions, data analysis, and more through in-person classes in Dublin, Ohio, or live online training.

Explore Our Excel Training Course

Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.