ISM4011- Lesson 10- Extending the Organization - Supply Chain Management
Use the Page Layout tab to insert a picture in an Excel worksheet.
False
A text file is a document that includes formatted text.
False
When you group sheets, most editing and formatting commands that you perform affect every sheet in the group.
True
When you save worksheet data as a text file, Excel renames the sheet with the same file name that you type for the text file.
True
When you work with large numbers of records in a worksheet, you can use groups to hide data that is not needed at the moment.
True
With Conditional Formatting, Top/Bottom Rules use a ranking to format the highest (top) or lowest (bottom) items, either by number or percentage.
True
You can create your own conditional formatting rule as well as edit existing rules with the Manage Rules command.
True
You can dynamically consolidate data by using 3D references in your own formulas.
True
You can import a table or a query from an Access database into an Excel worksheet.
True
Data tables are located just below a chart.
True
SEO specialists are normally sought after for their expertise in editing photos and designing layouts for websites.
False
The business world is shifting from customer focus to product focus.
False
Software customization modifies existing software according to the business's or user's requirements.
True
Sparklines are miniature charts displayed in a cell or cell range with your data.
True
When the source data is final and will not be edited, you can use a static consolidation.
True
When using an Advanced Filter, you need to create a criteria range.
True
The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme.
True
The Consolidate command calculates totals, averages, or other functions for data from multiple worksheets.
True
The Subtotal command includes SUM, AVERAGE, MAX, and MIN as well as other Statistical functions.
True
The cells used to build a chart are its source data.
True
To capture one part of a computer screen, use the Screen Clipping command.
True
To delete a chart element, click it to select it and press Delete.
True
To link workbooks, use the consolidate command or build formulas that refer to cells in other workbooks.
True
Today's videos games are quite complex and require programming for user interaction, realistic motion and physics, and even intelligent character behavior.
True
Inventory cycle time is the frequency of inventory replacement.
False
LivePreview identifies the file and provides basic instructions for a hyperlink.
False
Once you have created a chart, it is possible to change the chart type.
True
A backward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.
true
A forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.
true
Plan, source, give, get, and return are the five basic supply chain management components.
False
If you save a workbook while sheets are grouped, the workbook will open with ungrouped sheets the next time you open the file.
False
In a pie chart, a data series is a slice of a pie.
False
In a table, each row of data is a field and each column is a record.
False
In an ascending sort, data is sorted alphabetically from Z to A.
False
A SmartArt graphic is linked to worksheet data.
False
A Snapshot is a picture of a full or partial computer screen inserted as an object in a worksheet.
False
A static consolidation places formulas on the consolidated sheet in an outline format.
False
CRM is a technology based on the premise that those organizations that understand the needs of individual customers are best positioned to achieve sustainable competitive advantage in the future.
False
Call scripting occurs when a customer service representative answers customer inquiries and solves problems by email and IMing.
False
Customer order cycle time is the time it takes to manufacture a product and deliver it to the retailer.
False
Products are distributed to customers and their downstream customers at all levels.
True
A chart object is a selectable item surrounded by a square border that is separate from worksheet data.
True
A chart sheet is an Excel chart that is displayed on its own sheet in the workbook.
True
A chart style is a preset combination of colors and effects for a chart, its background, and its elements.
True
A consolidated worksheet summarizes data from multiple worksheets using a mathematical or statistical function.
True
A legend is the chart element that explains the symbols, textures, or colors used to differentiate data series.
True
A tick mark is a small line or marker on an axis to guide in reading values.
True
A two-tier ERP architecture allows an organization to have an on-premises ERP system along with cloud ERP applications.
True
A web developer creates and maintains websites for organizations.
True
A worksheet can have only one outline.
True
After you choose a color for a chart element, you can refine it to use a gradient, a variegated blend of the color.
True
After you create a dynamic consolidation, expand outline items to display individual values that are summarized.
True
After your data is formatted as a table, each label in the header row displays an AutoFilter arrow.
True
An external reference formula refers to cells in another workbook and establishes a link to the source workbook.
True
An identifier is a character such as an exclamation point that marks or signifies a component of an external reference.
True
Another name for the base or bottom of a 3-D chart is chart floor.
True
Consolidation by category can be static or dynamic
True
Consumer behavior, competition, visibility, and speed are the four changes resulting from advances in technology that are driving supply chains.
True
Deploy in incremental phases and measure and communicate success is one of the keys to success for SCM.
True
Each group of data points or values used in a graph is a data series.
True
Each individual shape in a SmartArt object has its own selection handles, a rotation handle, and a bounding frame.
True
Enterprise resource planning (ERP) integrates all departments and functions throughout an organization into a single MIS system (or integrated set of systems) so employees can make decisions by viewing enterprise wide information about all business operations.
True
Exploding a pie slice emphasizes that slice, because it moves the slice away from the rest of the pie.
True
External data is data in a worksheet that originated in another program or format.
True
Flash Fill is a feature that recognizes a pattern in the first cell and suggests data for the remaining rows in a column.
True
If data is formatted as an Excel table, convert it to a normal cell range before using the Subtotal command.
True
In Excel, dates are treated as values.
True
In order to use the Consolidate command by position, worksheets must have common data in the same rows and columns on each worksheet.
True
In the basic supply chain, deliver refers to planning for transportation of goods to customers.
True
Insert a hyperlink to open another workbook or a web page.
True
Inventory cycle time is the time it takes to manufacture a product and deliver it to the retailer.
True
Inventory turnover is the frequency of inventory replacement.
True
It is possible to replace a chart title box with WordArt
True
Many companies are creating a position for social media strategists, who are experts in sales and marketing using the World Wide Web and social media tools
True
Application integration is the integration of data from multiple sources, which provides a unified view of all data.
false
Collaborative demand planning reduces product development costs.
false
Collaborative engineering automates order processes from initial customer inquiry to final product delivery.
false
Enterprise application integration (EAI) connects the plans, methods, and tools aimed at integrating separate enterprise systems.
false
In the basic supply chain, return refers to prepare to manage all resources required to meet demands.
false
In the basic supply chain, source refers to planning for transportation of goods to customers
false
Integrations are achieved using enterprise systems—several different types of software that sit between and provide connectivity for two or more software applications.
false
Integrations provide enterprisewide support and data access for a firm's operations and business processes.
false
The customers' customer is upstream in the supply chain.
false
Collaborative demand planning reduces inventory investments, while improving customer satisfaction.
true
Demand planning systems generate demand forecasts using statistical tools and forecasting techniques, so companies can respond faster and more effectively to consumer demands through supply chain enhancements.
true
Effective and efficient supply chain management systems can enable an organization to decrease the power of its buyers.
true
Eintegration is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.
true
Electronic data interchange (EDI), a standard format for the electronic exchange of information between supply chain participants.
true
Enterprise application integration (EAI) middleware takes a new approach to middleware by packaging commonly used applications together, reducing the time needed to integrate applications from multiple vendors.
true
In the basic supply chain, make refers to manufacturing products and create production schedules.
true
In the basic supply chain, return refers to supporting customers and product returns.
true
In the basic supply chain, source refers to building relationships with suppliers to procure raw materials.
true
Information technology's primary role in supply chain management is creating the integrations or tight process and information linkages between functions within a firm - such as marketing, sales, finance, manufacturing, and distribution - and between firms.
true
Integrations allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.
true
Middleware translates information between disparate systems.
true
Plan, source, make, deliver, and return are the five basic supply chain management components.
true
Supply chain execution systems ensure supply chain cohesion by automating the different activities of the supply chain.
true
Supply chain planning systems use advanced mathematical algorithms to improve the flow and efficiency of the supply chain while reducing inventory.
true
Supply chain visibility is the ability to view all areas up and down the supply chain.
true
The bullwhip effect occurs when distorted product-demand information ripples from one partner to the next throughout the supply chain.
true
