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
marshall27 [118]
3 years ago
15

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

Business
1 answer:
navik [9.2K]3 years ago
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
What factors are encouraging financial institutions to offer overlapping financial services such as banking, investment banking,
Anna11 [10]

Answer:

B. I and II only

Explanation:

I. Regulatory changes allowing institutions to offer more services II. Technological improvements reducing the cost of providing financial services

7 0
3 years ago
An aging of Lily Company’s accounts receivable as of December 31 revealed the following. Amount % Uncollectible Current $20,000
lana66690 [7]

Answer:

What is BAD DEBT EXPENSE for THIS year?

4000

Explanation:

Aging    

Current          20000 2% 400

1-30                  50000 4% 2000

31-60         30000 7% 2100

Over 60         10000 25% 2500

   

                            7000

Allowance bad debts   3000

Expense                    4000

4 0
3 years ago
Lon has just come home from serving in the Marines and contracts with a local car dealership to purchase a car. The car must be
cricket20 [7]

Answer:

The correct answer is:  A novation.

Explanation:

A novation is the replacement of individuals in a contract with the consent of both parties. The new party takes all the obligation of the initial party and releases the last one from all duty. The novation must be signed for the transferor, the transferee, and the contracting party.

4 0
3 years ago
Accounts receivable in an existing business:
Artemon [7]

Answer:

The correct answer is letter "A": are rarely worth their face value.

Explanation:

Accounts receivables are notes issued to customers after selling them a product or rendering services on credit. The repayment term may vary from 30, 60 or 90 days. If an account receivable is not paid after that period it could be considered as an uncollectible account which implies the company will incur losses.

<em>Accounts receivable are hardly ever accepted at face value (real value of the moment of the purchase) because companies add the interest rate that is to be charged for the sale on the account.</em>

4 0
3 years ago
Which formula should be used to correctly calculate the<br> monthly mortgage payment?
Charra [1.4K]
What’s the question
7 0
3 years ago
Other questions:
  • 1-Which of the following is a trait that is shared by managers who are adept in the organizing function?
    9·1 answer
  • Beyonce, taylor swift, and miley cyrus make commercials that encourage people to drink milk. these ads contain _____ . trade-off
    7·2 answers
  • Which process is used to select more than half of federal civilian workers?
    6·2 answers
  • Labor unions want _____ wages for employees, but producers could earn more profits by offering _____ wages.
    15·2 answers
  • You invested $5,000 in the Cog corporation and $5,000 in the Gear corporation. Both of these corporations have $100 million in t
    12·2 answers
  • aylor &amp; Edwards Inc. manufactures television sets. Last month, direct materials (electronic components, etc.) costing $550,0
    8·1 answer
  • Consolidated financial statements are prepared when a parent-subsidiary relationship exists in recognition of the accounting con
    11·1 answer
  • Jackson and Campbell have capital balances of $100,000 and $300,000, respectively. Jackson devotes full time and Campbell devote
    5·1 answer
  • A newly issued bond pays its coupons once annually. Its coupon rate is 5.7%, its maturity is 20 years, and its yield to maturity
    15·1 answer
  • Which of the following actions is unlikely to help make a company's branded footwear more competitive vis-a-vis the brands of ri
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!