Calculate line item totals and grand sums in spreadsheets by multiplying unit price and quantity, then formatting the results as currency.