Question

select the correct answer
patricia works in a garment shop and manages the inventory of items. for each item, she needs to record the quantity in stock and the quantity sold
how should she maintain the data?
a. store quantity in stock and quantity sold in two separate columns in a single spreadsheet
b. store quantity in stock and quantity sold in a single column
c. store quantity in stock and quantity sold in two separate workbooks
d. store quantity in stock and quantity sold in a single cell

Explanation:

• Option A: Using two separate columns in a single spreadsheet is logical. Each item can have its quantity in stock and quantity sold recorded side - by - side for easy comparison and analysis. It allows for straightforward data entry, sorting, and calculation (e.g., calculating remaining stock as quantity in stock - quantity sold).
• Option B: Storing both in a single column would make it difficult to distinguish between quantity in stock and quantity sold. There would be no clear demarcation of the two different types of data for each item.
• Option C: Using two separate workbooks is an over - complication. It would be harder to relate the quantity in stock and quantity sold for the same item as one would have to switch between workbooks.
• Option D: A single cell cannot effectively hold two different data values (quantity in stock and quantity sold) for each item in a way that is useful for inventory management.

Answer:

A. store quantity in stock and quantity sold in two separate columns in a single spreadsheet