Last Computers in business review for exam 1
What are watermarks and what are they used for? Where are they located on a worksheet?
A watermark is text or an image that appears in the background behind other content. Watermarks are inserted into the header or footer of a worksheet. Many businesses distinguish works in progress from final versions by including the word "Draft" as a watermark on each page.
What is the benefit of combination charts?
Combination charts enable you to show two sets of data using the chart type that is best for each data set. Combination charts can have data series with vastly different values.
True/False: A chart cannot be rotated in the chart sheet.
False
True/False: A data bar is a type of sparkline.
False
True/False: A watermark is text or an image that appears in front of other content
False
True/False: By default, titles appear next to the value and category axes
False
True/False: Minor tick marks identify the main units on the chart axis.
False
True/False: The width of data bars is determined based on the values in the selected range.
False
True/False: Watermarks are only visible in Normal view.
False
True/False: You cannot add text to a shape.
False
True/False: You cannot remove an axis title.
False
rue/False: A chart sheet takes up less space than an embedded chart.
False
rue/False: If you change any values or labels in the data source, the chart must be manually updated to show the new content
False
rue/False: If you change any values or labels in the data source, the chart must be manually updated to show the new content.
False
True/False: Charts remain linked or connected to their data sources, even if they appear in different worksheets
True
True/False: Leader lines can be added to labels placed outside the slices to connect them to their corresponding slices
True
True/False: The Select Data Source dialog box lists all of the data series displayed in the chart
True
True/False: The Select Data Source dialog box lists all of the data series displayed in the chart.
True
True/False: The range of values, or scale, of an axis is based on the values in the data source
True
True/False: You can format the plot area by changing its fills and borders, and by adding visual effects.
True
True/False: You can include data labels for every data marker, or you can include data labels for individual data points.
True
rue/False: In a line chart, the data markers are the points connected by the line.
True
rue/False: The process for creating a column chart is the same as for creating a pie chart.
True
rue/False: You can modify the data source to specify which ranges should be treated as category values and which ranges should be treated as data values.
True
true/False: Charts remain linked or connected to their data sources, even if they appear in different worksheets.
True
What is a line chart?
line chart compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.
An chart element floats in the chart area and is not fixed to a particular position
overlaid
The chart's controls how fast the chart appears to recede from the viewer's eye.
perspective
How do you add a data series to an existing chart?
select the chart, click the Select Data button in the Data group on the CHART TOOLS DESIGN tab to open the Select Data Source dialog box, click the Add button, and then select the range for the data series.)
A is a mini chart that is displayed within a worksheet cell.
sparkline
How are data bars and sparklines similar or different?
Data bars differ from sparklines in that the bars are always placed in the cells containing the value they represent, and each cell represents only a single bar from the bar chart. By contrast, a column sparkline can be inserted anywhere within the workbook and can represent data from several rows or columns. However, like sparklines, data bars can be used to create compact graphs that can be easily integrated alongside the text and values stored in worksheet cells.
True/False: You can edit the data source in the Edit Data Source dialog box.
False, the Select Data Source dialog box
How do you know which type of chart to use with your data?
In general, pie charts should be used only when the number of categories is small and the relative sizes of the different slices can be easily determined.
What are the three types of sparklines ? Give an ample of when each sparkline might be used.
There are three types of sparklines - line, column, and win/loss. A line sparkline might be used to show the sales history of a department. A column sparkline could be used to present a record of monthly temperatures and a win/loss sparkline could be used to show the season results for sports teams.
he function can be used to calculate the payment schedule required to completely repay a mortgage or other type of loan
PMT
True/False: An exploded pie chart moves one slice away from the pie as if someone were taking the piece out of the pie.
True
True/False: Changes to the plot area are often made in conjunction with the chart area
True
Which chart compares relative values of different categories to the whole?
Pie chart
is the amount of money being loaned
Principal
True/False: A bar chart compares values from different categories.
True
True/False: A chart sheet can contain embedded charts
True
what is the first step when adding a data series to a chart?
Select the chart to which you want to add a data series
To select more than one shape, hold down the key, then click each of the remaining shapes. (
Shift
True/False: A line chart can be used with more than one data series
True
True/False: A line chart is often used to show trends and changes over time.
True
True/False: A pie chart compares relative values of different categories to the whole
True
True/False: A quick way to copy formatting is to use the Format Painter button
True
What are gridlines and what do they do?
are the horizontal and vertical lines that help you compare data and category values
A(n) is descriptive text that appears next to the axis.
axis title
A column chart turned on its side is called a(n)
bar chart
xcel uses to slow down the effect of changing data source values, making it easier to see how changing one value affects the chart.
chart animation
he specifies the worksheet cells that contain the data on which the chart will be based
chart options
The provides a description of the chart
chart title
A is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value.
data bar
A pie slice is an ample of a
data marker
To create a set of sparklines, you first select a , and then you select a location range where you want the sparklines to appear.
data range
Each chart must have a(n)
data source
One type of what-if analysis that limits the data to a subset of the original values is a process called
filtering
The , or category, axis displays the categories associated with each data value
horizontal
True/False: The color of pie slices can be changed
true
The , or value, axis displays the values associated with the heights of each column
vertical
The represents the length of the object.
x-axis
