All categories

2 years ago

You manage the worksheet shown below and it contains information for the company's 1500 employees,

2 answers:

5 0

The best way for you to create the list of those who make more than $45000 a year and are full time is by using the filter option.

The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 45000.

The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.

The sorting method helps to arrange data based on ascending order or descending order.

kvv77 [185]2 years ago

3 0

Answer:

Explanation:

You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year.

You might be interested in

Mike and David signed a loan agreement together to borrow money for a boat. If David leaves town and cannot be found, what happe

iren [92.7K]

I this case, the loan is still valid and at that point Mike would be responsible for finding a way to pay the loan back as agreed upon in the contract. This is called co-signing, when two parties both sign for a loan together. Both parties are responsible for the loan and even though David cannot be found, the loan must still be paid and Mike would be held responsible for this.

4 0

3 years ago

Read 2 more answers

The treasurer of a major U.S. firm has $40 million to invest for three months. The interest rate in the United States is .28 per

diamong [38]

Answer:

Check the explanation as follows.

Explanation:

a) If it is invested in US

Current= $40 million

Interest rate= 0.28% p.m

Interest for 1 month= $40 million*0.28%= $0.112 million

Interest for 3 months= $0.112*3= $0.336 million

Total value after 3 months= $40 million+$0.336 million = $40336000.

b) If it is invested in Great Britain.

Convert $40 million into Pounds= $40 million*0.639 = Pound 25.56 million

Ivest in Great Britain for 3 months @ 0.32%

Interest per month= 25.56 million*0.32% *3 = 0.245376

Total Pounds after 3 months= Pound 25.805376

Convert into $= 25.805376/0.642 = $40195289.7156

Value if invested in great britain= $40195289.7156

8 0

2 years ago

Channel members can help producers by identifying customer complaints, customer preferences, and new competitors in the market.

butalik [34]

Answer:

communication

Explanation:

communication function of channel intermediaries.

Channel intermediaries are responsible for making sure that the product is available at the appropriate quantities, at the right time and place for end user consumption. They also serve as a means of communication between the consumer and producer concerning such issues as product quality.

5 0

2 years ago

Many people who want to start investing for their future want to start today, which implies an annuity stream that is paid at th

navik [9.2K]

Answer:

b. annuities due

Explanation:

Annuities due -

It refers to the amount which need to be paid at the regular interval of time , just before the beginning of the new phase , is referred to as annuities due .

The most common example of annuities due is rent , which need to be paid after every month in the starting .

Hence , from the given information of the question ,

The correct option is annuities due.

4 0

3 years ago

lucy invests $800 in an account that earns 6.12% annual interest compounded continuously. juan invests $1600 in an account that

Len [333]

Answer:

Both their investments will reach a similar value in 32 years, 9 months and 8 days. Both accounts will have exactly $5,606.

Explanation:

Original investment: $800 at 6.12% $1,600 at 3.9%

future value 10 years $1,449 $2,346

future value 20 years $2,624 $3,439

future value 30 years $4,753 $5,042

future value 31 years $5,044 $5,238

future value 32 years $5,353 $5,442

future value 33 years $5,681 $5,655

It will take over 32 years for both investments to match their amounts.

to determine the approximate month we start with the future value in 32 years:

$5,353 $5,442

future value in 6 months $5,517 $5,548

future value in 9 months $5,599 $5,601

future value in 9 months

and 5 days $5,603 $5,604

future value in 9 months

and 8 days $5,606 $5,606

7 0

3 years ago