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