Spreadsheet Formulas & Functions

1. Add cells A1 A2. =A1+A2 =A1-A2 =SUM(A1+A2)*2 2. Use a function that will add the cell range B1:B10. =B1+B10 =MAX(B1:B10) =SUM(B1:B10) 3. Use a function that will find the largest number in the cell range C5:C15. =C5-C15 =MAX(C5:C15) =MIN(C5:C15) 4. Use a function that will find the smallest number in the cell range X8:X13. =MAX(X8:X13) =X8+X13 =MIN(X8:X13) 5. Subtract cells Z10 Z11. =Z10-Z11 Z10+Z11 =Z10*Z11 6. Write a formula that will add the numbers in Row 3, Columns A, C, and D. =A3+C3+D3 =A3+A4+A5 =3A+3C+5D 7. The value for C7 is 2, C8 is 4, and F4 is 2. What is the result of the equation = (C7+C8)*F4 10 12 30 8. Use a function that will find the average or the numbers in Row 4, Columns A, B, C, and D. =A1+A2+A3=A4 =A4+B4+C4+D4 =AVERAGE(A4:D4) 9. Calculate the average of cells D1:D10. =AVERAGE(D1:D10) =MAX(D1:D10) =MIN(D1:D10) 10. Multiply the sum of the range of cells A7 through B10 by C5. =(A7:B10)*C5 =SUM(A7:B10)*C5 =SUM(A7:B10)