All categories

3 years ago

While inserting an array function the excel user must press

Business

1 answer:

hichkok12 [17]3 years ago

6 0

Control+Shift+Enter

Array functions in excel are powerful tools sometimes refereed to as "CSE" functions because you have to press Control+Shift+Enter in order to enter them in your worksheet.

You might be interested in

The U.S. stock market has returned an average of about 9% per year since 1900. This return works out to a real return (i.e., adj

taurus [48]

Answer:

Final value= $242,726.24

Explanation:

Giving the following information:

The U.S. stock market has returned an average of about 9% per year since 1900.

This return works out to a real return (i.e., adjusted for inflation) of approximately 6% per year.

If you invest $100,000 and you earn 6% a year on it for 30 years.

We know inflation is 3% (average), so our real interest rate is approximately 3%.

We need the final value formula:

FV= PV*(1+i)^n

FV= 100000*(1.03)^30= $242,726.24

3 0

3 years ago

A company prepares its income statement by listing all sources of revenues and gains at the top, followed by a list of all expen

lapo4ka [179]

Answer:

Single step income statement

Explanation:

The single step income statement is the simplest form in which an income statement is prepared, e.g.

Revenues:

Sales revenues $100
Interest income $20 $120

Expenses:

Rent expense $30
Utilities expense $10
Wages and salaries $60 <u>($100)</u>

Income before taxes $20

Tax expenses <u> ($4.20)</u>

Net income $15.80

A multi-step income statement is more complex, since operating revenues and costs are reported first in order to determine operating income, then other revenues and expenses are introduced and income before taxes is calculated.

8 0

3 years ago

A property title search firm is contemplating using online software to increase its search productivity. Currently an average of

Brrunno [24]

Answer:

Explanation:

Productivity per unput dollar=Fees charged from clients/total cost to firm

There are 3 options:

1. Using current software:

Av time=40 min

Researcher's cost=$2 a min

Total cost=40*2=80

Productivity per dollar input=Fees charged from clients/total cost to firm= 400/80=$5

Using company A's software

Av time=30min

Cost of reducing av time=$3.5

Researcher's cost=$2

Total =30*2+3.5=63.50

Productivity per dollar input=400/63.5=6.3

Using company B's software

Av time = 28 min

Cost of reducing av time=$3.6

Researcher's cost=$2

Total cost=28*2+3.6=59.6

Productivity per dollar input=400/59.6=$6.71

Answer - Using company B's software

3 0

3 years ago

Kawai Corporation, which makes and sells 85,000 radios annually, currently purchases the radio speakers it uses for $8.00 each.

andriy [413]

Answer:

Effect on income= $-117,500

Explanation:

Giving the following information:

Kawai Corporation, which makes and sells 85,000 radios annually, currently purchases the radio speakers it uses for $8.00 each.

Kawai estimates that the cost of materials and labor needed to make speakers would be a total of $6.50 for each speaker. Also, supervisory salaries, rent, and other manufacturing costs would be $170,000. Allocated facility-level costs would be $75,000.

Buy= 85000*8= $680,000

In house:

Production costs= 6.5*85,000 + 75,000= 627,500

Other fixed costs= 170,000

Total cost= $797,500

Effect on income= 680,000 - 797,500= $-117,500

3 0

2 years ago

What is business office ? why is it established . Give 8 reason

jarptica [38.1K]

Answer:

Hope it helps

Mark my answer brainliest

5 0

3 years ago