Mixed cell references let you fix one part of a reference while letting the other part move. To lock the column but not the row, put a dollar sign before the column letter and leave the row number without a dollar sign. This keeps the column constant when you copy the formula across columns, while the row can change when you copy the formula down to other rows. For example, the reference would stay anchored to that column as you fill down, but the row number would advance. This is useful when you want all calculations to refer to the same column but to adjust to different rows. The other patterns either fix both parts (never changing) or fix the row or neither part (allowing both to move).

The main idea here is visibility into the end-to-end production process. In manufacturing, executives need to see how raw materials move through planning, scheduling, and execution to become finished goods ready for sale. That broad oversight and control comes from operations management, which is all about designing, coordinating, and controlling production processes to maximize efficiency, throughput, and timely delivery. Systems used in this area—like ERP or manufacturing execution systems—provide real-time data on work-in-progress, inventory levels, bottlenecks, lead times, and capacity utilization, giving leaders a clear view of how materials transform into sale-ready products. Accounting focuses on financial information such as costs and revenues, marketing handles demand and market strategy, and quality control concentrates on meeting quality standards. While each plays an important role, they don’t provide the comprehensive view of the production flow that operations management does.

The concept being tested is what counts as a merchant service aggregator versus a device or method that only captures card data. An imprinter is a physical device used to manually imprint a card’s information onto a slip, which does not actually process, authorize, or settle payments electronically. It doesn’t act as an intermediary between the merchant and the card networks or banks. In contrast, Square, PayPal, and Stripe are modern merchant service providers that handle payment processing end to end—authorizing transactions, routing them through card networks, and arranging settlement—often with additional tools like APIs, dashboards, and point-of-sale integrations. So the imprinter isn’t a merchant service aggregator, while the others are.

The main idea here is that CRM systems are built to manage relationships with customers across the entire lifecycle: attracting interest, guiding the sale, and supporting the customer after purchase. Marketing is the function that creates awareness, runs campaigns, captures leads, and nurtures potential buyers. Sales then takes those leads, tracks opportunities through the pipeline, manages forecasts, and closes deals. Customer service handles post-sale support, handles service requests or tickets, and maintains ongoing engagement to keep customers satisfied and loyal. When you combine these three areas—marketing, sales, and customer service—you cover the end-to-end experience a business has with customers, which is the core purpose of a CRM. Logistics isn’t a typical CRM function because it’s more about supply chain and operations than managing customer relationships. Analytics is a capability often included in CRMs, but it’s not usually listed as one of the three core functional areas; it supports all three by turning data into insights. So the best-fit trio that defines a CRM’s primary scope is marketing, sales, and customer service.

Understanding how cell references behave when formulas are copied is essential. Absolute references lock a row and/or column to the original cell by using a dollar sign before the column and/or row, so the reference stays pointing to that exact cell no matter where you copy the formula. This means you can fix just the column ($A1), just the row (A$1), or both ($A$1), depending on what you want to stay constant. The statement describing this behavior is that absolute references lock a row and/or column to the original cell, which best fits how these references work. Relative references, by contrast, adjust as you copy the formula, so they change to maintain the same position relative to the formula's new location. Absolute references do not change when copied, which is why the other options don’t fit. For example, =A1 copied down becomes =A2, but =$A$1 copied down stays =$A$1.