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