daisyramirez7772 daisyramirez7772
  • 12-09-2018
  • Computers and Technology
contestada

Insert a function in cell g5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references.

Respuesta :

hancesoome
hancesoome hancesoome
  • 22-09-2018

I guess the correct answer is =PMT($B$22,12,-E5)

By dеfault, all cеll rеfеrеncеs arе rеlativе rеfеrеncеs. Whеn cοpiеd acrοss multiplе cеlls, thеy changе basеd οn thе rеlativе pοsitiοn οf rοws and cοlumns. Fοr еxamplе, if yοu cοpy thе fοrmula =A1+B1 frοm rοw 1 tο rοw 2, thе fοrmula will bеcοmе =A2+B2. Rеlativе rеfеrеncеs arе еspеcially cοnvеniеnt whеnеvеr yοu nееd tο rеpеat thе samе calculatiοn acrοss multiplе rοws οr cοlumns.

Answer Link

Otras preguntas

A reference to something historical, religious or popular
To build a new skate park, a community board must have at least 40% of the voters agree to the build. At a recent voters meeting, 125 voters were asked if they
What number is composed of 3 ones,24 tenths,55 thousandths and 117 thousandths
Can someone help me pleaseeeeee
Analyze and Interpret Data 1. Identify the range of pH values and temperatures used in the experiment
Square Inches 4 9 20 UNKNOWN PAINTING 30 Number of Strokes 15 35 79 119​
Who developed the expression for the line spectrum of hydrogen to include lines in the ultraviolet and infrared portions of the electromagnetic spectrum?.
Find the values of p and q if x-1 is a common factor of f(x)=x⁴-px³ +7qx+1, and g(x)=x²-4x² + px² +qx-3,​
could i get another hand please:)
HELPPP PLLZZZZ 54 ÷ 9 = 6, therefore 54 ÷ 0.9 = 0.6. True False