Data Visualization and Dashboards with Excel and Cognos Quiz Answers

Data Visualization and Dashboards with Excel and Cognos Week 01 Quiz Answers

Q1. What is a capability of line charts?

• Compare the frequency of data sets
• Compare different, unrelated data sets
• Compare similar, unrelated data sets
• Compare different, but related data sets

Q2. Each portion of a pie chart represents static values or categories. What is the sum of the categories equal to?

• 50%
• 100%
• 75%
• 99%

Q3. According to the ‘Introduction to Charts’ video, which chart is one of the most commonly used?

• Scatter chart
• Bar chart
• Funnel chart
• Bubble chart

Q4. In the ‘Expert Viewpoints: Using Visualizations to Tell a Data Story’ video, one expert mentioned two software programs that help highlight the important information. Which were the two software programs?

• PowerPoint and Excel
• Db2 and SQL

Q5. In the ‘Creating Basic Charts in Excel’ video, which type of chart shows the relative contribution of unit sales from Ford car models?

• Pie chart
• Bar chart
• Funnel chart
• Line chart

Q6. How does a pivot chart differ from a standard chart in Excel?

• A pivot chart contains data series, categories, and chart axes
• A pivot chart cannot be a line, pie or bar chart
• A pivot chart uses data from a pivot table
• A pivot chart always has its data arranged in columns and rows

Q7. What is the main difference between Area and Column charts?

• A column chart uses vertical bars, and an area chart uses data points
• A column chart uses data points, and an area chart uses vertical bars
• An area chart uses horizontal bars, and a column chart uses rows
• An area chart makes sense of complicated data and a column chart shows chart axis like basic charts

Data Visualization and Dashboards with Excel and Cognos Week 02 Quiz Answers

Q1. What do treemaps use to represent hierarchical data categories?

• Treemaps use data points on a line.
• Treemaps use interconnected circles.
• Treemaps use color, size, and closeness of shapes.
• Treemaps use different shapes.

Q2. Histograms can look like a bar chart, what’s the key difference?

• Bar charts compare data and histograms display the distribution of data.
• Histograms use bins.
• Histograms use Axis Options to display different bin sizes.
• Bar charts use horizontal bars.

Q3. What kind of data works best with filled map charts?

• Complicated data
• Data containing geographical regions
• Scientific data
• Raw data

Q4. What are sparklines typically used for?

• To show regional information.
• To highlight a data range.
• To contrast numerical values.
• To show data trends.

Data Visualization and Dashboards with Excel and Cognos Week 03 Quiz Answers

Q1. When signing up for a trial of Cognos Analytics, which item in the account form is the key one to take note of?

Q2. In Cognos Analytics what is the first step to build a dashboard?

• Provide questions and answers to the assistant
• Select visualizations
• Choose a template

Q3. Which of the following methods can be used in Cognos Analytics to create visualizations? (Select all that apply)

• By using widgets.
• By using the Assistant to suggest questions and suggested visualizations.
• By automatic recommended visualizations.
• By manually populating by dragging and dropping.

Q4. How can you create infographics in Cognos Analytics?

• Use Exclude to filter out some data.
• Ask the Assistant different questions.
• Drag and drop a widget shape icon onto a visualization.
Get all Course Quiz Answers of IBM Data Analyst Professional Certificate

Introduction to Data Analytics Coursera Quiz Answers

Excel Basics for Data Analysis Coursera Quiz Answers

Data Visualization and Dashboards with Excel and Cognos Quiz Answers

Python for Data Science, AI & Development Coursera Quiz Answers

Python Project for Data Science Coursera Quiz Answers

Databases and SQL for Data Science with Python Coursera Quiz Answers

Team Networking Funda

Welcome to the official Author Page of Team Networking Funda! Here, we are dedicated to unraveling the intricate world of networking, connectivity, and team dynamics. Our mission is to provide you with insightful, actionable advice and solutions that will help you build strong connections, foster collaboration, and achieve success in all aspects of your professional life.

🌐 Networking Insights: Dive into the art of networking with us, as we explore strategies, tips, and real-world examples that can elevate your networking game. Whether you're a seasoned pro or just starting, we have valuable insights to offer.

🤝 Team Synergy: Discover the secrets to creating high-performing teams. We delve into team dynamics, leadership, and communication to help you unlock the full potential of your team and achieve outstanding results.

🚀 Professional Growth: Explore the tools and techniques that can accelerate your professional growth. From career development to personal branding, we're here to guide you toward achieving your goals.

🌟 Success Stories: Be inspired by success stories, case studies, and interviews with experts who have mastered the art of networking and teamwork. Learn from their experiences and apply their insights to your journey.

💬 Engage and Connect: Join the conversation, leave comments, and share your own networking and team-building experiences. Together, we can create a vibrant community of like-minded professionals dedicated to growth and success.

Stay tuned for a wealth of resources that will empower you to excel in your professional life. We're here to provide you with the knowledge and tools you need to thrive in today's interconnected world.

We are Team Networking Funda, a group of passionate authors and networking enthusiasts committed to sharing our expertise and experiences in the world of networking and team building. With backgrounds in [Your Background or Expertise], we bring a diverse range of perspectives and insights to help you navigate the challenges and opportunities of professional networking and teamwork.

error: Content is protected !!