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
Bess [88]
3 years ago
14

Filter the data in place so that only rows where the category value is meals and the cost value is greater than 20 are shown. th

e criteria range has been set up for you in cells a1:c2.
Business
1 answer:
Anestetic [448]3 years ago
4 0

Explanation:

To find :

Filter the data in order such that only rows where the sum of the type is food and the sum of the amount is greater than 20 are displayed. The selection of requirements has been set for you in cells a1:c2.

Now,

You clicked the Advanced button on the Data Ribbon Tab in the Sort & Filter Ribbon Section.

You tapped on cell A1.

You pressed the OK button in the Advanced Filter window.

You might be interested in
Bradford Services Inc. (BSI) is considering a project that has a cost of $10 million and an expected life of 3 years. There is a
balandron [24]

Answer:

Expected Net Cash Flow = $3.8 million

Net Present Value (NPV) = $1.0492 million

Explanation:

Given Cash outflow = $10 million

Provided cash inflows as follows:

Particulars           Good condition         Moderate condition        Bad Condition

Probability                  30%                               40%                                  30%

Cash flow                $9 million                     $4 million                       $1 million

Average expected cash flow each year = ($9 million X 30 %) + ($4 million X 40%) + ($1 million X 30%) = $2.7 million + $1.6 million + $0.3 million = $4.6 million

Three year expected cash flow = ($4.6 million each year X 3) - $10 million = $13.8 million - $10 million = $3.8 million

While calculating NPV we will use Present Value Annuity Factor (PVAF) @12% for 3 years = \frac{1}{(1 + 0.12){^1}} + \frac{1}{(1 + 0.12){^2}} + \frac{1}{(1 + 0.12){^3}} = 2.402

NPV = PV of inflows - PV of Outflows = $4.6 million X 2.402 - $10 million = $11.0492 million - $10 million = $1.0492 million

Expected Net Cash Flow = $3.8 million

Net Present Value (NPV) = $1.0492 million

3 0
4 years ago
The key decisions and plans in corporate strategy address: What business are we in and how will we allocate resources among thes
serious [3.7K]
This is A. true i think
4 0
3 years ago
A man in San Rafael County was discovered committing workers' compensation fraud. He had been observed working while at the same
LuckyWell [14K]

Answer:

1. Yes

2. - privacy concerns

- may lack full details.

Explanation:

1. In this scenario the automobile auction house would need to show video evidence of his (San Rafael's) fraud activities to the investigator.

2. Privacy concerns such as how the information gotten from video surveillance is used may pose a challenge.

There's also the reality of a lack of full details. For instance, San Rafael may be deaf a disability that cannot be reflected well on a surveillance video that shows him working.

6 0
3 years ago
A low-interest loan for students who demonstrate financial need is a(n):
Paul [167]

The answer is: D. Direct Subsidized Loan

The main characteristic of a Direct Subsidized Loan is that the loan interest is set at a fixed rate by the government and would not be accrued. This means that even if the student in financial needs somehow late in making payments, the amount of his/her total loan would not be increased.




4 0
3 years ago
Categorize each statements as a component of Gross Domestic Product (GDP): consumption, investment, government, or net exports.
Natasha2012 [34]

Answer:

-Consumption: ice cream, a domestically manufactured personal computer, cab fare for personal use, 55 cent tacos, A super bowl ticket bought new from the NFL

- Investments: A domestically manufactured business computer

-Government: A public school teacher

-Net Exports: An exported doll house

Explanation:

Gross Domestic Product is the market value of goods and services produced locally within a given period. GDP includes goods and services produced during a particular time interval. In the past, bargains for products produced are not reflected in GDP. Usually this interval is years or quarters.

Consumption contains produced goods and services. It is used by people to meet their needs and wishes. In the Keynesian economy, consumption means individual consumption expenditure and is indicated by the consumption function. The most important part of the consumption function is the marginal consumption trend. MPC shows what percentage of each new income earned is used for consumption expenditures.

Public expenditure, in economy, indicates the complex of money of public origin that is used by the State in public goods and / or public services aimed at pursuing public purposes, regardless of the nature (public or private) of the obligation that is the title . These are therefore the exits by the state and therefore an item of liabilities within the state budget, the coverage of which is necessarily entrusted to taxation on taxpaying citizens or public debt. Otherwise, the repercussions are of an inflation or devaluation type, depending on the domestic or foreign destination of the capital.

Trade balance (Trade deficit) or Net Export is the balance of trade (export, import) of one country (with other countries). Based on this, the Trade Balance (Foreign Trade Balance) is the relationship between exports and imports. If the country's exports are greater than the import, net exports will be greater than 0, and in this case, the country's foreign trade balance will increase (a positive balance). In a word, the trade balance is positive. Otherwise, net exports will be less than 0 if the country exports are smaller than imports. In this case, the country will have a foreign trade deficit. In other words, the trade balance will be negative. The negative trade balance also indicates that the country needs foreign products in addition to its own products.

7 0
3 years ago
Other questions:
  • If Gary always requests his superior’s advice when solving a problem or making a decision, which type of decision maker is he?
    14·1 answer
  • People live for four periods. They can choose to work for all four periods, or can attend school in the first period and then wo
    11·1 answer
  • Classify crimes in order according to the<br> severity of their potential sentences.
    6·1 answer
  • On July 1, 2016 Harold paid $10000 for a Ten year bond with a stated interest rate of 5%, payable annually on July 1. On April 1
    12·1 answer
  • Adjustments for physical characteristics are intended to capture the dimensions in which a comparable property differs physicall
    7·1 answer
  • Bases of business or organizational market segmentation that center on the customer attributes are categorized as: Group of answ
    5·1 answer
  • Attorneys Arianna and Alexander share an office that has a sign reading: "A &amp; A, a law firm." Their billing invoices have bo
    10·1 answer
  • The Equal Credit Opportunity Act prohibits which of the following? a. Basing the credit decision on unemployment. b. Basing the
    11·1 answer
  • Johnny is a sophomore in college and has a 1.5 cumulative grade point average (GPA). Johnny's cumulative GPA will fall even furt
    5·1 answer
  • Type the correct answer in the box. Spell all words correctly. While executing a project, it is important to express mutual_____
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!