Can you do 1-Apr through 30-AprAnd then give the total

5 Look at the information below in the table concerning the credit card used for the month of April (30 days). The information shows a beginning balance, payment, and card usage. Complete the spreadsheet to calculate the average daily balance for the card. The Average Daily Balance should be shown in cell F14. Date Transaction Balance 8 1-Apr $671.90 2-Apr Payment $70.00 10-Apr Groceries $109.42 20-Apr Fast Food $18.19 11 12 13 Date Transaction Amount Balance Average Daily Balance 4 1-Ap 15 2-Apr 16 3-Apr 17 4-Apr 18 5-Apr 9 6-Apr 7-Apr 8-Apr 9-Apr 10-Apr 11-Apr