- B 0 E F F G H K 9 A B C D 3 Rate 9 4 Periods 5 5 Pv Factor 3 8897 6 7 Periods 8 1 2 3 9 1 0 9901 0 9804 0 9709 10 2 1 (84.58 KiB) Viewed 22 times
B 0 E F F G H K 9 A B C D 3 rate 9% 4 periods 5 5 PV factor 3.8897 6 7 periods 8 1% 2% 3% 9 1 0.9901 0.9804 0.9709 10 2
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
B 0 E F F G H K 9 A B C D 3 rate 9% 4 periods 5 5 PV factor 3.8897 6 7 periods 8 1% 2% 3% 9 1 0.9901 0.9804 0.9709 10 2
B 0 E F F G H K 9 A B C D 3 rate 9% 4 periods 5 5 PV factor 3.8897 6 7 periods 8 1% 2% 3% 9 1 0.9901 0.9804 0.9709 10 2 1.9704 1.9416 1.9135 11 3 2.9410 2.8839 2.8286 4 3.9020 3.8077 3.7171 13 5 4.8534 4.71354.5797 14 6 5.7955 5.6014 5.4172 15 7 6.7282 6.4720 6.2303 16 8 7.6517 7.3255 7.0197 17 98.5660 8.1622 7.7861 18 10 9.4713 8.9826 8.5302 19 20 4% 0.9615 1.8861 2.7751 3.6299 4.4518 5.2421 6.0021 6.7327 7.4353 8.1109 12 5% 0.9524 1.8594 2.7232 3.5460 4.3295 5.0757 5.7864 6.4632 7.1078 7.7217 6% 0.9434 1.8334 2.6730 3.4651 4.2124 49173 5.5824 7% 0.9346 1.8080 2.6243 3.3872 4.1002 4.7665 5.3893 5.9713 6.5152 7.0236 8% 0.9259 1.7833 2.5771 3.3121 3.9927 4.6229 5.2064 5.7466 6.2469 6.7101 9% 0.9174 1.7591 2.5313 3.2397 3.8897 4.4859 5.0330 5.5348 5.9952 6.4177 10% 0.9091 1.7355 2.4869 3.1699 3.7908 4.3553 4.8684 5.33491 5.7590 6.1446 6.2098 6.8017 7.3601 In order to create the above table using "DATA TABLE", which of the following is correct? O A8 is the Header cell (aka Formula cell) O A1:A18 is the Column input cell O B3 is the Header cell (aka Formula cell) O B4 is the Row input cell O A4 is the Column input cell