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
omeli [17]
4 years ago
8

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2022 faciliti

es loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.
Computers and Technology
1 answer:
ycow [4]4 years ago
3 0

Answer:

Microsoft Excel, pmt function.

Explanation:

Microsoft Excel is a spreadsheet application used to manipulate and analyse data. It has several functions and tools to work with. An excel workbook can contain multiple worksheets. It has columns (or field) labelled alphabetically and also numbered rows ( or record).

The PMT function is a financial function used to calculate the periodic payment of loans. It's syntax is;

=PMT(interest rate increase, loan period, loan amount).

For example, if the interest rate increase is annual, and the value is a cell B7, the input would be B7/12. If the value of the loan period and amount are referenced in cells B6 and B5 respectively, the function would be ;

=PMT(B7/12, B6, B5).

But this will give a negative result. For positive result;

=PMT(B7/12, B6, -B5)

Now to make excel pick values from a specified group of cells, they are made absolute by adding the '$' to the columns and rows.

=PMT($B$7/12, $B$6, -$B$5).

The result would positive values spanning to twelve months with interest rate.

You might be interested in
43
pshichka [43]

Answer:

c

Explanation:

5 0
2 years ago
Read 2 more answers
PYTHON
Korvikt [17]

Answer:

import random

print("Hello! I have a random number from 1 to 100! It is your job to try and guess it!")

number = random.randint(1,101)

guess = int(input("start to guess: "))

num_guesses = 1

while guess != number:

   if guess > number:

       print("lower")

       guess = int(input("try again: "))

       num_guesses +=1

   elif guess < number:

       print ("higher")

       guess = int(input("start to guess: "))

       num_guesses +=1

print("congrats it took you", num_guesses, "tries")

Explanation:

6 0
3 years ago
Write a function named repeat_words that takes two string parameters: 1. in_file: the name of an input file that exists before r
madam [21]

Answer:

#section 1

def repeat_words(firstFile, secondFile):

   infile_1=open(firstFile,'r')

   content1=infile_1.read()

   infile_1.close()

#section 2

   import string

   newContent=""

   for char in content1:

       newContent+=char.strip(string.punctuation)

   newContent=newContent.lower()

   newContent=newContent.split()

#section 3

   repeated_list=[]

   for word in newContent:

       if newContent.count(word)>1:

           repeated_list.append(word)

#section 4

   new_repeat_list=[]

   for item in repeated_list:

      while item not in new_repeat_list:

         new_repeat_list.append(item)

#section 5

   outfile=open(secondFile,'w')

   for repeat in new_repeat_list:

       outfile.write(repeat)

       outfile.write('\n')

   outfile.close()

   infile_2=open(secondFile,'r')

   content2=secondFile.read()

   infile_2.close()

   return content2

# section 6

in_file = 'aa.txt'

out_file = 'cpu.txt'

print(repeat_words(in_file, out_file))

Explanation:

#section 1

it defines a function that takes two arguments. It opens the first argument in the read mode and stores all it's content in a string variable "content1". finally the file is closed.

#section 2

In this section the string module is imported which allows for easy manipulation of string variables.

A new string variable is created that would store the already stripped file.

<em>strip(string.punctuation)  </em>strips every character of any leading or trialing punctuation.

<em>lower()  </em>converts string to lover case.

<em>split() </em>converts a string to an array of sub-string, i.e an array of words.

#section 3

This section collects all the words in the array and places them in a list.

#section 4

Utilizes a For and a While loop to ensure that no word repeats and stores it in a new list.

#section 5

Opens a new file and writes all the content into that new file and then closes the file.

re-opens the file, reads and returns the content of the file.

# section 6

This is added in order to test the function and print the result

I used your question to test the function and attached the result.

cheers!

8 0
3 years ago
Assume that there is a class called BankAccountHolder that represents an individual member of a bank. There is also a BankAccoun
Elina [12.6K]

Answer:

Aggregation

Explanation:

In Java, Aggregation is a relationshipthat exists between two classes that is best described as a "has-a"

7 0
4 years ago
Read 2 more answers
When you first start your computer, which software will have to start first?
erastovalidia [21]
The BIOS will have to start first to determine the boot order and location.
7 0
3 years ago
Read 2 more answers
Other questions:
  • Why was the movable type of the printing press such a breakthrough for publishing?
    15·2 answers
  • In the early days of photography, cameras were limited to professional photographers because of the knowledge needed to work the
    15·2 answers
  • What computing platform was designed to help a beginner create interactive objects that receive input from sensors and use that
    11·1 answer
  • Which of the following information would best be displayed throughout the use of a time line
    11·1 answer
  • In what software development model does activity progress in a lock-step sequential process where no phase begins until the prev
    7·1 answer
  • Good ways to increase sales on phone accesories?
    10·2 answers
  • Define a method pyramidVolume with double parameters baseLength, baseWidth, and pyramidHeight, that returns as a double the volu
    8·1 answer
  • Haya would like to complemely delete Slide 11 from her presentation so that slides 12–16 become slides 11-15. What is
    9·1 answer
  • Reesa works for a large real estate company. She is responsible for installing and supporting the company's internet systems, in
    5·1 answer
  • Do you need to have java on your computer.
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!