Ask Question

Assume that cell F5 to F10 In a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the value of 5%. Write a formula that will be used to increase the value stored in the cell F5 by 5%?

+3
Answers (1)
  1. 31 December, 05:02
    0
    =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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Assume that cell F5 to F10 In a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the value of 5%. ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers