Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
What is MOD(-12,5)?
#N/A
2
3
Don’t know
2
Beginner
Which of the following formula copied across row 1 (starting in cell A1) would NOT loop through the numbers 1, 2 and 3?
=MOD(COLUMNS($A2:A2)-1,3)+1
=MOD(COLUMNS($A2:A2),3)+IF(MOD(COLUMNS($A2:A2),3)=0,3)
=MOD(ROWS($A2:A2)-1,3)+1
Don’t know
3
Beginner
Which of the following is true about the MOD(number, divisor) function?
It only works with integers (whole numbers)
Its result can vary between zero and a number strictly less than divisor
It only works with positive numbers
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement