GoSkills
Back to lesson
Question
1
of
3
1. What is MOD(-12,5)?
#N/A
3
2
Don’t know
2. Which of the following formula copied across row 1 (starting in cell A1) would NOT loop through the numbers 1, 2 and 3?
=MOD(ROWS($A2:A2)-1,3)+1
=MOD(COLUMNS($A2:A2),3)+IF(MOD(COLUMNS($A2:A2),3)=0,3)
=MOD(COLUMNS($A2:A2)-1,3)+1
Don’t know
3. Which of the following is true about the MOD(number, divisor) function?
Its result can vary between zero and a number strictly less than divisor
It only works with positive numbers
It only works with integers (whole numbers)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement