All categories

2 years ago

Learner ID: 6. Explain the reason behind adding borders to cells in a spreadsheet.

Business

1 answer:

Alina [70]2 years ago

7 0

Explanation:

Adding cell borders and filling cells with colors and patterns is an easy way to make your data stand out, appear more organized, and make the spreadsheet easier to read.

You might be interested in

:How is a ‘provision for reserve’ in a balance sheet, a liability or an asset. Explain.

Maslowich

Explanation:

A provision is indeed an item freed up from either a company's revenue to cover potential future costs or a probable property price decrease. It shows up as spending on the financial statements and is documented as a current liabilities.

3 0

2 years ago

You found your dream vacation cottage in the mountains and your offer of $78,000 was accepted. You plan to put 20% down and will

zepelin [54]

Answer:

financing 62,400 dollars

Monthly Payment $ 465.48

Total Interest 21,386.4

Rounding to nearest $ 100

Additional $$ 34.52

We save up to 16 payments and $2,136.4 in interest.

By-weekly payment $232.60

Total Interest saved $ 194.4

Explanation:

78,000 less 20% down-payment: 62,400

Monthly Payment

$PV \div \frac{1-(1+r)^{-time} }{rate} = C\\$

PV $62,400.00

time 180

rate 0.0034375

$62400 \div \frac{1-(1+0.0034375)^{-180} }{0.0034375} = C\\$

C $ 465.484

Total Interest

quota times time less principal

$ 465.48 x 180 - 62,400 = 21,386.4

$ 500 - $ 465.48 = $ 34.52

$C \times \frac{1-(1+r)^{-time} }{rate} = PV\\$

C $500.00

time n

rate 0.0034375

PV $62,400.0000

$500 \times \frac{1-(1+0.0034375)^{-n} }{0.0034375} = 62400\\$

$(1+0.0034375)^{-n}= 1-\frac{62400\times0.0034375}{500}$

$(1+0.0034375)^{-n}= 0.571$

We now use logaritmics properties to solve for n

$-n= \frac{log0.571}{log(1+0.0034375)$

-163.2956066

180 - 164 = 16 payments

Total Interst 500 x 163.30 - 62,400 = 19,250

Interest savings 21,386.4 - 19,250 = 2,136.4

If payment are bi-weekly:

then payments will be:

$PV \div \frac{1-(1+r)^{-time} }{rate} = C\\$

PV $62,400.00

time 360

rate 0.00171875

$62400 \div \frac{1-(1+0.00171875)^{-360} }{0.00171875} = C\\$

C $ 232.598

And total Interest:

232.2 x 360 - 62,400 = 21,192

Difference 21,386.4 - 21,192 = $ 194.4

6 0

3 years ago

You're attempting to determine the amount of usable floor space in your day care facility. Which one of the following areas can

Serjik [45]

I believe the answer is d. I hope it was right and I helped!

4 0

3 years ago

Workers at a company were assigned to one of two conditions: one group completed a stress management-training program; another g

Sergeu [11.5K]

answer:

Independent Variable: Group that completed the stress management training vs. Group that had no training)

Dependent Variable: Number of sick days

Explanation:

The dependent variables also called Predicated variable is a type of variable that depends on the independent variable which happens as a result of the circumstances surrounding the independent during an experimental investigations. it also predicts the outcome resulting from altering the controlled variable. for example in the question, the dependent variable is Number of sick days

The independent variable is the variable the which can be changed or controlled during an experimental investigation which dependent variable relies on directly. for example from the question, the independent variable is the Group- (Group that completed the stress management training vs. Group that had no training)

8 0

3 years ago

Suppose that in 1984 the total output in a single good economy was 12,000 buckets of chicken. Also assume that in 1984 each buck

xxMikexx [17]

Answer:

The GDP price index for 1984 using 2005 as the base year was 80%

Explanation:

The GDP price index:

X/100 = $16/$20

X = 80%

Therefore, The GDP price index for 1984 using 2005 as the base year was 80%

6 0

2 years ago