Use the YEARFRAC function to work out how many years difference is there between the date 1980-07-31 (31 July 1980) and 1998-05-02 (2 May 1998) (to 1 decimal place)?

Answers

Answer 1

Answer: 17.7 Years

Explanation:

YEARFRAC is a function in Microsoft Excel that returns the year fraction representing the number of whole days between a particular start date and an end date.

A typical view of the function is:

=YEARFRAC(start_date, end_date, [basis])

All that needs to be done is

1. Type in the equal to sign(=) in the cell you want your answer,

2. Type in YEARFRAC and open your bracket,

3. Input your start date and end date, close your bracket and press enter.


Related Questions

Write a Python 3 program to read from a .csv file containing rates from power companies. Your program should determine the average commercial rate, and also display the information for the highest and lowest rates found.

Answers

Answer:

In python:

file = open("rates.csv", "r")

ratecount = 0

ratesum = 0

mylist = []

rates = file.readlines()

for nums in rates:

     num = nums.rstrip('\n')

     mylist.append(int(num))

     for i in num:

           ratesum= ratesum + int(i)

           ratecount = ratecount + 1

print("Maximum Rate: "+str(max(mylist)))

print("Minimum Rate: "+str(min(mylist)))

print("Average Rate: "+str(ratesum/ratecount))

Explanation:

This opens the csv file

file = open("rates.csv", "r")

This initializes the number of rates in the file

ratecount = 0

This initializes the sum of the rates

ratesum = 0

This initializes an empty list

mylist = []

This reads the rates into lines

rates = file.readlines()

This iterates through the rates (as a string)

for nums in rates:

This removes the newline character \n in the rates

     num = nums.rstrip('\n')

This appends the rates (as an integer) to the empty list

     mylist.append(int(num))

The following counts the rates in the file and also sum them up

     for i in num:

           ratesum= ratesum + int(i)

           ratecount = ratecount + 1

This prints the maximum of the rates

print("Maximum Rate: "+str(max(mylist)))

This prints the minimum of the rates

print("Minimum Rate: "+str(min(mylist)))

This calculates and prints the average rate

print("Average Rate: "+str(ratesum/ratecount))

You decide to store data in the user's browser in order to reduce the amount of data that must be downloaded. What is this process called

Answers

Answer:

client-side storage

Explanation:

The process of doing this is known as client-side storage. Like the name suggests this saves data that is sent to the user's computer on that computer either as cookies or cached data. This data is then used every time that the user decides to enter the same website or access the same program from the browser. Doing this allows these websites and programs to load much faster the more times that the user decides to enter them.

Do these devices allow you to view photos using the cloud?

Please help I'll give 30 points QUICK!

Answers

Answer:

Yes, You can view the cloud on those devices

Answer: C is it

Explanation:

Recently, your company's file server was the victim of a hacker attack. After researching the attack, you discover that multiple computers were used to implement the attack, which eventually caused the file server to overload. Which attack occurred

Answers

Answer:

Denial of Service attack

Explanation:

Denial of service is a type of attack on computer systems in which a particular system is targeted and flooded with traffic from multiple systems, thus causing an overload of the attacked system, and an eventual crash. The aim of the perpetrators of this attack is to prevent the rightful owners of the system from gaining access to it.

The above described attack is a Denial of service attack because;

1. the attack came from multiple computers

2. the attacked server experienced an overload most likely caused because it was overwhelmed with traffic.

How do the interests of carriers differ from the interests of websites? What are the implications for websites from a value chain perspective?

Answers

Answer:

Explained below.

Explanation:

- The interest of the carriers has it's major focus on the process of getting funds from both individual customers and corporate entities that run the websites. However, the interest of websites’ has it's major focus on the process of generating funds in form of subscriptions or funds gotten from paid adverts from both individual customers and corporate entities.

- In terms of value chain perspectives; the websites experience far more pressure to keep fresh and exciting features and services on their platform while carriers don't experience that but only experience having to compete with innovations being done by their existing competitors to remain leaders in the field.

Complete the static method yearsToVote, which returns a String displaying the number of years a person has been able to vote or the number of years they have to wait to vote (the voting age is 18). The age is passed in as an argument.
public static String yearsToVote (int age) {
** Complete the code **
}

Answers

Answer:

Following are the code to this question:

public class Main//defining a class  

{

   public static String yearsToVote(int age)//defining a method yearsToVote that holds an integer variable as a parameter  

   {

       String s;//defining a String variable

       int a;//defining a integer variable

       if(age<18)//defining if block to check age  

       {  

           a=18-age;//calculating the age value  

           s="The Person has to wait "+a+ " more years before they can vote";//print string value with age  

       }

       else//defining else variable  

       {

           a=age-18;//calculating age value

           s="Since last " +a+" years person has been abel to vote ";//print string value with age  

       }

           return s; // return String value

   }

public static void main(String[] args)//defining a mein method  

{

    int age=22;//defining an integer variable with value

    System.out.println(yearsToVote(22));//use print method to call static method  

}

}

Output:

Since last 4 years person has been abel to vote  

Explanation:

In this code, a static method "yearsToVote" is declared that accepts an integer variable "age" in its parameter, and defined one string and one integer variable, and use if block to check value and return string value with a message.

In the next step, the main method is declared, which defines an integer variable and holds its value and passes into the method "yearsToVote" use the print method to call and print its value.  

Johnny uses Excel to check his ________ homework.

Answers

Answer:

Math

Explanation:

There are a number of roles held by various users of online digital media, including contributors, conversationalists,
critics, organizers, spectators, and joiners. Often, people who have a strong presence online will hold two or more roles.
Describe at least three of these roles. Of the roles you described, why might someone act on two of them at the same
time? That is, what kind of online activity would result in a person taking on those two roles?

Answers

Answer:

The mass media is a huge phenomenon. Through the various different platforms, print or broadcast, the media is able to reach millions of people like no other force. Without the media, powerful speeches by politicians would affect no one, local events would remain local, and performances by great actors would be seen only by the people in the immediate audience. The media overcomes distances, and builds a direct relationship with the audience. Many sociologist

The answer above should be correct !!
I hope she/he helps !

Explanation:

What are some other features of sending attachments in Outlook 2016? Check all that apply.
A file is something from outside of Outlook, such as Word or PowerPoint.
An Outlook item, such as a calendar, can be attached to an email.
An attachment reminder will pop up every time you send the message.
O A cloud-based file is shared by including a link to it in the message body.

Answers

Answer:

A B D

Explanation:

Answer:

the answers are B , B , and A

Explanation:

Which of the following is a sample IPv4 address?
99.14.242.51
99.14.342.51
99.14.242.51.21
002:0de6:0001:0042:0100

Answers

Answer:

The first one, 99.14.242.51 is the only valid IPv4 address listed.

Explanation:

An IPv4 address is formatted as four eight-bit numbers separated by decimals. This means that a valid one will have four numbers from 0 to 255, with decimals in between.

The first one, 99.14.242.51 is a valid IPv4 address.

The second one has the number 342, which is greater than eight bits.

The third one has five octets.

The fourth one is in the wrong format altogether, using what appear to be 32-bit numbers

Ranboo back story? (not homework i just wanna find some ppl who are interested in the same things) ft. the reddie meme

Answers

Answer:

i like meme very much

Explanation:

mark as brainliest please

Answer:

ranboo backstory poggg

Explanation:

idrk his back story im pretty sure he forgot most of it anyways

also known as user generated content (UGC). It refers to a variety of media content that is produced by

Individuals or a group of people working in collaboration. It is also referred to as consumer generated media (CGM) or

user created content (UCC).

Prosumerism

Creationism

Productionism

Consumerism

Answers

Answer: Prosumerism

Explanation:

Prosumerism is a portmanteau of the words, producer and consumerism. As the term infers, it is the use of customers in the production process with the logic being that customers know what they want so should be given a chance to help in creating it.

This is why companies have increasingly started using user generated content that is produced by consumers who are working individually or in a group. These will help the company in producing a viable product for the market.

Other Questions
What is the if v = 50 m/s and = 10 m? Rewrite the decimal as a simple fraction in lowest terms. 0.005 can someone help me? A car with a mass of 1000 kg crashes into a wall. The acceleration before the crash was 5 m/s2. What is the force m=p/n+4 make n the subject At the start of the napkin aisle, you seea list of the different package options,shown in the table below.Are the price of napkins and thenumber of napkins in each packageproportional to each other? Why orwhy not? 2. What is one aspect of your life that you think could benefit from more creative thinking? Why?3. What is one thing you can do to think more creatively or incorporate creative ideas into your artwork? Change to the Past Continuous From.1. They chose their new hats...................................................... Information For The Question:Maya makes trail mix by combining 1\4 cup of mixed nuts, 1\3 cup of dried fruit, and 1\6 cup of chocolate morsels. Question:What is the total amount of ingredients in her trail mix using 12 as the Denominator? Solve the system using the substitution method.2x+y=7x=3yDemonstrate how you substituted to write an equation in one variable. Calculate the mass of water produced when 1.43 g of butane reacts with excess oxygen. Express your answer to three significant figures and include the appropriate units. g The rope that can fence out the square garden of length 250m can fence another circular garden twice. What is the area and perimeter of the circular garden?(Wrong answers will be reported) Factor the expression completely. 5x + 4.0 Help fast!! Choose the number line that represents the fraction equivalent to three-twelfths.A number line with zero, one twelfth, two twelfths, three twelfths, four twelfths, five twelfths, six twelfths, seven twelfths, eight twelfths, nine twelfths, ten twelfths, eleven twelfths, and one marked on it. A red line is drawn from the zero tick mark to the three twelfths tick mark.Question 5 options:A number line with zero, one eighth, two eighths, three eighths, four eighths, five eighths, six eighths, seven eighths, and one marked on it. A red line is drawn from the zero tick mark to the three eighths tick mark.A number line with zero, one fourth, two fourths, three fourths, and one marked on it. A red line is drawn from the zero tick mark to the one fourth tick mark.A number line with zero, one fifth, two fifths, three fifths, four fifths, and one marked on it. A red line is drawn from the zero tick mark to the one fifth tick mark.A number line with zero, one sixth, two sixths, three sixths, four sixths, five sixths, and one marked on it. A red line is drawn from the zero tick mark to the one sixth tick mark. What is the number of possible outcomes when a coin is tossed one time 43 (2 3 +4 2 )=start fraction, 3, divided by, 4, end fraction, left parenthesis, 2, cubed, plus, 4, squared, right parenthesis, equals Examine the map of North American physical regions.Which physical region is found in all three countries of North America?A. Great PlainsB. Interior LowlandsC. Basin and Range D. Appalachian Mountains What would the missing coordinate be if there was an inverse relationship between points (12,3) and (x,9) solve for o 9=5+o i need this for math like asap IL GIVE BRAINLIEST AND MOREEE HELP