Itm ch 3-4

A gridline is a line used to depict trends and forecast future data. True False

False

A page break indicates where the end of all the columns (fields) occurs. True False

False

A structured reference requires parentheses around column headings or field names. True False

False

Excel enables you to sort data on ________ different levels. 116 18 256 64

64

Where does a sparkline display? A. In a single cell B. On a separate worksheet from the data C. In a range below the data D. Always to the right of the data

A. In a single cell

A data point: A. is a numeric value that describes a single value on a chart. B. is a group of related data points. C. displays data comparisons vertically in columns. D. is a numeric value within a range of data.

A. is a numeric value that describes a single value on a chart.

A structured reference: A. is a tag or use of a table element, such as a field heading. B. highlights or emphasizes cells that meet certain conditions. C. is a table element that uses relative references in a formula within a table. D.formats cells based upon their value in reference to the value of other cells.

A. is a tag or use of a table element, such as a field heading.

A stacked column chart: A. places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. B. adds a third dimension to each data series, creating a distorted perspective of the data. C. compares values across categories using horizontal bars. D. places (stacks) data in one column per category, with each column having the same height of 100%.

A. places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.

What is a data series in Excel 2013? A. Data grouped into vertical columns B. A group of related data points C. Text that describes a group of data points in a chart D. An entire chart and all of its elements on a Chart worksheet

B. A group of related data points

Which of the following is NOT controlled by choosing a chart style? A. Color of the chart area B. Sparklines C. Plot area D. Data series

B. Sparklines

A chart is: A. a group of related data points in an Excel window. B. a visual depiction of numerical data. C. a set of numeric values shown on a worksheet. D. text that describes a group of data points.

B. a visual depiction of numerical data.

Sorting values smallest to largest: A. arranges names in sequential order. B. arranges numbers in sequential order. C. arranges dates in alphabetical order. D. is the process of displaying only records that meet specific conditions.

B. arranges numbers in sequential order.

The Freeze Panes option keeps: A. only the first column visible as you scroll through a worksheet. B. both rows and columns above and to the left of the active cell visible as you scroll. C. only the designated rows visible as you scroll through a worksheet. D. all row names and column headings on the screen for preparation in printing.

B. both rows and columns above and to the left of the active cell visible as you scroll.

A bar chart: A. uses a line to connect data points in order to show trends over a period of time. B. compares values across categories using horizontal bars. C. shows each data point in proportion to the whole data series as a slice in a circular pie. D. separates one or more pie slices from the rest of the pie chart.

B. compares values across categories using horizontal bars.

The chart area in Excel 2013: A. is always a fill of a picture or a texture. B. contains the entire chart and all of its elements. C. is a vertical line that borders the plot area to provide a frame of reference for measurement. D. is a horizontal line that borders the plot area to provide a frame of reference for measurement.

B. contains the entire chart and all of its elements.

In Excel 2013 a dataset: A. indicates where data starts on a new printed page. B. is a collection of structured, related data in columns and rows. C. is a grouping of similarly formatted worksheets. D.is a grouping of worksheets with similar content.

B. is a collection of structured, related data in columns and rows.

The Y-axis: A. is text that describes a collection of data points in a chart. B. is a vertical line that borders the plot area to provide a frame of reference for measurement. C. compares values for one set of data. D. is a horizontal line that borders the plot area to provide a frame of reference for measurement.

B. is a vertical line that borders the plot area to provide a frame of reference for measurement.

A category label: A. contains the entire chart and all of its elements. B. is text that describes a collection of data points in a chart. C. displays data comparisons vertically in columns. D. contains graphical representation of values in data series.

B. is text that describes a collection of data points in a chart.

Freezing rows and/or columns: A. collects structured, related data in columns and rows. B. keeps them visible as you scroll through a worksheet. C. keeps all worksheets on the screen. D. enables you to adjust settings to control how the worksheet will print.

B. keeps them visible as you scroll through a worksheet.

A data label is: A. a visual representation of numerical data. B. the value or name of a data point. C. a line used to depict trends and forecast future data. D. a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

B. the value or name of a data point.

________ displays alternate fill colors for even and odd rows to help distinguish fields. Filtered rows Banded columns First/Last columns Banded rows

Banded columns

Which of the following is NOT a type of sparkline? Bar Line Column Win/loss

Bar

How are manual page breaks indicated in a worksheet? By solid blue lines By dotted red lines By blue dashed lines By solid black lines

By solid blue lines

What is a record? A. An individual piece of data, such as a last name B. Defines the range of data to print C. A complete set of data for an entity D. All data within one full column

C. A complete set of data for an entity

What is a field? A. A complete set of data for an entity B. Indicates where data starts on a new worksheet C. An individual piece of data, such as an address D. All data about one specific item

C. An individual piece of data, such as an address

Which of the following is FALSE about sparklines? A. Sparklines do not include an axis label. B. Sparklines display in a single cell. C. Sparklines include an automatically-created chart title. D. Sparklines present a condensed, simple visual illustration of data.

C. Sparklines include an automatically-created chart title.

A structured reference requires parentheses around column headings or field names. True False

False

A chart sheet: A. is a label that describes the chart. B. enables you to adjust the size of a chart. C. contains a single chart and no spreadsheet data. D. is a miniature chart contained in a single cell.

C. contains a single chart and no spreadsheet data.

Filtering: A. helps to remove duplicate data in a dataset. B. displays data in chronological order. C. is the process of displaying only records that meet special conditions. D. arranges dates in alphabetical order.

C. is the process of displaying only records that meet special conditions.

Axes titles are: A. display on the X-axis by default. B. the value or name of a data point on the X-axis. C. not displayed by default. D.descriptive labels that show exact values or name of a data point.

C. not displayed by default.

A Table style controls: A. check boxes to select format actions such as Total Row. B. check boxes to select format actions such as Header Row. C. the fill color of the header row and rows of records. D. the background and watermarks of a worksheet.

C. the fill color of the header row and rows of records.

Sorting arranges records in a table by: A. using filter arrows. B. the row number. C. the value in field(s) within a table. D. permanently removing extraneous data.

C. the value in field(s) within a table.

A total row appears as the last row of a table to: A. highlight or emphasize cells that meet certain conditions. B. format cells based upon their value in reference to the value of other cells. C. tag a table element as a reference in a formula. D. display summary statistics, such as a sum.

D. display summary statistics, such as a sum.

After you have created a table, you cannot add new fields to it. True False

False

Sorting dates oldest to newest: A. is the process of displaying only records that meet specific conditions. B. arranges dates in alphabetical order. C. is a Text filter. D. displays data in chronological order.

D. displays data in chronological order.

Which of the following describes a line chart? A. A line chart separates one or more pie slices from the rest of the pie chart. B. A line chart shows each data point in proportion to the whole data series as a slice in a circular pie. C. A line chart emphasizes magnitude of changes over time by filling in the space between lines with a color. D. A line chart uses a line to connect data points in order to show trends over a period of time.

D. A line chart uses a line to connect data points in order to show trends over a period of time.

To create a table from an existing range of data: A. click within the range, click the Table Tools Design tab, and then select Convert to Table. B. select any cell in the worksheet then click Existing Range in the Tools group. C. click in a cell and on the Home tab, click the Insert arrow in the Cells group. D. Click the Insert tab and then click Table in the Tables group.

D. Click the Insert tab and then click Table in the Tables group.

Which of the following is TRUE about the print area feature? A. In Page Break Preview, the area of the worksheet that won't be printed has a dark blue background. B. In Page Break Preview, the print area has a white background and dashed red border. C. The print area can be cleared from the Home tab. D. The print area defines the range of data to print.

D. The print area defines the range of data to print.

Which of the following is TRUE about the print area feature? A. In Page Break Preview, the area of the worksheet that won't be printed has a dark blue background. B.In Page Break Preview, the print area has a white background and dashed red border. C. The print area can be cleared from the Home tab. D. The print area defines the range of data to print.

D. The print area defines the range of data to print.

An X Y (scatter) chart shows: A. values as percentages of the whole but may contain more than one data series. B. the high and low close prices for individual stocks over equal amounts of time. C. the trend of two variables using a minimum of two dimensions on a continuous line. D. a relationship between two variables.

D. a relationship between two variables.

To create a table from an existing range of data: A. click within the range, click the Table Tools Design tab, and then select Convert to Table. B. select any cell in the worksheet then click Existing Range in the Tools group. C. click in a cell and on the Home tab, click the Insert arrow in the Cells group. D. click the Insert tab and then click Table in the Tables group.

D. click the Insert tab and then click Table in the Tables group.

Sorting dates oldest to newest: A. is the process of displaying only records that meet specific conditions. B. arranges dates in alphabetical order. C. is a Text filter. D. displays data in chronological order.

D. displays data in chronological order.

Top/Bottom Rules: A. is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells. B. moves data from the top of the workbook to the bottom for analysis. C. highlight cells meeting specified criteria with a specified color, font, or border. D. format cells based upon their value in relation to the value of other cells.

D. format cells based upon their value in relation to the value of other cells.

A color scale: A. highlights cells meeting specified criteria with a specified color, font, or border. B. is a conditional format that displays an colored icon representing a value in the top third, quarter, or fifth based on colors in the selected range. C. calculates an aggregate for values in a range or database. D. is a conditional format that displays a color based on the relative value of the cell contents.

D. is a conditional format that displays a color based on the relative value of the cell contents.

The Freeze Top Row option: A. is the sequence in which pages print. B. enables you to adjust settings to control how the worksheet will print. C. defines the range of data to print. D. keeps only the top row visible as you scroll through a worksheet.

D. keeps only the top row visible as you scroll through a worksheet.

Each column in a table: A. needs to be converted to a range in order to work with it. B. represents a record. C. is a complete set of data for an entity. D. represents a field which can contain an individual piece of data for a record.

D. represents a field which can contain an individual piece of data for a record.

Each row in an Excel table: A. is an individual piece of data, such as a last name. B. is the sequence in which pages print. C. represents a Field which can contain an individual piece of data for a record. D. represents a record.

D. represents a record.

A pie chart: A. shows a relationship between two variables. B. separates one or more pie slices from the rest of the pie chart. C. emphasizes magnitude of changes over time by filling in the space between lines with a color. D. shows each data point in proportion to the whole data series as a slice in a circular pie.

D. shows each data point in proportion to the whole data series as a slice in a circular pie.

The ________ group on the Design tab is useful for adjusting the data source of a chart. Chart Styles Current Selection Data Chart Layouts

Data

Conditional formatting is the process of conditioning data to make it more manageable. True False

False

Default chart sheet names include sheet1, sheet2, etc. True False

False

Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. True False

False

Excel includes the placeholder text Chart Title below a chart when you create the chart. True False

False

Freeze Panes only locks columns above the active cell as you scroll through a worksheet. True False

False

If you embedded a chart on the same sheet as the data source, you cannot print the chart only. True False

False

In Page Break Preview, the print area has a white background with a dotted blue border. True False

False

Semiselection cannot be used to create formulas in a table. True False

False

Sizing handles display as small, black-filled circles to resize a chart. True False

False

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data. True False

False

When you update data in a worksheet, you must press F9 to update the data in the associated chart. True False

False

You can only apply one filter to a large dataset in Excel 2013. True False

False

Which of the following is NOT included in the Table Style Options group? Footer Row Last Column Banded Columns Filter Button

Footer Row

Which of the following is NOT a task pane in Excel 2013 used to format a chart? Format Chart Area Format Plot Area Format Data Series Format Titles and Axes

Format Titles and Axes

Which of the following is NOT a task pane in Excel 2013 used to format a chart? Format Chart Area Format Plot Area Format Data Series Format Titles and Axes

Format Titles and Axes

If the automatic page breaks occur in undesirable locations, you can adjust the page breaks. True False

True

Which of the following charts displays lines connecting data points to show trends over equal time periods? Column chart Bar chart Line chart Area chart

Line chart

Which of the following is NOT an option on the Page Layout tab? Manage page breaks Set the print area Print titles Print preview

Print preview

To create a chart in Excel 2013, select the data and click the: Chart tab. Chart Elements button. Quick Analysis button. Chart Styles button.

Quick Analysis button.

Which of the following is NOT controlled by choosing a chart style? Color of the chart area Sparklines Plot area Data series

Sparklines

Which of the following is NOT a style that affects the look of a data series? Flat Stacked 3-D Beveled

Stacked

Which of the following is NOT a style that affects the look of a data series? Flat Stacked 3-D Beveled

Stacked

Which of the following is NOT a Table Style option? Subtotal Row Filter Button First Column Banded Rows

Subtotal Row

A bar chart is one of the most common types of charts used in Excel. True False

True

A chart can be resized from the Format tab. True False

True

A chart filter controls which data series and categories are visible on a chart in Excel. True False

True

A column sparkline could compare averages of prices or averages of test scores. True False

True

A disadvantage of a stacked column chart is that the segments within each column do not start at the same point. True False

True

A specific chart style controls the color of the chart area as well as the plot area. True False

True

A structured reference uses field names instead of cell references to make it easier to create formulas. True False

True

A table style controls the fill color of header rows. True False

True

Axes, chart titles, and data tables are examples of chart elements. True False

True

Before you create a chart, you should delete any blank rows or columns in the primary data set from which you will create a chart. True False

True

Default column headings of a table are Column1, Column2, and so on. True False

True

Displaying too much label content in a chart can clutter the chart. True False

True

Excel creates a chart on the same worksheet as the original data, but you can move the chart to its own chart sheet in the workbook. True False

True

If the default conditional format options do not provide what you need, you can create your own rule for formatting. True False

True

Pie charts often include percentage data labels. True False

True

Text can be sorted A to Z or Z to A. True False

True

Text can be sorted A to Z or Z to A. True False

True

Unfreeze Panes only appears on the menu when you have frozen rows and/or columns. True False

True

When you no longer need conditional formatting, you can clear it for a selected range or for an entire worksheet. True False

True

With data arranged in a table, you can display a total row after the last record. Excel sums the values in the last column automatically True False

True

You can apply text, value, and date filters to fields based on the data in a particular field. True False

True

You can change the color scheme of a chart by clicking the Chart Styles button. True False

True

You can create a table by selecting a range, clicking the Quick Analysis button, and clicking Tables. True False

True

You can switch data used in a chart to create the horizontal axis and the legend. True False

True

Which of the following is NOT one of most commonly used chart types? X Y chart Bar chart Line chart Pie chart

X Y chart

A(n) ________ is a key that identifies the color, gradient, picture, texture, or pattern of each data series in a chart. label trendline legend axis

legend