Assume that cell F5 to F10 In a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the va
lue of 5%.Write a formula that will be used to increase the value stored in the cell F5 by 5%?
1 answer:
Answer:
=F5*$F$12+F5
Explanation:
If we want to increment the salaries in the cell F5, we must multiply the cell F5 by cell F12, and then we must sum that result.
If we want to drag the formula from the cell F5 to F10, we must use the dollar symbol $ to apply the same percent in our formula.
For example:
F12 = 5% = 0.05
F5 = 10,000
=F5*$F$12+F5
=10,000×0.05+10,000 = 10,500
You might be interested in
Session Initiation Protocol, brainliest ?
Answer:
Debevec is using the light of his team because this and that and because it’s manipulated
Explanation:
The keywords used in programming languages that use decisions to redirect the flow of a program are called control structures.
Answer:
a) 0.843 years
b) 1.785 years
Explanation:
See attached pictures for detailed explanation.