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
Why might legal rules be insufficient for fulfilling one’s ethical responsibilities? Research current events to identify and bri
Sidana [21]

Legal norms and ethical norms are not same and sometimes not agreeable also. Some ethical norms may be wrong legally but some legal norms may be wrong ethically.

<u>Explanation:</u>

The law is set of rules that guide our conduct in society and enforceable through public agencies. For business environment, law provides important guide to make ethical decision making. But sometimes the norms which are ethically right are illegal and sometimes legal norms are unethical.

The example of cases which are ethically right but legally wrong are cheating in taxes or driving over the speed limit or spitting by the road side. The example of cases which are ethically wrong but legal right are falsifying financials, misleading markets and many more.

4 0
3 years ago
Which of the following should men avoid wearing in the workplace?
Brilliant_brown [7]

Answer:

D. Sandals

Explanation:

Sandals aren't a preferred clothing item when going into a workplace, it's more informal than the other options provided.

4 0
2 years ago
What is the name of the economic concept that acknowledges that personal and financial resources are used for one purpose these
ddd [48]

Answer:

This concept is called the opportunity cost.

Explanation:

The opportunity cost of any economic decision is the cost of giving up or sacrificing its alternative. We are aware that resources are limited and have alternative uses. We have to use these resources to satisfy unlimited wants and needs.  

If we use resources for one purpose it cannot be used for another. So we have to make a decision on how to spend the resources, on which alternative use. If we select one alternative, we need to give up another. The cost incurred on sacrificing or giving up the other alternative is the opportunity cost of using the resource for the first alternative.

3 0
3 years ago
Calculate the expected cost per stockout with the following information: Probability of a back order is 50%, lost sale is 25%, a
S_A_V [24]

Answer:

D) $66,325

Explanation:

the total costs associated with a stockout are:

  • probability of a back order 50% x cost of a back order $150 = $75
  • probability of a lost consumer 25% x cost of a lost consumer $250,000 = $62,500
  • lost gross margin = probability of a lost consumer 25% x $1,500 x 50 units x 20% = $3,750

total costs of a stockout = $75 + $62,500 + $3,750 = $66,325

6 0
3 years ago
4. A manufacturer of microwaves has discovered that male shoppers, on average, have lower values for microwave ovens than female
madreJ [45]

Answer:  As per the demographic structure there are equal no. of man and woman are same therefore pricing should be done by taking into consideration both equally.

Explanation: . The prime objective of every business is to maximize their profit and this could be only done when price charged for the product is reasonable. Thus, to secure the customer base company should sell simple microwave for $70 and the one with auto defrost $80. If the company places $70 for simple and $150 for auto defrost women might also not purchase the later one thus buy placing $70 and $80 on two types company will secure a strong base for males in simple microwave and additional male base of male in auto defrost along with females as the females will be having it at cheaper prices while some males may also purchase it as the auto defrost is suitably priced according to their valuation.

.

If the majority of shoppers is female then 480 should be priced for simple and $150 for auto defrost.

5 0
3 years ago
Other questions:
  • It is necessary to calculate equivalent units of production in a department because Select one: a. at times a department may use
    13·1 answer
  • transferable skills necessary for successful employment include a:basic skills b:thinking skills c:personal quality d: all of th
    6·1 answer
  • What are the good manner the service provider must demonstrate when communicate with customer​
    6·1 answer
  • A Registered Investment Adviser plans on offering options strategies as part of his services. For this added investment strategy
    7·1 answer
  • A business must decide whether to open a new office in China. If it opens the
    10·1 answer
  • The equilibrium wage for low-skilled workers is a government-imposed minimum wage, the ____ will be the resulting surplus of low
    15·1 answer
  • In your own words define the term accounting and its usage.
    12·1 answer
  • Calistoga Produce estimates bad debt expense at 0.50% of credit sales. The company reported accounts receivable and allowance fo
    11·1 answer
  • Excel SIM: High-Low Method; Contribution Format Income Statement Analyze a mixed cost using a scattergraph plot and the high-low
    6·1 answer
  • Why do people donate to charitable organizations? Choose three answers.
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!