Excel Chapter 3
To show the structure of a company or institution, create an
organization chart
To calculate a value in A1 with a percentage increase in A2 added to it, use this formula
=(1+A2)*A1
You can automatically republish your data whenever you change the workbook, using the ____________ option in the Publish as Web Page dialog box
AutoRepublish
The _____ ____ is the overall background for the chart and all its elements
Chart Area
A _____ _____ is a chart that exists on a separate sheet in the workbook
Chart Sheet
________ means to insert an object in a destination document so that it can still be edited by the source application
Embedded
An ________ _____ is a chart that exists as an object in the worksheet alongside the data
Embedded Chart
(T/F) Changes to a linked object in the destination document are automatically made to the object in the source document
False
(T/F) Excel will always display an error message when improperly placed parentheses can cause logic flaws in a formula
False
(T/F) For a linked chart, you can close the Excel window without saving after you have made changes
False
(T/F) For an embedded chart, you can close the Excel window without saving after you have made changes
False
(T/F) Making data or formatting changes to an Excel chart embedded in Word also changes the original data or chart in Excel
False
(T/F) Once you create a chart, you CANNOT change its chart type
False
(T/F) The horizontal axis is the axis that goes from top to bottom
False
(T/F) The selection of chart data to plot CAN contain blank columns or rows
False
(T/F) To explode a pie chart means to delete it
False
(T/F) When you make changes to a chart either in the source or destination workbook for a linked chart, those changes flow between the two chart locations
False
(T/F) You CANNOT add or remove chart elements from your chart layout
False
If you make your online chart ___________, users can view the data in the chart and make changes to it
Interactive
The ______ is a key that identifies each data series in a chart
Legend
The process of saving worksheet data to the Internet is called _______
Publish
A ________ graphic is a pre-drawn graphic used to illustrate a specific data relationship
SmartArt
(T/F) A chart is also known as a graph
True
(T/F) A link to an Excel chart in a Word document allows you to start Excel from inside Word
True
(T/F) After you create a pie chart, you can move it to its own chart sheet
True
(T/F) An embedded chart in the destination file may also be displayed as an icon
True
(T/F) Calculate a percentage of a total by dividing the individual value by the total value
True
(T/F) For charts with multiple series, you have to format the data labels for each series independently
True
(T/F) If you select an embedded chart before choosing the Print command, only the chart will print
True
(T/F) If you use a chart picture, the data can be changed
True
(T/F) Selecting multiple rows of chart data creates multiple categories
True
(T/F) Sorting data DOES change the order of the pie slices
True
(T/F) The Recommended Charts feature examines your data and provides recommended chart types based on the type of your data
True
(T/F) The axis of a chart on which categories are plotted is called the X axis
True
(T/F) The simplest way to include an Excel chart within another document is to paste its picture
True
(T/F) To change the color of a chart element, right-click on the element and use the Fill button
True
(T/F) To find the percentage of a value, convert the percentage to a decimal, then multiply
True
(T/F) To maintain the link, the source and destination files do not need to remain in their original locations
True
(T/F) To update a chart picture, you need to change the data in Excel and paste a new picture
True
(T/F) Use the Filter shortcut button to display selected data elements of a chart
True
(T/F) When you change the data or chart formatting in a linked chart and open the destination file again, the link causes the destination chart to update as well
True
(T/F) You can link or embed an Excel chart into another document, such as a Word document
True
_____ are the areas of a 3-D chart that frame the data series
Walls
A ______ analysis looks at how future results might change based on varying inputs or data
What-If
The shape representing each data point of a chart is
a data marker
A set of related data points to be charted is
a data series
If you paste an Excel chart into Word, the Word file is the
embedded file
When there are multiple nested pairs of parentheses, Excel calculates
from the innermost pair, working outward
HTML format
is a format in which the text and page format is stored in one file and the graphics and other elements are stored in separate files
Lines of measurement along the category and value axis are called
tick marks