The process of saving data to an intranet or Internet.
What is publish
100
list 3 types of charts
What is line, bar, area,column, pie, scatter, etc...
100
create a pie chart comparing 3 different countries on a single category. Needs to be done quickly - info doesn't need to be correct.
check the chart in excel
200
changes individual parts of a chart
What is the format tab
200
A key that identifies each of the data series in a chart
What is a legend
200
The horizontal scale of a chart on which categories are plotted, sometimes called the X-axis
What is horizontal axis
200
this type of chart is best used when comparing items over time
What is line chart
200
explode the piece of pie that represents the second country
time limit 1 minute
check in excel
300
if the instructions on Mr. Smith's test tell you to format the "plot area", and you have NO IDEA where/what the plot area is, how would you find it and format it?
What is the format tab, current selection group on the left side of the ribbon
300
The specific values plotted on a chart
What are data points
300
A set of related data points to be charted
What is a data series
300
this type of chart shows how the parts relate to the whole. Generally shows each category/series as a percentage
What is a pie chart
300
create a column or line chart and turn the plot area red
limit 3 min
check excel
400
when you look at the 3 shortcut buttons on the right side of the chart, they all allow you to do things that can be done in the _________ tab (you may look at the shortcuts, but not at the tabs)
What is design tab
400
The overall background for the chart and all its elements, such as titles.
What is chart area
400
To move a pie slice away from the pie chart, for emphasis
What is explode
400
you would use either of these two types of charts to compare multiple categories against multiple series (example? comparing different social media sites against popularity, age of user, years since creation, etc...)
What is bar or column chart?
400
add data labels to a column chart (pull up one we have maybe worked on in class) and use the shortcut buttons to remove one of the categories or series from the chart
check in excel
500
without looking, list 3 things you can do on the design tab
What is change chart color, style, move the chart, chart layout, switch row column, change chart type, etc...
500
In most cases, each column of charted worksheet data contains a _______. Selecting multiple rows of chart data creates multiple _________. The chart displays _________along the horizontal axis.
What is a category
500
A reference in a destination document to an object (such as a chart) in a source document.
What is a link
500
this type of chart can only compare one series
What is a pie chart
500
on the pie chart created earlier (or a different pie chart) change the color of the text to red and change the chart layout to show the % on each category