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