Exercise to learn how to use the Dollar Sign in Excel

In this beginner Excel exercise, you'll learn how to use the dollar sign ($) in formulas. Here’s what you’ll do:

• Discover how the dollar sign locks cell references in formulas.
• Practice using absolute, relative, and mixed cell references.
• Understand why locking cells is essential when copying formulas.

How do you complete this exercise?

The exercise guides you through a series of questions designed to deepen your understanding of the dollar sign’s purpose in formulas.

• You’ll apply it to different scenarios, such as calculating totals with fixed values and replicating these calculations across multiple rows and columns.
• By answering questions, you’ll explore how to choose the correct reference type—absolute, relative, or mixed—depending on the situation.
• This hands-on approach ensures you grasp when and why to use the dollar sign, helping you build confidence in applying it to various tasks.

Click on the following button to start the training about the dollar sign in Excel

 

Start

1. Which formula to write in D4 to calculate the Total without tax?

=B4/C4

=B4-C4

=B4*C4

=B4+C4

Question 1 of 8

2. What is the formula to put in D10 to calculate the sum of the purchases?

 

=SUM(D4+D9)

=D4:D9

=SUM(D4:D9)

=SUM(D4;D9)

Question 2 of 8

3. Which formula to write in E4 to calculate the amount of tax that is obtained with the tax value and the price?

=D4*(1+E1)

=D4*E1

=D4*15%

=3*15%

Question 3 of 8

4. To block the reference of cell D1, we must add 2 $ symbols around the reference.

How to easily add dollars to a cell reference?

Select the cell and press F4

Select the cell and press $

Select the cell and press F6

Select the cell and press %

Question 4 of 8

5. What is the formula to calculate the price including taxes?

=D4+E4

=D4+E4*E1

=D4*E4

=D4:E4

Question 5 of 8

6. Now, how to write the formula to calculate the price with tax, only with the price without tax (column D) and the percentage of tax (cell E1)?

=D4*$E$1

=D4+$E$1*1

=D4*$E$1+D4

=D4*D4*$E$1

Question 6 of 8

7. Which technique copies only the formula and not the formatting?

 

 

Paste Special > Values and Number Formats

Paste Special > Addition

Paste Special > Formula

Paste Special > Formatting

Question 7 of 8

8. How do you transform the result in the Total including the tax to round up to the next ten cents?

=ROUNDUP(SUM(F4:F9),1)

=INT(SUM(F4:F9))

=ROUND(SUM(F4:F9),1)

=ROUND(SUM(F4:F9))

Question 8 of 8

 Loading...

 

Other Exercises

• Beginner Excel Exercise: Mastering Basic Calculations
• Learn how to use the Dollars in an Excel formula
• Excel Training – Calculate the weekly profit

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!