Amt Received column – total, Amt Owed column - total Q4-6 sheet: split at row 23 2 pts Q7 sheet: data filtered to display individual donors 4 pts whose amount owed is greater than zero. Then sorted by pledge date, with the oldest date displayed first Q8 sheet: data filtered to display records that have 4 pts a pledge date in October through December, then Sort the filtered data by amount pledged, largest first. Q9 sheet: filtered data sorted by fund name in 4 pts ascending (A to Z) order, then he table converted to a range, then filter the data to display only records with an amount received greater than zero. Q9 sheet: subtotals to calculate and display the 6 pts total amount received for each fund. The subtotal should be calculated for each fund name, and the Grand Total should appear at the bottom of the Amt Received column. File named & saved correctly 1 pt
Amt Received column – total, Amt Owed column - total Q4-6 sheet: split at row 23 2 pts Q7 sheet: data filtered to display individual donors whose amount owed is greater than zero. Then sorted by pledge date, with the oldest date displayed first 4 pts Q8 sheet: data filtered to display records that have a pledge date in October through December, then Sort the filtered data by amount pledged, largest first. 4 pts Q9 sheet: filtered data sorted by fund name in ascending (A to Z) order, then he table converted to a range, then filter the data to display only records with an amount received greater than zero. 4 pts Q9 sheet: subtotals to calculate and display the total amount received for each fund. The subtotal should be calculated for each fund name, and the Grand Total should appear at the bottom of the Amt Received column. 6 pts File named & saved correctly 1 pt