All categories

3 years ago

Provide an example of how businesses might apply a conditional formula to spreadsheet data

1 answer:

3 0

A business might apply conditional formula to calculate the payouts for the different employees of the organisation.

<u>Explanation:</u>

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. This helps you to differentiate and make difference between the values to be put in the different cells depending on the criteria.

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

You might be interested in

Rory is the CFO of McIlroy Golf Designs Inc. MGDI earned $13 million last year and maintains a 30% dividend payout ratio. The co

BaLLatris [955]

Answer:

<u>Price per share of MGDI's stock is $78</u>

Explanation:

Earnings per share=Total earnings/Shares of common stock outstanding

=(13/2)=$6.5

PE ratio=Stock price/Earnings per share

Stock price=$6.5*12

=$78.

5 0

3 years ago

Automobiles are often leased, and there are several terms unique to auto leases. Suppose you are considering leasing a car. The

kotegsom [21]

Answer:

a. 6.36%

b. $378.02

Explanation:

a. The computation of Annual percentage rate is shown below:-

Annual percentage rate = Lease factor × 2,400

= 0.00265 × 2,400

= 6.36%

b. For computation of monthly lease payment first we need to find out the depreciation charge, finance charge and tax which is shown below:-

Depreciation charge = (Base cost + Other cost - Down payment - Residual value) ÷ Number of lease payment

= ($27,600 + $1,050 - $3,000 - $17,000) ÷ 36

= $8,650 ÷ 36

= $240.27

Finance charge = (Base cost + Other cost - Down payment - Residual value) × Lease factor

= ($27,600 + $1,050 - $3,000 - $17,000) × 0.00265

= $42,650 × 0.00265

= $113.0225

now,

Tax = (Depreciation charge + Finance charge) × Tax rate

= ($240.27 + $113.0225) × 7%

= $353.2925 × 7%

= $24.73

Monthly Lease payment = Depreciation charge + Finance charge + Tax

= $240.27 + $113.0225 + $24.73

= $378.02

3 0

3 years ago

Business incubators are a time honored tradition and have been around since the early 1700s. True or false?

Shkiper50 [21]

<span>Business incubators are a time honored tradition and have been around since the early 1700s.
</span>
Ans: its true

3 0

3 years ago

In Business studies. what the business owes the other is called what

goldenfox [79]

Answer:assets

Explanation:

7 0

2 years ago

Read 2 more answers

Mr.Akhil (55 years) paid mediclaim for self and family Rs.40,000 and for parents (80 years) Rs.60,000. What will be the deductio

Dominik [7]

In order to claim the deduction under Section 80D, the expenditure needs to be made in any means other than cash. Although the expenditure on preventive health check-ups is allowed to be incurred in cash. The deduction for the following expenses are available under section 80D:

A. Medical insurance premium paid for yourself & your family. Rs. 25,000 Rs. 50,000 (in case of senior citizen)

B. Medical insurance premium paid for your parents. Rs. 25,000 Rs. 50,000 (in case of senior citizen)

C. Expenditure on preventive health check-up. Rs.5,000

D. Medical expenditure of senior citizens or super senior citizens. Rs.50,000

E. Contribution to CGHS/notified scheme. Rs.25,000 Rs.50,000(in case of senior citizen)

Maximum amount of deduction (A+ B+C+D+E) Non-senior citizens(Self & family and Parents) Senior Citizens (Self & family and Parents) Self & family (Non-senior citizens)Parents(Senior Citizens) Rs.25000+Rs.25000= Rs.50,000

Rs.50000+Rs.50000=Rs.1,00,000

Rs.25000+Rs.50000=Rs.75,000

Hence, the deduction available is his total paid minus expected paid which is Rs. 40000 + Rs. 60000 = Rs. 100000 - (A+ B+C+D+E) = Rs. 150000

<h3>What is Section 80D?</h3>

Section 80D permits the deduction for money spent on taking care of one's health and health insurance. Section 80D claims great significance in one's tax planning and personal finance.

Therefore, the correct answer is as given above

learn more about Section 80D: brainly.com/question/14585764

#SPJ1

3 0

2 years ago