Back to lesson
1. Which is the best formula to add cells A1 and A4:A6 (A4 through A6) together?
2. Suppose cells B4:B15 contain data, and the formula =SUBTOTAL(9,B5:B8) returns the subtotal reported in B9. Which is the best formula to ensure all values from B4 through B15 are summed up?
3. Suppose cell A5 contains the value 1234.56. Which formula or method rounds this value to 1235?
Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement