Use the spreadsheet above to write Excel formulas, with functions as needed, to show the results displayed in the following cells.

1. F3: the total amount of cash in for all computers in January.
2. E17: The expense for Chromebook: 20% of the cash in amount in E16
3. E18: The total profit for Chromebook (subtract expenses from cash in)

" " " "" " F | Budget Computers N w Month January 4 February 5 March 6 April 7 May 8 June 9 July 10 August 11 September 12 October 13 November 14 December 15 16 Cash in 17 Expenses 18 Profit Dell $1,213 $1,398 $1,473 $3,288 $858 $1,570 $3,375 $1,649 $3,676 $1,371 $3,776 $3,094 HP $2,575 $1,210 $1,893 $1,771 $2,216 $3,122 $3,697 $3,083 $1,021 $1,088 $905 $1,322 MacBook Chromebook $3,996| $540 $2,415 $3,703 $3,279 $903 $1,619 $2,299 $3,910 $2,165 $1,167 $2,607 $3,425 $1,161 $886 $1,498 $3,143 $1,190 $1,275 $2,574 $1,044 $2,366 $2,873 $3,307 Summary $29,032 $24,313 $5,806 $4,863 $23,226 $19,450 Cash In $8,324.00 $8,726.00 $7,548.00 $8,977.00 $9,149.00 $8,466.00 $11,658.00 $7,116.00 $9,030.00 $6,308.00 $8,091.00 $10,596.00 Exceed Goal? No Yes No Yes Yes No Yes No Yes No No Yes $26,741 $23,903 $5,348 $4,781 $21,393 $19,122 $103,989 $20,798 $83,191 20 Monthly Goal $8,500 # of months 21 exceeding Goal between 7500 22 and 8500