ISM4011- Lesson 10- Extending the Organization - Supply Chain Management

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Aging exam 1 (quiz questions and models)

View Set

INSY 3300 - Chapter 7 Lists & Tuples

View Set

MS-102 Microsoft 365 Administrator Certification

View Set

CPSC 471 Chapter 2 Exam Study Set

View Set

DATA 630: Applied Database Management Week 1-5 Quizes

View Set

26 Quiz 8 - The Nursing Process - Implementing

View Set

Which statement best describes a project?

View Set

Vocabulary Workshop Level H (Units 10-12)

View Set