Exam (elaborations)
CGS Excel Chapter 3 Questions &Exam (elaborations) answers 100% satisfaction guarantee
CGS Excel Chapter 3 Questions &Exam (elaborations) answers 100% satisfaction guarantee
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
Content preview
CGS Excel Chapter 3What type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four
years?
(a. Pie chart)
(b. Line chart)
%
(c. Column chart)
(d. Bar chart) - ✔✔a. Pie chart
Look at the stacked bar chart in figure 3.35. Which of the following is a category on the category axis?
(a Thousands)
(b. Job Titles)
0
(c. CIS Managers)
(d. 700) - ✔✔c. CIS Managers
Which of the following is not a type of sparkline?
(a. Line)
0
(b. Bar)
(c. Column)
(d. Win-Loss) - ✔✔b. Bar
1
If you want to show exact values for a data series in a bar chart, which chart element should you
display? - ✔✔Data labels
The value axis currently shows increments such as 50,000 and 100,000. What option would you
select to display the values in increments of 50 and 100? - ✔✔Show axis in Thousands
You want to create a single chart that shows each of the five divisions proportion of yearly sales for
each year for five years. Which type of chart can accommodate your needs? - ✔✔100% stacked
column chart
Currently, a column chart shows values on the value axis, years on the category axis, and state
names in the legend. What should you do if you want to organize the data with the states on the
category axis and the years shown in the legend? - ✔✔Click Switch Row/Column in the Data group
on the Design tab
What do you click to remove a data series form a chart so that you can focus on other data series? -
✔✔Chart filters
Which of the following does not display automatically when you create a clustered column chart?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EXAMQA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73243 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
