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
Advanced
Assume that A5 contains 48 and A6 contains 40. A custom conditional format rule is set up over A5 and A6 that reads =$A$5>45 and sets a red font. What color will the font be in A6?
There is not enough information to tell.
The default on the cell (the rule is false, so won’t trigger a change)
Red
Don’t know
2
Advanced
Cell D5 has two conditional formatting rules in place, in this order from top to bottom. Rule 1: Turns the font blue if the value is over 10. The author clicked the "Clear" button on the Fill tab when creating the rule. Rule 2: Turns the background yellow and the font red if the value is over 20. What do we need to do in order to have a value of 25 show with a red font and a yellow background?
Put the yellow rule first
Put the yellow rule first and select Stop if True
Put the blue rule first and select Stop if True
Don’t know
3
Advanced
Cell D5 has two conditional formatting rules in place, in this order from top to bottom. Rule 1: Turns the font blue if the value is over 10. The author clicked the "Clear" button on the Fill tab when creating the rule. Rule 2: Turns the background yellow and the font red if the value is over 20. The value in D5 is currently 25. What will the color scheme be?
Blue font, yellow background
Blue font, white background
Red font, yellow background
Don’t know
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement