GoSkills
Back to lesson
Question
1
of
3
1. What is MOD(-12,5)?
2
3
#N/A
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)-1,3)+1
=MOD(COLUMNS($A2:A2),3)+IF(MOD(COLUMNS($A2:A2),3)=0,3)
Don’t know
3. Which of the following is true about the MOD(number, divisor) function?
It only works with positive numbers
Its result can vary between zero and a number strictly less than divisor
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