Business Computer Applications Practice Test

These questions are part of the practice quiz. Start practicing

• Which term describes online providers that aggregate merchant services to process card payments for multiple merchants?
• Executive Information Systems (EIS) are also known as what?
• In supply chain management, what is the main purpose of a dashboard?
• What does MICR stand for?
• POS stands for which phrase?
• What resources are easily available for QuickBooks users to provide decision support?
• DSS stands for which of the following?
• Which scenario best describes the use of a decision support system in marketing to assess ROI when ad budgets change?
• Which practice best ensures consistent formatting across a document?
• Select three manufacturers of customer relationship management software.
• Which term refers to systems that make the sales process more efficient?
• Which software company expanded its credit card processing products to also sell point-of-sale stations?
• What is the role of parameterized queries in preventing SQL injection?
• Which statement best describes the difference between relational integrity and referential integrity?
• Small businesses often prefer to use QuickBooks, which targets smaller firms.
• Which company was formed by Peter Thiel that developed software for Palm Pilot fund transfers?
• SCM software is integrated into an ERP suite of software. What word completes the phrase 'enterprise ___ planning'?
• Which function counts cells that meet a criterion?
• What is a named range and how does it affect readability of formulas?
• What is the purpose of using an IF statement in a spreadsheet, and what does nesting enable?
• SAP is headquartered in which country?
• Select the correct reasons why managers use customer relationship management systems.
• What is the purpose of the Goal Seek feature?
• Which statement best describes CRM's role in marketing?
• What does Slide Master control in presentation software?
• Based on the described EIS dashboard, which action is described as using the EIS dashboard to quickly identify underperforming departments?
• To create a simple chart from a data range, what is the first step?
• When scheduling a meeting using a calendar tool, which information should you include?
• If a marketing manager wants to know if increasing the advertising budget on social media will result in a higher return-on-investment, a DSS could determine how much increase would result in the desired sales increase. This is a simple example that illustrates how a DSS is a form of ___.
• Which component of a DSS is primarily responsible for applying mathematical models to data?
• Which term refers to business information systems that provide executives with a broad view of the competitive landscape using data from internal and external sources?
• What are potential conflicts in co-authoring and how are they resolved?
• The term 'ringing up a sale' originated from the bell struck when the till was opened on a ___.
• What is the correct way to apply data filters to show rows that meet specific criteria?
• In a point-of-sale system, which component is responsible for printing receipts?
• Which function returns the smallest value in a given range?
• A workbook is the entire Excel file that can contain multiple worksheets.
• Which statement correctly describes the behavior of the functions SUM, AVERAGE, MAX, and MIN?
• By providing a view of the entire system, these systems allow logisticians to identify cost centers and minimize costs.
• Also known as business intelligence (BI) software, ___ support system (DSS) software gained credibility with airlines and air traffic control systems in the mid-1980s and 1990s.
• What term describes software that coordinates core business processes across departments?
• Which describes creating a data validation drop-down list?
• Business Objects, a leading decision support system software, is offered by which company?
• In supply chain management software, what does a typical dashboard do when a delay is detected?
• How do Headers and Footers differ from the main body, and what content can be placed there?
• Track Changes function and when would you use it?
• How do you remove duplicate values in a dataset?
• Which system is described as improving customer interactions by consolidating data about a customer's history?
• Which practice promotes accessibility in slide design?
• Which practice reflects good email etiquette in a business setting?
• Circling or otherwise highlighting items of interest and notating or requesting additional information or explanation provides senior executives with the ability to efficiently communicate throughout the executive's area of responsibility. This is a key element of which business application?
• A logistician receives an alert about a delayed supertanker and a set of recommended actions. Which software is most likely in use?
• Operations management in an EIS is primarily concerned with which function?
• What are the three common components of a pivot table?
• Which term describes software that coordinates core business functions across the enterprise and integrates data across departments?
• What is the primary function of a supply chain management (SCM) system?
• What does DSS stand for?
• Select the three key functions of a CRM system.
• Which term best describes software that provides decision makers with information to solve problems in rapidly-changing environments?
• What is a best practice when sharing cloud documents with others?
• ERP stands for Enterprise Resource ______.
• Which company, founded by Patrick and John Collison, provides a software interface for integrating credit card processing with websites and apps?
• The model of a DSS/BI system that adapts based on prior decision accuracy can be called ___ AI.
• HubSpot CRM, Zoho CRM, and Freshsales CRM primarily focus on which business need?
• Predix Platform and ABB's Ability focus on which area?
• Which function best matches Marketing management in an EIS?
• In a manufacturing firm, executives’ visibility over the processes turning raw materials into sale-ready goods is provided by which system?
• Which term describes computer application systems that seek to manage interactions with customers using analytics and data analysis to identify the most valuable customers and target future customers?
• Which system uses analytics to identify the most valuable customers and target future customers?
• What is the difference between a title slide and a content slide, and how should you structure them?
• The key element of an executive information system is a highly intuitive user ___ often referred to as the dashboard.
• In a supply chain management system, what does CRM stand for?
• What is mail merge data source binding and what happens if the data source record is missing fields?
• Which sectors helped establish the credibility of decision support systems in the 1980s and 1990s?
• A key attribute of this software is its ability to integrate status reports of multiple logistics reporting software products, providing the manager with increased visibility from a single dashboard.
• Which company was formed by Jack Dorsey to provide small business owners with card payment processing via iPhones and added aggregator services?
• In SQL, what does the statement structure SELECT FROM WHERE do, and provide a simple example.
• Three functions of CRM include marketing, sales and ___.
• In relational databases, what is meant by a primary key and a foreign key, and why are they important?
• Which term refers to the entire Excel file?
• Decision support system applications designed to meet the needs of executives of larger companies are referred to as which?
• Which of the following is NOT one of the software systems associated with Intuit to create the suite of products that integrate with QuickBooks?
• What is the primary purpose of a template in document creation?
• Which business computer application system typically begins by collecting customer information such as email, telephone, and social media data, and then combines this with information regarding the customer's buying habits, so that the management team can better anticipate customer desires?
• Which term is used for an integrated software suite that coordinates multiple business functions?
• The element of a supply chain management application that may include the product development, manufacturing, and inventory processes is referred to as the___relationship management element.
• A platform that supports and coordinates finance, HR, production, logistics, CRM, and sales typically uses what software?
• In modern business, the term 'decision ___ system' (DSS) is used to describe a class of analytical software. What word completes the blank?
• Which application suite uses advanced modeling to provide the required decision support system, executive information system (EIS) or business intelligence (BI) system, and seeks to coordinate all aspects of an organization?
• Which company is known for its mobile card reader and is also a merchant service aggregator?
• Stripe is known for providing what to websites and apps?
• Providing visibility means that the user interface of any SCM remains a critical component. Typically, a user interface comes in the form of a ___ that calls attention to deviations from an established norm.
• When performing a LEFT OUTER JOIN, what is returned?
• Which term refers to software that focuses on managing supplier relationships, including procurement and collaboration?
• Which company provides financing to merchants through Square Capital?
• Explain the importance of file permissions and sharing settings in cloud storage.
• To provide senior management with visibility of nearly all aspects of an organization's operations, many firms integrate their SCM apps with their ___.
• This Intuit-owned software is the dominant financial services software for small business in the U.S.
• The Dynamics suite is associated with which company?
• What does least privilege mean in access control?
• Which slide design best supports readability and consistency in a presentation?
• Which company was purchased by eBay in 2002 and is now a major merchant service aggregator?
• Which of the following is commonly included as part of the EIS categories alongside HRM and Marketing?
• Which business application provides executives with the information they need to support strategic decisions?
• Which of the following is NOT one of the three major elements of a supply chain management system?
• Which of the following is NOT a merchant service aggregator according to the material?
• Microsoft BI Professional is one of the most popular versions of decision ___ system software.
• What is the purpose of using data filters and how are they applied?
• The inexpensive point-of-sale terminal formed by pairing an iPad with a cash drawer, a thermal printer, and a chip/swipe reader is known as the ___ Stand.
• What is a JOIN in SQL and name at least two types, such as INNER and LEFT OUTER, with brief descriptions.
• What is the primary purpose of forms and reports in a database application?
• One of the largest suppliers of supply chain management and enterprise resource planning software is SAP, based in Walldorf, Germany. SAP stands for Systems,___and Products in Data Processing.
• Which elements can you customize when creating a chart?
• Decision support systems (business intelligence systems) that meet the needs of executives are referred to as executive support systems (ESS) or executive ___ systems (EIS).
• Computer application systems that seek to manage a firm's interactions with customers using analytics and data analysis to identify the most valuable customers and target future customers is the customer___management system.
• Which system typically begins by collecting customer information such as email, telephone, and social media data, and then combines this with buying habits to anticipate customer desires?
• What is a relational database schema and why is it important?
• In the material, Square, PayPal, and Stripe are given as examples of which category?
• Software that provides decision makers with information to solve problems in complex and rapidly-changing environments is commonly referred to as which?
• Which company offers the Dynamics ERP product suite?
• How can you insert a cross-reference, and why would you use one?
• Which of the following is NOT a CRM function?
• Magnetic Ink Character Recognition (MICR) is used to quickly process which type of document?
• Which device became nearly obsolete due to digital card processing methods?
• What is the result of applying data validation with a drop-down list?
• What is SQL injection, and which defense is most effective?
• CRM stands for what?
• Which statement best describes the financial management category in an EIS?
• Which component of a DSS is most important because it determines which decisions are implemented?
• In 2009, Jack Dorsey formed a company to provide a credit card payment system via iPhones. What is the name of that company?
• CRM systems like HubSpot, Zoho, and Freshsales focus on meeting the needs of which type of business?
• Which statement best describes 2NF (Second Normal Form) in relational databases?
• Which statement best describes a transaction processing system?
• What is the name of the leading decision support software suite described as among the most powerful, offered by SAP?
• Select 3 major suppliers of SCM.
• Which notation locks the column but not the row in a cell reference?
• Which statement correctly describes VLOOKUP and its relation to HLOOKUP and XLOOKUP?
• In database terminology, what best defines a field?
• Which company initially sold credit card processing software that could be easily integrated with existing software such as Lyft's, and later began selling POS stations?
• In spreadsheet terms, how do a chart and a graph differ, and name three common chart types?
• What is the purpose of a slide sorter in planning a presentation?
• Which statements describe the data source and main document in a mail merge?
• What action updates the page numbers in a table of contents after edits?
• Which formula would restrict input to whole numbers between 0 and 100?
• Which function counts non-empty cells?
• Which feature generates a table of contents from heading styles and can be updated automatically by updating fields?
• Which statement best describes 1NF (First Normal Form) in relational databases?
• What is the term for systems that enable money to be exchanged for goods and services more efficiently?
• Which statement about the PMT financial function is true?
• In the PMT function syntax, which arguments are optional?
• Which small-business accounting solution is cited as targeting smaller firms?
• Historically, what was the most common transaction processing system for about a hundred years?
• Which function sums values that meet multiple criteria?
• What is a section break and when would you insert one?
• Why should you avoid overusing transitions and animations in slides?
• Which statement about XLOOKUP is true?
• The tools necessary to adequately hedge against significant market fluctuations is provided by____ management software.
• What is cell protection and how would you apply it to prevent edits?
• To ensure adequate spacing for safety of flight, and also track changes in aircraft airspeed and altitude, and alert the controller if any deviations occur that require attention, air traffic controllers use ___.
• ERP roll up information into one dashboard to provide what?
• In executive information systems, the human___management element focuses on differences between actual and expected personnel numbers.
• Why does enterprise resource planning (ERP) software include all of the software used to manage different departments within a corporation?
• ERP stands for which of the following phrases?
• Which statement about absolute and relative cell references is true in spreadsheet formulas?
• Describe left-aligned, centered, and right-aligned text and their common use cases.
• What is the purpose of data validation in spreadsheets?
• What is a typical benefit of integrating SCM into an ERP suite?
• CRM stands for which of the following terms?
• It is far less expensive to retain an existing customer than it is to acquire a new customer. This is the concept behind the use of which business computer application systems?
• In the context of mail merge, which of the following best describes a data source?
• What is the benefit of using a template in document creation?
• Which statement best describes how to achieve consistency in slide design across a deck?
• ERP stands for what?
• James Ritty's invention nicknamed 'Ritty's Incorruptible Cashier' later became known as which device?
• Fund reversals such as returns or disputed credit card charges result in lost processing fees and interest for the acquiring bank. To process credit cards, smaller merchants typically use ___.
• Explain normalization and the purpose of reducing data redundancy, mentioning 1NF and 2NF.
• Which element of an executive information system provides executives visibility into personnel issues?
• Which software application system integrates the management of nearly all aspects of an organization?
• A term for business applications that collect data from internal and external sources to help executives view the competitive landscape is referred to as which of the following?
• How can you embed multimedia and ensure compatibility across platforms?
• How does conditional formatting work in spreadsheets, and what is a common use case?
• Which of the following is NOT one of the software systems associated with Intuit to create the QuickBooks-integrated suite?
• The category that focuses on Sales, promotions, and CRM is which?
• Which technology is commonly known as 'knuckle-busters' for imprinting credit card data on cards?
• The three major components in any DSS include the data warehouse, the decision support model, and the ___ interface.
• In relational database terminology, what is a field?
• Which items are typical indicators of phishing emails, and what countermeasures protect an organization?
• Table of contents: what is its purpose and how can it be updated automatically?
• Which function counts numeric cells?
• What is the primary purpose of reports in a database?
• What is the purpose of using styles in a word processor compared to direct character formatting?
• Enterprise Resource ___ systems complete the ERP acronym; what word fills the blank?