Cases of such discrimination against heterosexual workers have been documented in places such as California, Arizona, and Minnesota. Most employers discriminate against unmarried workers when it comes to employee benefits, giving more benefits compensation to married employees than to single employees.
pivot table. A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the spreadsheet or database itself.
The Average Function. The Average function in a pivot table works like the AVERAGE function on the worksheet to calculate the average (mean) of the values. It totals all the underlying values in the Values area, and divides by the number of values.hen you use the Average summary function, the results will probably show a strange mixture of decimal places, as shown in the pivot table at the left, in the screen shot below. Format the field to have a consistent number of decimal places (as in the pivot table at the right, above), so the numbers are easy to compare.