Answer:
Select Insert > Slicer. Select the fields you'd like to filter. Select OK and adjust your slicer preferences, such as Columns, under Options. To select more than one item, hold Ctrl, and then select the items that you want to show.
Explanation: Convert the data into a table
Make it easier to click, copy and paste,and open new tabs.
All counties. Much more info. Although most layers are just excel files with geographical reference data in them. That one file may be several MB as the state file may be 1mb or less
Answer:
Using join on both table against column CUST_ID will return customer ID, company and total sales
Explanation:
select
CUSTOMERS.CUST_ID,
CUSTOMERS.COMPANY,
SALES.TOTAL_SALES
from CUSTOMERS JOIN SALES
ON
CUSTOMERS.CUST_ID=SALES.CUST_ID
Above query selects required customer id and company table from customers table and total sales from sales table and apply join against customer id
JOIN in sql returns all the row where for a value in first table there is a matching value in second table.
Answer:
True
Explanation:
Internet can reduce bargaining power of suppliers:
Internet is a powerful means which has strengthen competitiveness in organizations. This has led to competition which results in price wars. This decreases the bargaining power of suppliers as the competition among different suppliers intensifies and the need of the buyers to buy only from a few suppliers is lessened. This also results in the increased bargaining power of buyers. Internet enables buyers to save their time and money and has increased transparency e.g. services costs which resulted in increase bargaining power of buyers while reducing the bargaining power of suppliers. This transparency increased price competition and competitiveness
. Consequently buyers are less loyal to certain suppliers and can choose the suppliers who meet their requisites.
Internet can increase bargaining power of suppliers:
Through internet the bargaining power of suppliers can be increased. The internet has given a cost effective platform to suppliers to reach to their customers which has increased competition between suppliers. Suppliers can access more customers and provides better services to them. With internet connectivity suppliers can directly communicate with their customers. The internet can increase the bargaining power of suppliers by allowing reduction of entry barriers and increasing number of competitors.
