Question 1
Which notation locks the column but not the row in a cell reference?
Correct Answer:
$A1
Explanation:
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).
Question 2
In a manufacturing firm, executives’ visibility over the processes turning raw materials into sale-ready goods is provided by which system?
Correct Answer:
Operations management
Explanation:
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.
Question 3
Which of the following is NOT a merchant service aggregator according to the material?
Correct Answer:
Imprinter
Explanation:
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.
Question 4
Select the three key functions of a CRM system.
Correct Answer:
Marketing; Sales; Customer Service
Explanation:
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.
Question 5
Which statement about absolute and relative cell references is true in spreadsheet formulas?
Correct Answer:
Absolute references lock a row and/or column to the original cell.
Explanation:
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.
Question 1
Exam overview

About this Exam

Prepare with the Business Computer Applications Practice Test practice quiz. This question bank includes 10 questions covering cell, notation, locks, business, and computer. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Business Computer Applications Practice Test

This practice set contains 10 questions from the matching question bank and focuses on cell, notation, locks, business, and computer. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions