Question: 1 Point: XL Activity 2 . 0 9 : Using the IF Function In cell F 1 5 , insert a function that will automatically

1 Point: XL Activity 2.09: Using the IF Function
In cell F15, insert a function that will automatically display the word Discontinue if the value in cell D15 is less than 1500, or the text No Change if the value in cell D15 is greater than or equal to 1500.
Fill the formula in F15 down to F16:F44.
1 Point: XL Activity 2.09: Using the IF Function In cell

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I dont know what to do for this question on Excel? X8g9b49XZPCblYSTtvgiwRgtrl9HKQjV2cI2HO... 1.00 Point: XL Activity 2.09: Using the hare IF Function In cell F15, insert a function that will...

Q:

Task 2: Scenario 1: For this problem, assume you are a salesperson at a large wholesale food supplier. The company tracks quarterly sales data for salespersons and products. Sales data for the last...

Q:

Unde 18 A Opboard Input Area 6 Name 7. Bacarella 8 Gnther 9 Chen 10 Laing 11 Garbett 12 Gomez 13 Hartvigsen 14 Ikenberry 15 Keone city 2KC Mostly doily Algumant fx-15(E8

Q:

Formulas Data SIMS Sharo 1.00 Point: XL Activity 2.10: Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars 2 Logical File Home Insert Page Layout fx AutoSum - Recently Used -...

Q:

Required information [The following information applies to the questions displayed below.] The Munchkin Theater is a nonprofit organization devoted to staging plays for children. The theater has a...

Q:

Fraction of hosts infected Case Study 2 Hosts, Parasites, and Time-Travel 0.8 0.6 0.4 0.2 0 Past Contemporary Future Time Figure \u00031 Horizontal axis is the time from which the parasite was taken,...

Q:

1.00 Point: XL Activity 8.13: Using the SUMIF Function SIMS Share fx Autosum File Home Insert Page Layout Formulas Data 12 Logical 13 Lookup & Reference Recently Used - Text @ Math & Trig Insert...

Q:

Fraction of hosts infected Case Study 2 Hosts, Parasites, and Time-Travel 0.8 0.6 0.4 0.2 0 Past Contemporary Future Time Figure \u00031 Horizontal axis is the time from which the parasite was taken,...

Q:

The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as...

Q:

8:01 Safari bakhit_Excel_3G_Administrat... Done Expenses Contracts County Partnership City of Orange Blossom Beach Summary of Annual Administration Expenses by Department Quarter 1 Quarter 2 Quarter...

Q:

Two cars , A and B , on a level road travels in the same direction at a speed of 100 kph. B is 80 m ahead of A. When breaks are applied , on B causing it to deccelerate at the rate of 2.15 m/s. In...

Q:

Starting teachers salaries (in equivalent U.S. dollars) for upper secondary education in selected countries are listed below. Which set of data is more variable? (The U.S. average starting salary at...

Q:

which of the following statements is false? D . a firm generally identifies its marginal tax rate by determining the tax bracket that it falls into based on its overall level of pre - tax income,...

Q:

YOUR TASK. In a memo to the college president, the athletic director argues for a new stadium scoreboard. One paragraph will describe the old scoreboard and why it needs to be replaced. Study the...

Q:

What would be the shared Data Elements between Position Control and Salary Grade Tables in providing cost input to Budgets for vacant positions?

Q:

What is the purpose of the Salary Structure Table?

Q:

What is the scope and use of a Job Family Table?