Question
Patricia works in a coffee 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
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
Answers
GPT-4o mini
The best approach for Patricia to maintain the inventory data would be:
**A. store quantity in stock and quantity sold in two separate columns in a single spreadsheet**
This method allows for clear organization, easy tracking of each item's stock level and sales, and straightforward calculations (such as total inventory or sold items). Separate columns help avoid confusion and make it easier to manage the data effectively.
**A. store quantity in stock and quantity sold in two separate columns in a single spreadsheet**
This method allows for clear organization, easy tracking of each item's stock level and sales, and straightforward calculations (such as total inventory or sold items). Separate columns help avoid confusion and make it easier to manage the data effectively.