Unknown-3

CIS EXAM 1 Study online at https://quizlet.com/_drqdyv A recent report in Forbes suggests that what percent of firms are failing at digital transformation? 72% Amazon was started by: Jeff Bezos T/F Data analytics and business intelligence are driving discovery and innovation. True A company uses radio frequency identification (RFID) tags to keep track of its inventory. This is an example of the impact of technology in the area of _____. operations T/F Facebook was founded by Sergey Brin. False Experts working in the area of _____ work to make sure systems are easy to use, while people working in the area of _____ work to leverage technology to make firms more efficient. user-interface design; process design T/F David Karp, founder of the website Tumblr, sold the website to Google for $1.1 Billion False Another reason fueling the boom in fast-growing technology ser- vices is ___________________, which, when done right, can virally spread awareness of a firm with nary a dime of conventional ad spending. App stores T/F Apple's growing business of consumer services bring in so much revenue that if they were a separate division from Apple, they would be ranked as a Fortune 100 firm. True T/F Crowdsourcing tools and question-and-answer sites like _____ allow firms to reach out for expertise beyond their orga- nizations. Quora A(n) _____ is the symbolic embodiment of all the information connected with a product or service. brand A trademark is the symbolic embodiment of all the information connected with a product or service of a firm. false According to Michael Porter, the reason many firms suffer mar- gin-eroding competition is because they have defined themselves according to strategic positioning rather than operational effec- tiveness. false A strong brand can be an exceptionally powerful resource for competitive advantage by lowering ________, proxying _____ and inspiring _____. search costs; quality; trust A salesperson's ability to effectively bargain with his/her con- sumers is called viral marketing. false According to Porter, strategy is fundamentally about being _____. different A firm can benefit from high switching costs, even when rivals offer free products. true A firm is said to be _____ when it attempts to match the benefits of a successful position while maintaining its existing position. straddling A firm's financial performance that consistently outperforms its industry's peers is known as _____. sustainable competitive advantage A firm's financial performance that consistently outperforms its industry's peers is known as operational effectiveness. false FreshDirect regained customer trust by: addressing the problem head on and correcting errors as quickly as possible Entry into the online grocery market can be costly for FreshDirect competitors because it would be challenging to obtain a distribution facility in the same area. At the start of the pandemic, FreshDirect saw an increase in online orders. Website traffic increased by _______ percent. 800 1 / 7

CIS EXAM 1 Study online at https://quizlet.com/_drqdyv Early attempts at the online grocery business were unsuccessful because consumers were fine with the conventional way of shopping. FreshDirect opted for customer-focused error handling because it was less expensive than losing a lifetime of orders from the customer. FreshDirect lost ___ percent market share of the New York grocer market after the move to the larger facility. 20 As an essential service during the pandemic, FreshDirect met the growing demands by limiting variety, working with the boroughs to address food inse- curity, and adding jobs. A major threat to the FreshDirect model is: potential entry of better funded, growth-seeking rivals After the move to the new facility, FreshDirect switched ___ per- cent of the orders from the old system to the new. 100 CEO and co-founder Dave McInerney's main goal of launching FreshDirect was to address the quality gap between store-bought and restaurant goods. High-end fashion house Prada's experiment of implementing the latest technology in its flagship store failed because: The execution of the technological advancements was poor and didn't work well during customer interactions, so managers and staff stopped using it. Goods to be further customized based on designer/manager col- laboration are called greige. true Elaborate customer surveys help Zara designers predict fashion trends months into the future and design products accordingly. false According to an independent study, Zara books some 85 percent of its products at full price compared to the industry average markdown ratio of 50 percent. This is made possible by: the practice of having limited production runs of its designs. Due to limited production runs, Zara's customers: visit the stores more often. Factors such as weather, natural disaster, terrorism, labor strife, or political unrest can shut down a firm's operations. Which of the following is one of the measures taken by firms to hedge such risks? Spreading productions facilities across the globe Contract manufacturers used by the apparel industry are often criticized because: of poor working conditions. An information system consists of hardware, software, data, pro- cedures, and the people who interact with and are impacted by the system. true At Zara, clothes are ironed in advance and packed on hangers, with security and price tags affixed. This system means that em- ployees in Zara stores simply move items from shipping box to store racks, spending most of their time on: value-added functions like helping customers find what they want. A value chain is a set of: activities through which a product or service is created and deliv- ered to customers. Based on the author's take on e-waste management, a manager would do well to learn that: disposal and recycling partners must be audited with the same vigor as suppliers and other partners. The managerial definition of Moore's Law suggests that com- puting costs related to chips (microprocessors and silicon-based storage) double every eighteen months. False Moore's Law has impacted the camera industry such that the firms that sell the most cameras aren't camera companies, but phone manufacturers. True E-waste is particularly difficult to address because of: the complexity of the modern value chain. A Microprocessor is a fast chip-based volatile storage in a com- puting system. False E-waste management is extraordinarily difficult to monitor and track, and loopholes are rampant. True 2 / 7

CIS EXAM 1 Study online at https://quizlet.com/_drqdyv =B6/B$10 is an example of what reference type? mixed reference Which Excel feature is used to combine multiple cells into a single cell? merging Which of the following is a common mathematical operator used in Excel formulas? * An absolute reference is used to turn off relative referencing so that when the formula is copied or to a different location it doesn't change. True What is the relation between function and formula in Excel? A function is a pre-built formula that performs specific calculations or operations on data. Which of the following is a valid cell reference in Excel? A$1 When you open a new workbook it could contain multiple work- sheets with cells, rows, and columns. True What is the primary purpose of the "Filter" feature in Microsoft Excel? Displaying specific data that meets certain criteria, while hiding the rest. What is the file extension for an Excel workbook in the latest version of Microsoft Excel? .xlsx Which of the following is a feature of Excel for range formatting? Applying a custom number format to display values in a specific way, such as adding commas to large numbers. What is the correct function to calculate the value of all orders marked COMPLETED? =SUMIF (D2:D9,"completed",C2:C9) Which Paste Special option pastes just the cell contents without any formatting? Values What does the "Sort" feature in Microsoft Excel allow you to do? Rearrange data in a selected range based on specified criteria, such as alphabetical order or numerical value. Which of the following is a feature of Excel "PasteSpecial" Transposing the data from rows to columns or vice versa. Which of the following formulas is used to calculate the average order amount of a given range of numbers? =SUM (C2:C9)/COUNT (C2:C9) Which of the following is a special feature of Excel tables? Automatic data sorting and filtering capabilities. If the criteria for COUNTIF is entered directly into the formula, it must be a text string. True Which type of chart in Microsoft Excel is best suited for displaying trends over time? Line Chart What is the main purpose of the "COUNTIF" function in Excel? Counting the number of cells within a range that meets a specific condition. What does the "PIE CHART" in Microsoft Excel represent? The proportion of each data point in a series to the sum of all data points, shown as slices of a circle. Which Excel feature is used to highlight cells based on their values or conditions? Conditional Formatting What is the correct function to mark the order as INTERNATION- AL if the order# is equal or greater than 200.? =IF(A7>=200,"INTERNATIONAL","DOMESTIC") 4 / 7

CIS EXAM 1 Study online at https://quizlet.com/_drqdyv What is the primary benefit of using the "Sort" feature in Microsoft Excel? It organizes data in a specific order, making it easier to analyze and find information. Which keyboard command can be used to format data as a table? COMMAND + T (Mac) / Ctrl + T (Windows) What type of chart is best suited for showing the relationship between two sets of numerical data in Microsoft Excel? Scatter Chart Which number format displays values with decimal places, even when they are all zeros? a. Accounting b. Currency c. Number d. General e. Standard general When working with a large dataset that is too big to view at once, you can keep the upper rows and columns on the left visible all times using which command? View Freeze Panes Freeze Row Freeze Column Sort Freeze Panes Which type of chart connects data points with a continuous line? line Which of the following is true with respect to the COUNTIF func- tion? a. The cell range used to define the criteria argument is what the function will count and use for the output. b. Any cell that contains a numeric value and matches the value used to define the range argument will be counted. c. Only cells that contain a numeric value and match what is used to define the criteria argument will be counted. Cells containing words or text entries will be ignored. d. The value used to define the range argument will be searched in the cell range used to define the criteria argument. e. The value used to define the criteria argument will be searched in the cell range used to define the range argument. The value used to define the criteria argument will be searched in the cell range used to define the range argument. When using the SUMIF function, which of the following best describes the purpose of the Range argument? a. range of cells where the function will search for the data used to define the criteria argument b. range of cells that contain data to determine which cells will be summed by the function c. range of cells that will be selectively summed based on the data used to define the criteria argument d. used to determine if the function will search for an exact match (1) or approximate match (0) for the data used to define the criteria argument e. range of cells where the function will search for the data used to define the criteria argument and is also the range of cells that will be selectively summed if the [sum_range] argument is not defined range of cells where the function will search for the data used to define the criteria argument and is also the range of cells that will be selectively summed if the [sum_range] argument is not defined When using the SUMIF function, which of the following best describes the purpose of the Criteria argument? a. range of cells where the function will search for the data used to define the criteria argument b. range of cells that contain data to determine which cells will be summed by the function c. range of cells that will be selectively summed based on the data used to define the criteria argument d. used to determine if the function will search for an exact match (1) or approximate match (0) for the data used to define the criteria argument range of cells that contain data to determine which cells will be summed by the function 5 / 7

CIS EXAM 1 Study online at https://quizlet.com/_drqdyv If you have selected a row, right-clicking and choosing Insert will add a new, blank row below the selected one. False A major advantage of formatting data as a table in Excel is that it uses advanced functions that only use the lines of data actually displayed. True The criteria for COUNTIF must be a text string. True In conditional formatting, when you have several rules in the Manage Rules list, each rule takes precedence over those below it. True Multiple slicers can be added to analyze a single pivot table. True Four percentages were calculated by entering =A6/A10 in cell C6 and then autofilling the formula into cells C7, C8, and C9. Rewrite the formula so that the denominator doesn't change when the formula is copied or autofilled. =A6/$A$10 Assume that there is data entered in a worksheet in the cell range A1:A117. You realized that you need to add a row of data between rows 9 and 10. Describe the steps that you would take to insert a new row. Select Row 10, right-click, and select Insert. Or, on the Home tab, select Insert, and Insert Cells. The column letters at the top of a worksheet are as follows: A C D E F. Explain why column B is missing. The column is hidden. Which chart should be used to show the relationship between two numeric variables by plotting pairs of values as points. scatter chart Assume the number 70 is entered into cell A5 on an Excel work- sheet. In cell C5, an IF function will be entered to produce an output based on the value in cell A5. If the value in cell A5 is less than 70, the output of the IF function should be the words NO ACTION. Otherwise, the output of the IF function should be the word ACTION. Write this IF function as if you were entering it into cell C5 on an Excel worksheet. =IF(A5<70, "NO ACTION", "ACTION") The following COUNTIF function was entered into a cell on an Excel worksheet: =COUNTIF(A2:A107, B2) The function will search for a match in the range A2:A107 to the entry in cell B2 The COUNTIF function is being used to summarize data at the top of a worksheet. The function will be used to count the number of investments that are in the Stock category in the dataset that begins in row 10 of the worksheet. The word Stock is entered into cell B2 on the worksheet. The range C10:C30 contains the investment categories: Bond, Stock ETF, and Stock. The range D10:D30 contains the investment cost and the range E10:E30 contains the current investment value. How should this function be entered into the worksheet? Write the function below as if you were entering it into an Excel worksheet. =COUNTIF(C10:C30,B2) or =COUNTIF($C$10:$C$30,B2) Why should column headings in the first row of a dataset be included in the highlighted range before creating a pivot table? The column headings will be shown as the field names in the PivotTable Field Names window pane. The field names are then used to arrange the PivotTable report. 7 / 7