Question

A worksheet of faculty members at your university contains these columns in this sequence: rank, last name, first name, department, and salary. what is the first step to subtotal departmental salaries

Answer 1

The first step would require that you organize entries by department. If these items are in a worksheet, the worksheet software should have a "sort by" feature that allows you to organized by the department column. Then you can add up salaries by department to get their subtotals.