if you could use the excel formulas for the answers that would be really helpful

The Client wants to better understand how floors and ceilings work with respect to itemized deductions. As suchryou have been asked to prepare a functional spreadsheet emulating Schedule A to demonstrate the calculations using formulas. Required: 1. Complete Schedule A using formulas to calculate applicable lines. Itemized deduction amounts have already been entered. (Hint: use a Cell Reference the Adjusted Gross income amount provided below in Cell D10.) Form 1040 Line 11 - Adjusted Gross income: 10 Add lines 8e and 9 11 eifts by cash or check. If you made any gift of $250 or more, see Gifts to instructions. 100 Caution: If you 12 Other than by cash or check. If you made any gitt of $250 or more, see 40 made a gift and instructions. You must attach form 8283 if over $500. got a benefit for it, 13 Carryover from prior year \begin{tabular}{ll} Casualty and & 14 Add lines 11 through 13 \\ \hline Casualty and theft loss(es) from a federally deciared disaster fother \end{tabular} Theft Losses than net quatifted disaster losses). Attach form 4684 and enter the 43 amount from line 18 of that form. See instructions. 44 Other 16 Other -from list in instructions. List type and amount 45 itemized 46 Deductions Gambling Losses to Extent of Winnings Total 17 Add the amounts in the far right column for lines 4 through 16. Also, 47 itemixed enter this amount on Form 1040 or 1040-5R, line 12. Deductions 18 If you elect to itemize deductions even though they are less than your standard deduction, check this box