Question

Need help on making these formulas !!!

4. In cell-B8, create a formula without using a function that multiplies the value.in.cell.B7. by the value-in-cell-B6-andthen adds-the-value in B7..Update.the-cell-reference to cell: B6, from a relative reference to a mixed-reference by making an absolute-reference to row.6..Copy-the-formula-from-cell-B8-to-the-range-B9:B11-and-then-copy-the-formulas. from the range-B8:B11-to-the-range-C8:H11.1

Answer 1

Question 4

View File Home Insert Page Layout Formulas Data Review Cut A A Calibri 11 Copy T A Paste B I a+ Format Painter Clipboard Font Alignment -B7*B$6 B8 A C E F G 1 2 3 4 5 6 7 40 9 200 0 10 1000 0 11 5000 0 12 13 14 15 16 (D LL st

At the end the formula should look like this in all the cells

Add-Ins File Home Insert Page Layout Formulas Data Review View Developer Cut A A Calibri 11 Wrap Text Ge Copy T в I Merge & Center Paste Format Painter Clipboard Font Alignment fiB7*B$6 в8 A В 1 2 3 4 5 6 5 7 8 B 7*B$6 8 C8*C$6 B8*B$6 9 B9*B$6 C9*C$6 10 -B10 B$6 C10*C$6 11 12 13 14 15 16 17

Question 13

Here are the formula that should appear in each of the cells

Book1 - Microsoft Excel Page Layout Developer File Home Insert Formulas Data Review View Add-Ins HP ALM Upload Add-in Acrobat Team Cut Normal A A Bad General Calibri 11 Wrap Text ECopy T в I EE Merge & Center Conditional Format Formatting as Table Paste B I U .0 .00 .000 Check Cell Expl $% KA Format Painter Clipboard Font Alignment Number fB$6-$B$5-$B$7 B13 A C D E F G H 2 4 5 5 6 8 7 B7*B$6 8 B8*B$6 C8*C$6 9 C9*C$6 =C10 C$6 B9*B$6 10 -B10*B$6 11 12 E$B$6-$B$5-$B$7-SB$6-$B$5-$B$7 $B$6-$B$5-$B$7 =$B$6-$B$5-$B$7 SB$6-$B$5-$B$7 B$6-$B$5-$B$7 $B$6-$B$5-$B$7 13 14 15 16 17 18 19 20

Here are the output when we put 5 and 8 in cells B6 and B7 respectively

File Home Insert Page Layout Formulas Data Review View Developer Add-Ins HP ALM Upload Add-in Cut A A General Calibri 11 Wrap Text Copy T в I Paste Merge & Center .0 .00 000 Con - % Format Painter Form Clipboard Font Alignment Number fi$B$6-$B$5-$B$7 B13 A В C E K L 1 2 3 4 5 6 Random Value > 5 7 Random Value 8 8 40 9 200 10 1000 11 5000 12 13 -3 -3 -3 -3 -3 14 15 16 17 18 19 L O 9 st

Question 14

Below are the formula that should appear in all the cells from B14 to H17

Book1 - Microsoft Excel Page Layout Developer File Home Insert Formulas Data Review View Add-Ins HP ALM Upload Add-in Acrobat Team ПT Cut Normal A A Wrap Text Bad General G Calibri 11 ECopy Conditional Format Formatting as Table Explanatory I EE Merge & Center Paste в IU* .0 .00 .000 Check Cell $% Format Painter Clipboard Styles Font Alignment Number fs B22 A в C D Е G Н 1 2 4 5 6 Random Value > 5 7 Random Value 8 -B7*B$6 8 =C8*C$6 B8*B$6 9 -B9*B$6 EC9*C$6 10 C10*C$6 =B10 B$6 11 12 -SB$6-$B$5-$B$7 =$B$6-$B$5-$B$7 B$6-$B$5-$B$7 $B$6-$B$5-$B$7 =$B$6-$B$5-$B$7 =SB$6-$B$5-$B$7 =$B$6-$B$5-$B$7 13 =(1+D$12)*D13 (1+D$12)*D14 (1+D$12)*D15 = (1+D$12)*D16 (1+F$12) F13 (1+F$12)*F14 =(1+F$12)*F15 (1+F$12) "F16 (1+G$12)*G13 =(1+G$12) G14 (1+G$12) G15 (1+G$12)*G16 (1+B$12)*B13 (1+B$12)"B14 = 1+B$12)*B15 E(1+B$12)*B16 |(1+C$12)*C13 =(1+C$12)*C14 =(1+C$12)*C15 =(1+C$12)*C16 (1+E$12)*E13 =(1+E$12)*E14 =(1+E$12)*E15 (1+E$12)*E16 |(1+H$12)*H13 =(1+H$12)*H14 (1+H$12)*H15 (1+H$12)*H16 14 15 16 17 18 19 20 21 22

Here is the output for some random value in cell B12 as 3

File Home Insert Page Layout Formulas Data Review View Developer Add-Ins Cut A A Calibri 11 Wrap Text Gen Copy в I Merge & Center Paste Format Painter Clipboard Font Alignment (1+B$12)*B16 B17 A В C E 1 2 3 4 5 6 Random Value > 5 7 Random Value 8 40 9 200 10 1000 11 5000 12 Random Value 3 13 -3 -3 -3 -3 -3 -3 -3 14 -12 -3 3 3 -3 -3 -3 15 -48 -3 -3 -3 -3 -3 -3 16 -192 -3 -3 3 -3 -3 -3 -768 17 -3 -3 -3 -3 -3 -3 18 19 20 L O CO st