GoSkills
Back to lesson
Question
1
of
3
1. If you wanted to add cells A1, and A4 through A6 together, which would be the best formula to use?
=SUM(A1:A6)
=SUM(A1,A4:A6)
=SUM(A1,A4,A5,A6)
Don’t know
2. There is data in the cells B4:B15, with the following formula used to subtotal the data in B9: =SUBTOTAL(9,B5:B8). Which would be best formula to ensure that we’ve summed up all values from B4 through B15?
=SUBTOTAL(9,B4:B15)
=SUM(B4:B15)
=SUM(B4,B9:B15)
Don’t know
3. A5 shows a value of 1234.56. Which of the following methods would you use to round the value 1235?
=ROUND(A5,-1)
Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice.
=ROUND(A5,0)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement