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
A financial advisor has heard from a relative of nr industries inc.'s ceo that the company is planning to shut down its operatio
kolezko [41]

This would be a case of insider trading, meaning that the trader (the financial advisor) has information that is not public that will affect the future performance of the company. If the advisor acts on this early information and profits, then this could be considered illegal.

3 0
3 years ago
Nancy sold her personal residence on June 30 of this year under an agreement in which the real estate taxes were not prorated be
meriva

Incomplete question. Here's the full question:

<em>Nancy paid the following taxes during the year: </em>

<em>Tax on residence (for the period from March 1 through August 31) =$5,250</em>

<em>State motor vehicle tax (based on the value of the personal use automobile) =$430</em>

<em>State sales tax =$3,500</em>

<em>State income tax =$3,050</em>

<em>Nancy sold her personal residence on June 30 of this year under an agreement in which the real estate taxes were not prorated between the buyer and the seller.</em> What amount qualifies as a deduction from AGI for Nancy? a. $9,180b. $9,130c. $7,382d. $5,382 e. None of the above

Answer:

<u>c. $7,328</u>

Explanation:

Remember, Nancy <em>transferred</em> ownership of her personal residence on June 30, but she received tax on residence for 2 extra months (July and August).

The amount that qualifies for tax deduction therefore is;

121 days (Four months of her stay) / 184 days (six months period) × $5,250

+

$430

+

$3,500] = $7,382.

She likely deducts from the state sales tax with a higher amount than from the state income tax.

4 0
3 years ago
Which type of office machine scans each page of a document, translates the information into electronic impulses, and transmits t
Katen [24]

Answer:       facsimile. ("fax") A process by which fixed graphic material including pictures, text, or images is scanned and the information converted into electrical signals which are transmitted via telephone to produce a paper copy of the graphics on the receiving fax machine. Some modems can be used to send and receive fax data ...

7 0
3 years ago
The failure to record which transaction has no effect on the quality of inventory?
zimovet [89]

Do not record transactions that do not affect inventory quality. A recorded inventory transaction has actually taken place.

Records of inventory purchases made during the accounting period. The purchase account is increased by direct debit. The manufacturing costs of the goods sold are overestimated by the same amount. An overstatement of cost of goods sold will result in an understatement of net income and retained earnings by the original margin of error.

If the auditor is dissatisfied with the accuracy of the closing balance sheet and may be materially increase.

Inventory write-downs affect both the income statement and the balance sheet. Write-offs are treated as expenses. This means your net income and tax liability will be reduced. Therefore, a decrease in net income will reduce a company's retained earnings and reduce shareholders' equity on the balance sheet.

Learn more about inventory at

brainly.com/question/25887081

#SPJ4

4 0
1 year ago
The Mary Company primarily sells dishes, and recently purchased a cardboard box company. Mary's new cardboard box division has n
fgiga [73]

Answer: $1.50

Explanation:

Based on the information given in the question, we are informed that the variable cost of each box is $1.50 and usually has a contribution margin of $0.80 per box.

We should note that the minimum transfer price that the box division should find as acceptable will be the relevant cost. In this case, the relevant cost is given as $1.50 pee box and therefore, the minimum transfer price will be $1.50.

8 0
2 years ago
Other questions:
  • Select the answer that most accurately describes the effects of NAFTA.
    11·2 answers
  • When should relative frequencies be used when comparing two data sets?
    10·1 answer
  • Sales of the cooler freeze packs made by the company Coolpaxx have been declining. Online sales information is shared with the s
    8·1 answer
  • Colleen is a medical researcher at Octogen Pharmaceuticals. She called attention to the illegal marketing of a drug produced by
    11·1 answer
  • Generally, we calculate elasticity as the: percentage change in quantity demanded/supplied divided by the change in price. perce
    12·1 answer
  • If the same purchase and sale transactions are recorded using both periodic and perpetual inventory valuation, which method will
    12·1 answer
  • Brief, Inc., had a receivable from a foreign customer that is payable in the customer’s local currency. On December 31,2017, Bri
    14·1 answer
  • I really need help with this weustion :_:
    5·2 answers
  • HAJAH MORE FREE POONGGS
    8·2 answers
  • a buyer purchases a home in an area where closings are traditionally conducted in escrow. which item would a buyer deposit with
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!