1|Page
MKC SWE FINAL EXAM AND PRACTICE EXAM QUESTIONS
2 VERSION QUESTIONS WITH DETAILED ANSWERS WITH
STUDY GUIDE EXPERT VERIFIED FOR GUARANTEED
PASS/ALREADY GRADED A+
Which of the following can you apply to change the fill of a data series?
Select all the options that apply. - ANSWERS--Texture, Color, Shape
Style`
Which of the following are effects you can apply to the chart title?
Select all the options that apply. - ANSWERS--Shadow, Glow, Outline
Megan wants to refine the appearance of a column chart, including
applying a lighter shade of blue. Which of the following tools can she
use to do so? Select all the options that apply. - ANSWERS--Change
Colors button, Chart Styles gallery, Quick Layout button
Which of the following elements uses colors to identify how the data is
represented in a chart? - ANSWERS--Legend
Which of the following chart types shows the distribution of data
grouped in bins? - ANSWERS--Histogram Chart
, 2|Page
What type of chart is a Clustered Column - Line chart? - ANSWERS--
Combo Chart
To change the starting and ending values on a chart axis, use the _____
pane. - ANSWERS--Format Axis
Which of the following elements can you add to a chart to display a line
representing the general direction in a data series? - ANSWERS--
Trendline
Which of the following keys will you press after clicking on a chart to
remove it from an Excel sheet but keep the data intact? - ANSWERS--
Delete
Which of the following can you apply to a data series to change its
appearance? - ANSWERS--Shape Style
Walter selected data on a worksheet to show in a chart. Which button
on the Insert tab can he click to display charts appropriate for the
selected data? - ANSWERS--Recommended Charts button
After selecting a range of data, what can you click to display common
chart types based on the range you selected? - ANSWERS--Quick
Analysis button
MKC SWE FINAL EXAM AND PRACTICE EXAM QUESTIONS
2 VERSION QUESTIONS WITH DETAILED ANSWERS WITH
STUDY GUIDE EXPERT VERIFIED FOR GUARANTEED
PASS/ALREADY GRADED A+
Which of the following can you apply to change the fill of a data series?
Select all the options that apply. - ANSWERS--Texture, Color, Shape
Style`
Which of the following are effects you can apply to the chart title?
Select all the options that apply. - ANSWERS--Shadow, Glow, Outline
Megan wants to refine the appearance of a column chart, including
applying a lighter shade of blue. Which of the following tools can she
use to do so? Select all the options that apply. - ANSWERS--Change
Colors button, Chart Styles gallery, Quick Layout button
Which of the following elements uses colors to identify how the data is
represented in a chart? - ANSWERS--Legend
Which of the following chart types shows the distribution of data
grouped in bins? - ANSWERS--Histogram Chart
, 2|Page
What type of chart is a Clustered Column - Line chart? - ANSWERS--
Combo Chart
To change the starting and ending values on a chart axis, use the _____
pane. - ANSWERS--Format Axis
Which of the following elements can you add to a chart to display a line
representing the general direction in a data series? - ANSWERS--
Trendline
Which of the following keys will you press after clicking on a chart to
remove it from an Excel sheet but keep the data intact? - ANSWERS--
Delete
Which of the following can you apply to a data series to change its
appearance? - ANSWERS--Shape Style
Walter selected data on a worksheet to show in a chart. Which button
on the Insert tab can he click to display charts appropriate for the
selected data? - ANSWERS--Recommended Charts button
After selecting a range of data, what can you click to display common
chart types based on the range you selected? - ANSWERS--Quick
Analysis button
