Which describes the conditions that must be met in order to use subtotal in a spreadsheet? the data must be in adjacent cells and organized in rows using headings. the data must be in adjacent cells and organized in columns using headings. the data must be distributed in different spreadsheets using the same range of cells. the data must be distributed in different tabs within the same spreadsheet using the same range of cells.