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,A4,A5,A6)
=SUM(A1:A6)
=SUM(A1,A4: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,B9:B15)
=SUM(B4: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,0)
=ROUND(A5,-1)
Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice.
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement