Q. I receive regular spreadsheets with all of our company’s accounts, departments, employees, and balances, and I have to subtotal the amounts by accounts, departments, etc. I have been manually doing ...

You can find the Average of a value by selecting the cell below or to the right of values that you want to Average. Then go to the Editing Group, select the Auto-Sum Tool. You will see a drop-down ...