Which formula should you use? The sales tax rate is in cell H2. Sales - ProProfs Discuss
Topics-
Products +
     

Which formula should you use? The sales tax rate is in cell H2. Sales totals are in cells B2: B20. To calculate the tax on each sale, you'll enter a formula in cell C2, to multiply the sales total in B2, by the sales tax rate. Then, you'll copy the formula down to cell B20.





A. =B2*$H$2
B. =$B$2*$H$2
C. =B$2*$H$2
D. =B2*H2
E. =B2*$H2

This question is part of Excel Basics
Asked by Ddalgleish, Last updated: Jan 16, 2019

+ AnswerRequest Answer
...

2 Answers

C. Kenway

C. KenwayContent Writer, Jacksonville
Content Writer, Jacksonville

Answered on Apr 09, 2019

The correct answer is option B
Dollar sign is often used in Excel to make a row or column absolute. It is used for absolute cell referencing, which tells Excel that you want to always refer to a particular cell even when yo copy the formula across other rows and columns.

The row or column that comes after the dollar sign is anchored or absolute.
All Excel formulas start with an “equal to” (=) sign. To calculate the tax on each sale, you need to multiply B2 and H2.
Hope this helps.

 Reply

John Smith

John Smith

Answered on Jan 17, 2017

=b2$h$2
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.