Toggle navigation
GoSkills
Search for courses or lessons
Courses
Microsoft Excel
Finance
Microsoft Office
Lean Six Sigma
Project Management
Office Productivity
Soft Skills
Development
Design
Microsoft Excel
Excel - Basic
Excel - Advanced
Excel - Basic & Advanced
Excel - Pivot Tables
Excel - Macros and VBA
Excel - Dashboards
Excel - Power Query
Excel - Power Pivot
View more »
Finance
For Non-Financial Professionals
For Operations Managers
For Project Managers
For Operations Directors
Financial Modeling Basics
Financial Modeling Techniques
Microsoft Office
PowerPoint
Word - Basic & Advanced
Word - Basic
Word - Advanced
Project Fundamentals
Access - Basic
Outlook
Publisher
View more »
Lean Six Sigma
Yellow Belt
Principles - Green Belt
Statistical Process Control
Measurement Systems Analysis
Hypothesis Testing
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 »
Office Productivity
Keynote for Mac
Evernote
Trello
Google Drive & Apps
Essential Productivity Training
Soft Skills
Business Writing
Public Speaking
Body Language
Team Leadership
Press Releases
Customer Service Training
Introduction to Sales
Leadership Training
View more »
Development
Introduction to HTML
Introduction to CSS
Introduction to JavaScript
Introduction to PHP
Introduction to SQL
Design
Photoshop for Beginners
Photoshop - Advanced
Illustrator - Basic
Coming soon
Illustrator - Advanced
Ruby on Rails for Web Development
Intro to Ruby Programming
Advanced Principles - Black Belt
Get all these courses for only
$39
/month
Learn more
For business
Business
Teach
Blog
Redeem a coupon
Sign up
Search
Cart
Login
Quiz
1
Beginner
What is a contiguous data range?
A range of data with no blank cells
A range of data uninterrupted by blank rows or columns
A range of data made up of distinct values
Don’t know
2
Beginner
How do we create a contiguous range?
Sort it so that all data types are together
Go to the Data tab and click the Make Contiguous button
Remove all blank rows and columns
Don’t know
3
Beginner
To create a contiguous range, we can enter values all the way down the column immediately next to multiple non-contiguous ranges. What is the main benefit of doing this?
It allows us to use the range as a PivotTable data source
It allows us to sort and filter the data
It allows us to write better formulas
Don’t know
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement