MGSC Exam 2 UPDATED ACTUAL Exam Questions and CORRECT Answers
2 views 0 purchase
Course
MGSC
Institution
MGSC
MGSC Exam 2 UPDATED ACTUAL Exam
Questions and CORRECT Answers
Win/Loss - CORRECT ANSWER- A type of sparkline
WordArt - CORRECT ANSWER- Used to create a custom chart title
Chart elements - CORRECT ANSWER- Titles, data labels, legends, gridlines, and
trendlines
Filter - CORRECT ANSWER- Criter...
MGSC Exam 2 UPDATED ACTUAL Exam
Questions and CORRECT Answers
Win/Loss - CORRECT ANSWER- ✔✔A type of sparkline
WordArt - CORRECT ANSWER- ✔✔Used to create a custom chart title
Chart elements - CORRECT ANSWER- ✔✔Titles, data labels, legends, gridlines, and
trendlines
Filter - CORRECT ANSWER- ✔✔Criteria that specifies which data is shown and which is
hidden
Shape style - CORRECT ANSWER- ✔✔A predesigned combination of fill, borders, and
effects
Bevels and shadows - CORRECT ANSWER- ✔✔Special effects applied to chart objects
Area chart - CORRECT ANSWER- ✔✔Displays the magnitude of change over time and
shows the rate of change
Bubble chart - CORRECT ANSWER- ✔✔Displays relationships among numeric values in
two or more data series
Data label - CORRECT ANSWER- ✔✔Displays the value of a column, bar, pie slice, or
other marker
Combo chart - CORRECT ANSWER- ✔✔Uses two types of charts to graph values that are
widely different
When you want to visually represent the numeric data in a worksheet, Excel helps you create
an appropriate: - CORRECT ANSWER- ✔✔Chart.
, The text label that describes each data series in a chart is called the: - CORRECT ANSWER-
✔✔Category label.
This chart type displays the frequency of multiple data series relative to a center point with an
axis for each category: - CORRECT ANSWER- ✔✔Radar
In a column chart, the category labels are shown: - CORRECT ANSWER- ✔✔On the
horizontal axis.
An Excel chart that is displayed on its own sheet in the workbook is called: - CORRECT
ANSWER- ✔✔A chart sheet.
When you change the preset group of elements in an Excel chart, you are changing: -
CORRECT ANSWER- ✔✔The layout.
To apply changes to your chart's Shape Fill, Shape Outline, or Shape Effects separately, use: -
CORRECT ANSWER- ✔✔Format tab.
Chart styles are based on: - CORRECT ANSWER- ✔✔Workbook themes.
The type of chart that shows percentages of a whole and has no axes is: - CORRECT
ANSWER- ✔✔A pie chart.
The Excel feature that displays averages in your data and can be used to forecast data by
plotting future approximate averages is the: - CORRECT ANSWER- ✔✔Trendline.
The chart feature that allows you to specify which data is shown and which is hidden is the: -
CORRECT ANSWER- ✔✔Filter.
The background color for a chart element is called the: - CORRECT ANSWER- ✔✔Shape
Fill.
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
