1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Artyom0805 [142]
3 years ago
13

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

rences.
Computers and Technology
1 answer:
-Dominant- [34]3 years ago
3 0

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.

You might be interested in
Implement one array of the English alphabet (26 characters). a) Create a function, getLetters() to cast and generate the array.
WARRIOR [948]

#include <fstream>

#include <iostream>

#include <iomanip>

#include <cstring>

#include <cstdlib>

using namespace std;

// Function Declarations

void display(char alphabets[],int MAX_SIZE);

void reverse(char alphabets[],int MAX_SIZE);

void swap(char &ch1,char &ch2);

int main() {

 //Declaring constant

const int MAX_SIZE=26;

 

//Declaring a char array

char alphabets[MAX_SIZE];

 

//Populating the array with alphabets

for(int i=0;i<MAX_SIZE;i++)

{

 alphabets[i]=(char)(65+i);

 }

 

 cout<<"Original: ";

 display(alphabets,MAX_SIZE);

 reverse(alphabets,MAX_SIZE);

 cout<<"Reversed: ";

 display(alphabets,MAX_SIZE);

 return 0;

}

//This function will display the array contents

void display(char alphabets[],int MAX_SIZE)

{

 for(int i=0;i<MAX_SIZE;i++)

 {

    cout<<alphabets[i]<<" ";

 }

 cout<<endl;

}

//This function will reverse the array elements

void reverse(char alphabets[],int MAX_SIZE)

{

 int first,last;

 first=0;

 last=MAX_SIZE-1;

 

 while(first<last)

 {

   

    swap(alphabets[first],alphabets[last]);

    first++;

    last--;

   

 }

}

void swap(char &ch1,char &ch2)

{

 char temp;

 temp=ch1;

 ch1=ch2;

 ch2=temp;

6 0
2 years ago
How can the Internet help our country to be a leader in technology?
BigorU [14]

Answer:

it can help in the aspect of making technologies to be fastly operated with fast internet connection there by it top among all other countries

4 0
3 years ago
Write a program that asks for the number of calories and fat grams in a food. The program should display the percentage of calor
Zigmanuir [339]

Answer:

 The solution code is written in Python 3:

  1. calories = int(input("Enter number of calories: "))
  2. fats = int(input("Enter number of fat in grams: "))
  3. if(calories > 0 and fats > 0):
  4.    cf = fats * 9
  5.    if(cf < calories):
  6.        percent = cf / calories  
  7.        if(percent < 0.3):
  8.            print("Food is low in fat")
  9.    else:
  10.        print("Error input. Calories from fat cannot more than total calories")
  11. else:
  12.    print("Error input. Calories and fats must be more than 0")

Explanation:

Firstly, use input function to ask user to enter total number of calories and fat in grams (Line 1-2)

Next we do the first input validation to check if the calories and fats are more than 0 (Line 4). If so apply formula to calculate calories from fats. If not, print error input message (Line 5, 13)

Then we proceed to next input validation to check if calories from fact more than total calories. If so, proceed to calculate percentage of calories from fats and if it is lower than 30%, display the appropriate message (Line 6 - 9). If fail the second input validation, the program will display another error input message again (Line 11)

7 0
3 years ago
Write a loop that finds the sum of the numbers between 7 and 34
Westkost [7]

THIS IS FOR PYTHON

total = 0

for i in range(7, 35):

   total += i

   print(i)

print(total)

I forgot the reason but python always stops one number before your desired value. So that's why it's 35

7 0
3 years ago
You require an algorithm that will receive an integer from the screen, add 5 to it, double it, subtract 7 from it, and display t
UNO [17]

Answer:

The algorithm is as follows:

1. Start

2. Input num

3. num = num + 5

4. num = 2 * num

5. num = num - 7

6. Print num

7. Stop

Explanation:

The first and the last line of the algorithm starts and ends the algorithm

Line 2 gets user input;

Assume user input is 9

num = 9

Line 3: adds 5 to the inputted number

num = 9 + 5 = 14

Line 4 doubles the result of line 3

num = 2 * 14 = 28

Line 5 subtracts 7 from the result of 4

num = 28 - 7 = 21

Line 6 prints the output to the screen

Hence, the output of the algorithm is 21 if the user input is 9

7 0
3 years ago
Other questions:
  • Computers heat resistant materials breathing systems for fire fighters food-growing technologies improvements in all of the item
    14·1 answer
  • What is the internet?
    5·2 answers
  • Ssume the following variables contain the values shown: numberRed = 100 numberBlue = 200 numberGreen = 300 wordRed = "Wagon" wor
    5·1 answer
  • (15 POINTS) When an error is made in HTML code, the browser does what?
    11·1 answer
  • Given the statement: int list[25]; The index can go from 0 to 25 inclusive withoutgoing beyond the end of the array.true or fals
    14·1 answer
  • 12. In cell A14, use the INDEX function and structured references to display the value in the first row and first column of the
    8·1 answer
  • Application of computer in insurance​
    14·1 answer
  • Functionality testing is primarily used with ____________. firewall protection software development hardening servers server tes
    8·1 answer
  • Why is lateral reading an important tool when reading material in social media or any online source
    15·1 answer
  • Define the terms network, LAN, WAN, and Internet.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!