Respuesta :
Answer:
formula = C2+(C2*$B$9)
Explanation:
given data
Edit the formula in cell = D2
references formula to cell = C2
reference to cell constant = B9
solution
we use here for Auto fill to copy the formula to the cell D3:D6 is express as
Auto fill to copy the formula = C2+(C2*$B$9) ..............................1
and then we will grab little square on the bottom right and drag it to D6
In this exercise we have to use excel knowledge to write the formula, so we have to:
formula = C2+(C2*$B$9)
What is Excel formulas?
Excel formulas are functions that can help users of this software to extract as much information from a spreadsheet as possible. This information can be anything from a check of an item, if it is larger than another cell, or a simple average between columns of a spreadsheet.
So from the information given in the statement, we have that:
- Edit the formula in cell = D2
- references formula to cell = C2
- reference to cell constant = B9
So writing the formula, we have:
formula = C2+(C2*$B$9)
See more about excel at brainly.com/question/14469689