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

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