Toggle navigation
GoSkills
Search for courses or lessons
Courses
Microsoft Excel
Design
Office Productivity
Microsoft Office
Finance
Project Management
Development
Soft Skills
Microsoft Excel
Excel - Basic
Excel - Advanced
Excel - Basic & Advanced
Excel - Pivot Tables
Excel - Macros and VBA
Excel - Dashboards
Excel for Mac - Basic
Excel for Mac - Advanced
View more »
Design
Photoshop for Beginners
Photoshop - Advanced
Illustrator - Basic
Office Productivity
Keynote for Mac
Evernote
Trello
Google Drive & Apps
Microsoft Office
PowerPoint
Word - Basic & Advanced
Word - Basic
Word - Advanced
Project Fundamentals
Access - Basic
Outlook
Publisher
View more »
Finance
For Non-Financial Professionals
For Operations Managers
For Project Managers
For Operations Directors
Financial Modeling Basics
Financial Modeling Techniques
Project Management
Project Management Basics
PM for Team Members
PM for Business Professionals
PM for Engineers
PM for Experts
PMP Certification Training
Scrum for Team Members
Scrum for Managers
View more »
Development
Introduction to HTML
Introduction to CSS
Introduction to JavaScript
Introduction to PHP
Introduction to SQL
Soft Skills
Business Writing
Public Speaking
Body Language
Team Leadership
Press Releases
Customer Service Training
Introduction to Sales
Leadership Training
View more »
Coming soon
Illustrator - Advanced
Ruby on Rails for Web Development
Intro to Ruby Programming
Excel - Power Query
Get all these courses for only
$39
/month
Learn more
For
Business
Teach
Blog
Redeem a coupon
Sign up
Search
Cart
Login
Quiz
1
Intermediate
What is the main benefit of using Styles?
The color choices are better with styles than with standard formatting alone.
It is easy to update all similarly formatted cells at once if it's needed.
It is easy to apply multiple formatting components at once.
Don’t know
2
Intermediate
Suppose you want to apply a currency style to a set of numbers as quickly as possible. After having selected the numbers, what do you do next?
Go to the Home tab, click Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery) and then choose Currency.
Go to the Home tab and click the $ on the Numbers group.
Right click the selection and choose Format Cells, and then select Numbers and Currency and click OK.
Don’t know
3
Intermediate
How do you modify a custom style to force the changes through your workbook?
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), and then right click your Style and choose Modify.
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), delete the old style, and then click New Style and name it the same as the old style.
Right click any cell that uses the style, and choose “Modify cell style”.
Don’t know
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement