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
cestrela7 [59]
2 years ago
10

Your lobster fishing business is straightforward, and you run your accounting in Excel. You maintain separate workbooks for each

year, and each workbook has a spreadsheet for every month. The monthly spreadsheets are identical except for their names, which are January, February, etc. You have found that you need to sum your diesel fuel expenditures, which are always recorded in cell D18, for the months of August through December. What three-dimensional formula would give you that result
Business
1 answer:
Oksana_A [137]2 years ago
7 0

Answer:

The three-dimensional formula that would give you the required result, that is suming the diesel fuel expenditures, which are always recorded in cell D18 for the months of August through December is:

=SUM(August:December!D18).

Explanation:

First, enter the excel starting formula "=SUM(". Type "August" or  left-click on the August sheet with the mouse. Type in colon and December or hold the Shift key and left-click on the December sheet. Then, select the cell C3 in the December sheet.  Before pressing "Enter," add a closing bracket.  The sum formula looks exactly like this: "=SUM(August:December!D18)." This formula can completely be typed manually. The formula sums up cell D18 across each of the sheets from August to December, returning a value.

You might be interested in
Scenario: Terrill and Natalia want to buy a home valued at $150,000. The property tax in their community is 1 percent of the pro
wariber [46]

1,500 is the answer ......

7 0
3 years ago
Read 2 more answers
If an unauthorized withdrawal was made from a checking account the customer will
Crazy boy [7]
Lock the card, and contact the bank.
7 0
3 years ago
The purchase agreement should not disclose all of the conditions and terms of the sale.
Makovka662 [10]
It should disclose all the terms and conditions, otherwise the purchase agreement wouldn't be binding.
5 0
2 years ago
The factors of production attempt to instill the idea that resources are
Flauer [41]

Answer: inputs

Explanation: they are required for processing and necessary for the output product

5 0
3 years ago
Read 2 more answers
The biggest factor in determining the price of a mortgage is One reason to buy a home instead of rent a home is
lakkis [162]

As you pay on a mortage mothly, it pays down the balance. This money works for you and becomes a form of investment. Rent simply goes toward paying your cost of ling and doesn't get invested.

4 0
3 years ago
Other questions:
  • Patricia Nall was approved for a $3,000, two-year, 11 percent loan with the finance charges figured using the discount method. H
    10·1 answer
  • BuzzInc. sold a piece of equipment during the period for $230,000 and recorded a gain of $45,000 on the sale. How should this ga
    5·1 answer
  • Nadia could not withdraw money from her checking account, even though it had been several weeks since she deposited a check. Wha
    12·2 answers
  • at a trade meeting, country A and country B, which are trade partners, agree to remove trade barriers to stimulate economic grow
    11·2 answers
  • Kaspar Industries expects credit sales for January, February, and March to be $202,100, $264,200, and $319,300, respectively. It
    14·1 answer
  • Atburex is a furniture manufacturing company in the United States. The company provides a 60-day credit period and also offers o
    15·1 answer
  • Which document is necessary for nearly everyone who applies for a job
    11·1 answer
  • Which of the following statements is false? Multiple Choice The journal entry to record bad debt expense decreases current asset
    10·1 answer
  • You are considering an investment project with an internal rate of return of 8.7 percent, a net present value of $393, and a pay
    8·2 answers
  • Samsung innovations have proven to be successful supported by statistical data.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!