Question

File Home Insert Draw Page Layout Formulas Data Review View Help 1 BO Calibri Conditional Formatting LDB I VA A - Number 2 Format as Table Cells Paste lille 1921 Cell Styles Clipboard Font Alignment Styles A6 X for 1 A B C D G H I 1 1 K L M N Calculate all 9 of the monthly fixed rate mortgage payments in the blue cells of the table below. The mortgage amount is shown in cell B11. The values in cells B7:19 are years, and the values in cells C6 E6 are annual interest rates. To complete the table you need to use the F4 key for absolute cell referencing as was instructed in the YouTube video. Format your answers as currency, and show the cents. 2 5.00% 5.50% 6.00% ocFNM $160,000

I really do not know how to do this exercise, please explain me with details how to do it and how to use the f4

Answer 1

Please find the snap of how F4 key works for selecting absolute cells while doing calculation of with multiple value in cells.

F4 Key can be use at any Cell number just Rate by taking Cursor at that Cell Number or Alphabet to give absolute effect 0.05 0.055 0.06 10 =+$B$11*$C$5/$B$6 ==$B$11*$D$5/$B$6 =+$B$11*$E$5/$B$6 Year 20 =+$B$11*$C$5/$B$7 =+$B$11*$D$5/$B$7 =+$B$11*$E$5/$B$7 =+$B$11*$C$5/$B$8 ==$B$11*$D$5/$B$8 =+$B$11*$E$5/$B$8 All formulas can be checked with the help of Ctrl + Key (Which is available at the bottom og Esc Key. 160000 30