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
deff fn [24]
3 years ago
14

You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and commen

ts on what you have been working on, suggesting that there is an easier approach to use.
You implement the VLOOKUP formula at your colleague’s suggestion, but you get the #VALUE! error as the result of the formula. Which of the following is likely true?
a. You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
b. You might have indicated that the compare values are a range of values instead of an exact match.
c. You might have entered a number for the col_index_num instead of a letter.
d. You might have entered a letter for the col_index_num instead of a number.
Business
1 answer:
Tresset [83]3 years ago
6 0

Answer:

d. You might have entered a letter for the col_index_num instead of a number.

Explanation:

The answer is the option d.

In the col_index_num, we have to provide of the column number we want to refer to. In case some letter is typed by mistake, it will give an error.

An argument col_index_num of 1 returns the value in the first column; a col_index_num of 2 returns the value in the second column in table_array, and so on.

Excel returns an error value if the argument is a text, as well as if it is less than 1 or greater than the number of columns.

You might be interested in
Last year mike bought 100 shares of dallas corporation common stock for $53 per share. during the year he received dividends of
Pepsi [2]
Mike brought 100 shares costing $53 each.
Total costs of shares= 100*53
=$5300

He got dividends of $1.45 per share. A dividend is money that is earnt back from a share.
Total dividend amount = 1.45*100
=$145

I'm assuming that Mike sold his shares at the end of the year. He sells for $60 each.
Total sales amount=60*100
=$6000

The rate of return in this instance can be defined as the amount of money made back from a share.

Rate of return= total earnings/ costs

Total costs= $5300
Total earnings=$6145

6145/5300=1.1594
=15.9%

Hope this helps! :)
4 0
3 years ago
A company has the following asset account balances: Buildings and equipment $9,200,000 Accumulated depreciation 1,200,000 Patent
Elis [28]

Answer:

$14,000,000

Explanation:

To be reported under Property, Plant and Equipment:

= (Buildings and equipment - Accumulated depreciation) + Land Improvements + Land

= ($9,200,000 - $1,200,000) + $1,000,000 + 5,000,000

= $8,000,000 + $1,000,000 + 5,000,000

= $14,000,000

Note:

(1) Intangible Assets (Patents) will be reported after Plant, Property and Equipment. These are not a part of plant, Property and Equipment.

(2) There is no information about the useful life of the Land, so the value of land improvements will be included in the property, plant, & equipment section.

7 0
2 years ago
How do investment banks differ from commercial​ banks? ​(mark all that​ apply.)
mina [271]
I would say d as investment banks are generally concerned with lending money to start up or fund business ventures. Commercial banks lend to almost anyone that can repay.
4 0
3 years ago
The Pritzker Music Pavilion in downtown Chicago is a technologically sophisticated and uniquely designed performing arts venue t
jonny [76]

Answer:

a. What is the estimated contribution margin per ticket sold for the benefit concert?

contribution margin per ticket = ($15.50 + $2 + $17) - ($6 + $2.55 + $7) = $34.50 - $15.55 = $18.95

b. What are the estimated total fixed costs for the benefit concert?

total fixed costs = $21,000 + $85,000 = $106,000

c. What is the estimated profit from the benefit concert if 10,500 tickets are sold?

estimated profit = (10,500 x $18.95) - $106,000 = $92,975

d. How many tickets must be sold in order for concert profit to be $100,000?

number of tickets sold = ($106,000 + $100,000) / $18.95 = 10,870.71 ≈ 10,871 tickets sold

e. Assuming a tax rate of 31% on profits from the concert, what must dollar ticket sales be in order for after-tax concert profits to be $100,000?

$100,000 / (1 - 31%) = $144,927.54

number of tickets sold = ($106,000 + $144,927.54) / $18.95 = 13,241.56 ≈ 13,241.56 tickets sold

f. Assume that the organizers can negotiate the fixed payment for the pavilion's operating expenses. If the organizers expect to sell 10,500 tickets, how much can they afford to pay and still earn a profit of $100,000 (ignore taxes)?

contribution margin increases to $18.95 + $7 = $25.95

10,500 = ($21,000 + $100,000 + ?) / $25.95

$272,475 = $121,000 + ?

? = $151,475

you can pay up to $151,475 in fixed expenses to the pavilion

5 0
3 years ago
Imagine that millions of refugees move out of country A and into country X. This would cause the demand for housing in country A
Burka [1]

Answer:

Decrease

Increase

Explanation:

If millions are moving out of a country, the number of people living in the country would fall and the demand for houses would fall. While the demand for houses where the people are immigrating to would increase as population would increase and they would need where to live.

I hope my answer helps you.

4 0
3 years ago
Other questions:
  • If you hired a firm to do a risk assessment of your business, would you hire the same firm to mitigate any risks that were ident
    7·1 answer
  • The maximum penalty for failure to report that you accepted a gift from a non-federal entity may result in
    11·1 answer
  • Ramapo Company produces two products, Blinks and Dinks. They are manufactured in two departments, Fabrication and Assembly. Data
    6·1 answer
  • Barton Corporation acquires a coal mine at a cost of $1,500,000. Intangible development costs total $360,000. After extraction h
    7·1 answer
  • Two types of cars (Deluxe and Limited) were produced by a car manufacturer last year. Quantities sold, price per unit, and labor
    15·1 answer
  • Give any two merits and demerits of the partnership firm
    11·2 answers
  • The reserve requirement is 15 percent. Lucy deposits $600 into a bank. By how much do excess reserves change
    13·1 answer
  • Ayayai Furniture Company started construction of a combination office and warehouse building for its own use at an estimated cos
    10·1 answer
  • What is term for the ability to easily turn assets or investments into cash?
    13·1 answer
  • What percentage of donald (dax) cowart's body was burned in the fire on july 23,1973?
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!