Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are trying to calculate forecast gross profits for the next 12 months based on forecast sales figures and a fixed profit margin. The forecast
You are trying to calculate forecast gross profits for the next 12 months based on forecast sales figures and a fixed profit margin. The forecast sales figures are in cells B6 to M6 and the profit margin percentage is in cell B2. If you wish to enter a formula in cell B8 that can be copied across to M8 to give the gross profit for each month, which of the following formulae would be unsuitable?
A) "=$B$2*B6"
B) "=B$2*B6"
C)"=$B2*B$6"
D)"=$B$2*B$6"
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started