Question: In cell T 1 7 use the IF function to enter 6 0 0 if DEPARTMENT is C otherwise enter 2 0 0 . Copy

In cell T17 use the IF function to enter 600 if DEPARTMENT is C otherwise enter 200. Copy the function to the other cells in the column.

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:

In cell T17 use the IF function to enter 800 if DEPARTMENT IS D otherwise enter 500. Copy the function to the other cells in the column. In cell T14 use the appropriate function to calculate the...

Q:

EA4-A2 Edit an Inventory Listing and Create a Pivotlab Electronic World duit as In this exercise, you will compile summary data based on an inventory listing for Blectro Then you will determine the...

Q:

2 page question and Excel information attached as well. ADD Apply Your Skills EA4A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors In this exercise, you will compile...

Q:

Apply Your Skills EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors In this exercise , you will compile summary data based on an inventory listing for Educational...

Q:

on exel EA4-A2 Edit an Inventory Listing and Create a PivotTable for Electronic Worl In this exercise, you will compile summary data based on an inventory listing for Electronic World. Then you will...

Q:

How do I upload the Microsoft excel in chegg there wasn't any option. EA4-A2 Edit an Inventory Listing and Create a PivotTable for Electronic Worl Then you will determine the inventory balance for a...

Q:

need only #6-20 EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors In this exercise, you will compile summary data based on an inventory listing for Educational...

Q:

Ay Yourse 121 Apply Your Skills EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors this exercise, you will complesummary data based on an inventory Listing for...

Q:

this is what is needed: solve EA4-A1 inventory chapter 4 page 122 educational endevours. . this is for Microsoft306/ accounting. my apologies I am not able to provide the requested information, I...

Q:

I heed help for the Inventory Pivot Table please EA4-A2 Edit an Inventory Listing and Create a PivotTable for Electronic World In this exercise, you will compile summary data based on an inventory...

Q:

Nike is releasing a new sneaker that is Eco-Friendly shoes. Project Plan Write Methodology/Project Plan on Nike eco-friendly shoes. This section should include Approach, Structure of the project...

Q:

Gas at 25C exactly fills a container previously determined to have a volume of 1.05 x 10 3 cm 3 . The container plus gas are weighed and found to have a mass of 837.6 g. The container, when emptied...

Q:

10. What are the major factors considered in determining what depreciation method to use?

Q:

Which of the following statements is true? O Accounts receivable are more liquid than cash. Notes receivable are always classified as current assets. O Notes receivable usually have longer collection...

Q:

How can we visually describe our goals?

Q:

What metaphors might describe how we work together?

Q:

What are some of the possible scenes from our future?