EL1 C7 Flashcards
A chart is a picture of numeric data and is sometimes referred to as a…
Graph
Shapes can be formatted with options on the _____ tab.
Drawing Tools Format
The left side of a column chart created by Excel is referred to as the…
vertical axis
Use an IF function to create a logical test that performs different actions if the answer is _____ or _____.
true; false
What is the first step in creating a chart?
Select the cells that contain the data to be charted
Options for inserting shapes into a chart are provided in which of the following?
the Insert Shapes group on the Chart Tools Format tab
A question that can be answered true or false is considered a…
logical test
A(n) _____ chart emphasizes the magnitude of change rather than the rate of change.
area
A(n) _____ chart displays values in vertical bars and is useful for comparing items or showing how values vary over time.
column
To move a chart created in an existing worksheet, first select the chart and then perform which of the following steps?
Position the mouse pointer on a border until it becomes a four-headed arrow and then click and drag the chart to the location
Selecting a chart and then pressing the Delete key will delete which of the following?
only the chart
To increase the height and width of a chart at the same time, drag _____ sizing handles.
the corner
Click the _____ button to return the formatting of a chart element back to the original style.
Reset to Match Style
To include text in an IF statement, you must do which of the following?
Put quotation marks around the text
Display the Function Arguments dialog box by clicking the Logical button in the Function Library group on the _____ tab and then clicking IF at the drop-down list.
Formulas
To move a chart element, select it, _____, click and hold down the left mouse button, and then drag the element to the desired location.
move the mouse pointer over the border until it turns into a four-headed arrow
To change the data for a chart, edit the data in the specific cells and the corresponding sections of the chart will _____ automatically.
update
A _____ is a type of chart that provides a hierarchical view of data and compares proportions within the hierarchy.
treemap
You can delete a chart element by _____ it and then clicking Delete at the shortcut menu.
right-clicking
The condition and the action in an IF function are separated by which of the following?
comma
When a chart has been created in the same worksheet as its data cells, you can change the size of the chart using the _____ on the chart’s border.
white circles
Excel’s _____ feature provides in one location buttons and options for inserting charts, sparklines, and conditional formatting plus common formulas.
Quick Analysis
Which of the following types of charts is useful in comparing values and showing categories across geographical regions?
map
Which of the following is not one of the options on the Quick Analysis Toolbar?
Photos
In a column chart created by Excel, the horizontal axis runs along the _____ of the chart.
bottom
What appears around a chart when it is selected?
boarder with sizing handles
To change how data are grouped along the bottom and left side of a chart, make the chart active and then click the _____ button in the Data group on the Chart Tools Design tab.
(?)
NOT Change Chart Type
NOT Axes
Which of the following options is not provided at the Function Arguments dialog box when creating an IF function?
Value_test
Suppose that you are writing a formula with an IF statement using the Function Arguments dialog box. If you type YES in the Value_if_true text box and then press the Enter key, what will happen to the word YES?
(?)
NOT Nothing
NOT It will be deleted
When a chart on Sheet1 is moved to a new sheet, the default name for that new sheet is…
Chart1
Which of these keyboard shortcuts will create a chart from the selected cells?
Alt + F1
If a worksheet contains rows or columns of data that you do not want to chart, Chapter 7 suggests that you _____ them.
hide
How can you delete a chart element?
Click the element and then press the Delete key
To write a formula with an IF function, type the _____ followed by what is evaluated in the Logical_test text box.
(?)
NOT Function
When you select a chart and then display the Print backstage area, the first gallery in the Settings category is automatically changed to…
Print Selected Chart
You can change the chart type of an existing chart by selecting the chart and using buttons and options…
on the Chart Tools Design tab
Which of the following is not one of the chart formatting buttons that displays at the right of a chart border?
Change Chart
Two options for changing the chart location are provided in the Move Chart dialog box: _____ and _____.
New sheet; Object in
By default, Excel creates the legend for a chart using the…
column headings
To insert a new chart in a separate worksheet, not the same worksheet that contains the chart’s data, you should press which of the following?
the F11 function key
A variety of formatting changes can be made to a chart or chart element with options on the Chart Tools Format tab. Which of the following is not one of them?
changing the data range
To print only the chart in a worksheet (not also the data in cells), first _____ and then display the Print backstage area.
click the chart to select it
The _____ tab provides options for applying WordArt formatting to data in a chart.
Chart Tools Format
When a shape has been selected for insertion into a chart, the mouse pointer turns into a…
thin black plus symbol (crosshairs)
A _____ chart shows overall change over time at even intervals and emphasizes the rate of change rather than the magnitude of change.
line
Which of the following types of charts plots the interception points between x and y values and is commonly used for scientific data?
XY (scatter)
