excel module 4
Because of their compact size, you cannot apply a style to a sparkline. True or False
False
To align the upper-left corner of a chart with the upper-left corner of a cell, press and hold CTRL as you drag the chart. True or False
False
To compare data from different categories where the values are indicated by the height of the data series,select a Stock chart on the Recommended Charts tab in the Insert Chart dialog box. True or False
False
You should move a chart to a chart sheet when you want the source data to appear with the chart
False
trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart. True or False
False
A _____ chart tracks the addition and subtraction of values within a sum. a. waterfall b. histogram c. scatter d. combo
a. waterfall
Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appearoutside of the pie chart but close to each slice. Which Label Position option should she select for the datalabels? a. center b. Inside End c. Outside End d. Overlay
c. Outside End
Which of the following dialog boxes do you use to remove a data series from a chart? a. Chart Elements dialog box b. Format Data Source dialog box c. Select Data Source dialog box d. Insert Chart dialog box
c. Select Data Source dialogue box
A combination chart combines two chart types and can plot data on primary and secondary axes True or False
True
Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns. True or False
True
Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents. True or False
True
Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. True or False
True
Column and line sparklines show a general trend without a legend, title, or gridlines
True
In a chart, a data table displays the data series in rows and the category values in columns. True or False
True
Which of the following elements can you add to a chart to display a line representing the general direction in a data series? a. Axes b. Legend c. Gridlines d. Trendline
d. Trendline
Which of the following can you do to make a chart title stand out on a chart? a. Change the text direction b. Resize the chart. c. Display the title on the outside end of the data series. d. Increase the font size
d. increase the font size
What can you change to coordinate the values represented by sparklines with the values of other charts and graphic objects on a worksheet? a. sparkline type b. sparkline color c. show or hide data markers d. scale of the sparkline axis
d. scale of the sparkline axis
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK. True or False
True
To change a chart title, you click the chart title, type the new title, and then press ENTER. True or False
True
You can add data markers to sparklines to indicate the high and low points in the chart. True or False
True
Use a sunburst chart to track the addition and subtraction of values in a sum. True or False
false
A Line sparkline displays a green block for increasing values and a red block for declining values. True or False
False
A treemap chart is a type of waterfall chart. True or False
False
Which of the following statements describe a histogram chart? Select all the options that apply. a. It is a column chart showing the distribution of values from a single data series. b. Use it to display distribution of scores on an exam. c. Data values are allocated to bins. d. It includes a secondary line chart
a. It is a column chart showing the distribution of values from a single data series. b. Use it to display distribution of scores on an exam. c. Data values are allocated to bins.
When you create a custom combination chart, which of the following chart types can you use for the primary and secondary axis? Select all the options that apply a. Line b. Clustered Column c. Tree map d. Waterfall
a. Line b. Clustered Column
To which of the following chart types can you not add axis titles? a. Pie chart b. Line chart c. Area chart d. Column chart
a. Pie Chart
A label that appears as a text bubble attached to a data marker is called which of the following? a. data callout b. histogram c. data bar d. sparkline
a. data callout
Which type of sparklines can most clearly display the daily fluctuations of the selling price of goods or commodities ? a. Line b. Win/Loss c. Column d. Combo
a. line
You can add data markers to sparklines to highlight which of the following values? Select all the options that apply. a. low values b. high values c. ending values d. negative values
a. low values b. high values c. ending values d. negative values
Which of the following changes can you apply to a chart legend? Select all the options that apply. a. Position b. Data Series colors c. Fill color d. Number formatting
a. position c. fill color
Which of the following can you change in a combination chart? Select all the options that apply. a. The bounds of the secondary axis b. The major tick marks on the primary axis c. The minor tick marks on all axes d. The orientation of the axis titles
a. the bounds of the secondary axis b. the major tick marks on the primary axis d. the orientation of the axis titles
Which of the following options can you set when you create or edit a data bar conditional formatting rule?Select all the options that apply. a. value used for the longest data bar b. fill color of the data bars c. how to display negative values d. font color of the text
a. value used for the longest data bar b. fill color of the data bars c. how to display negative values
Which type of conditional formatting rule would you create to add a horizontal bar to a cell background,where the length of the bar reflects the value in the cell? a. Top Values b. Data Bar c. Icon Sets d. Color Scales
b. Data Bar
Amir wants an exploded pie chart. Which of the following should he do? a. Click the Explode Pie button b. Drag the pie slice(s) away from the pie. c. Right-click on the slice(s) of pie and select Explode Piece. d. There is no way he can explode the pie chart
b. Drag the pie slice(s) away from the pie.
Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the rangeA3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of eachrow in column N to track the monthly sales for each product. What can she insert in the range N3:N7? a. Line chart b. Line sparklines c. Scatter chart d. Data bars
b. Line sparklines
What can you do to make data series easier to distinguish from one another? a. Change the chart type. b. Change the color of the data series. c. Apply additional text styles. d. Increase the size of the data series
b. change the color of the data series
Which type of chart combines a column chart and a line chart to indicate which factors are the largest contributors to the whole? a. sunburst b. Pareto c. area d. doughnut
b. pareto
Descriptive text that appears next to a chart's horizontal or vertical axis is called which of the following? a. major tick mark b. display units c. axis title d. data label
c. axis title
If you see cells with blue fills of varying lengths representing the values, the cells most likely have________ applied to them. a. themes b. icon sets c. data bars d. cell styles
c. data bars
Which of the following chart types show how two numeric data series are related to each other? a. Pie b. Bar c. Line d. Scatter
d. Scatter