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
If the value in cell B3 is 3/31/2015, what formula would you enter in cell C3 to return the last day of the next month?
=MONTH(B3)
=EOMONTH(B3,1)
=EDATE(B3,1)
Don’t know
2
Beginner
How do you set minimum or maximum units on a chart axis?
Click on the axis, click on Select Data in Chart Tools tab, and set them in the Horizontal Axis Labels section
Right click on the chart, select Format Plot Area, and set them in the Plot Area Options section
Right click the axis, select Format Axis, and set them in the Axis Options section
Don’t know
3
Beginner
In the following chart, the black line is being plotted on top of the orange line (the line with markers). How would you change this, so that the orange line is showing on top of the black line?
Select the chart, go to Chart Tools ⇒ Design ⇒ Select Data and use the arrows to move the Black series to the top of the plot order
Select the chart, go to Chart Tools ⇒ Design ⇒ Select Data and use the arrows to move the Black series to the bottom of the plot order
Select the chart, go to Chart Tools ⇒ Design ⇒ Select Data and drag the Black series to the top of the plot order
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement