Excel Chpt 3-4
A parallel range is one that consists of the same starting point of another range, but can have a different end point.
False
Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.
False
Filter arrows are always displayed in data tables.
False
Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
False
Selecting a range automatically makes it a data table.
False
To understand a chart you need to include the chart data.
False
What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?
Formula Autocomplete
Which of the following is not a freeze option?
Freeze Section
What is a disadvantage of a stacked column chart?
Segments do not start at the same point.
In a pie chart which of the following is a good reason for using category data labels rather than the legend?
They are easier to read
In rare cases you can chart text entries.
false
You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.
false
Which of the following is not a conditional formatting option?
table format
You can link to a cell as the title of a chart.
true
Which chart type is not listed in the All Charts window?
Sparkline
In conditional formatting what happens if the cell value does not pass the logical test?
The cell is not formatted.
When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?
The first unfrozen cell becomes the active cell.
If you use the Icon sets conditional formatting, you are limited to how many categories?
Three, four, or five
After a table has been named, that name can be used in functions instead of cell references.
True
You can add a row to a data table as long as you put in the row immediately below the table.
True
You can freeze as many columns and rows at the same time as you desire.
True
Which group on the Design tab would you select if you wanted to change the source information in the chart?
data
A parallel range is one that consists of the same starting point of another range, but can have a different end point.
false
A stacked column chart displays multiple columns for each category.
false
As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.
false
Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.
false
In Normal view or Page Layout view the data to be printed has a dark blue border.
false
What is the default data table style?
medium 2
The filter "Begins With..." option is found on which type of filter?
text filter
Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.
true
The Chart Styles gallery displays style options for the selected chart only.
true
This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].
true
When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.
true
When you want to chart two related types of data, the Combo chart is perfect.
true
You can switch the rows and columns in a chart to communicate a different perspective on your data.
true
You might want to avoid using 3-D charts because they can distort the appearance of the data.
true
If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)
2 or 3
How many variations of the stock chart does Excel have?
4
How many sizing handle are found on embedded charts?
6
How does Excel indicate that a column has been selected in a structured reference?
A colored border appears around that column.
If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?
Conditional formatting
You cannot sort cells by their fill color.
False
ocking is the process of making sure that certain rows or columns are visible at all times.
False
What group is not found on the Sparkline Tools Design tab?
Format
Which chart element cannot be chosen from the Chart Elements dialog box?
Format Back Wall
Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?
Highlight Cells Rules
What is not true about an effective chart?
It always contains more than one series.
Which table style option is useful to display aggregated data when it is checked?
Last column
What is the default data table style?
Medium 2
Which wildcard character only replaces one character with one other character?
Question mark ?
By default, what is the first table on a worksheet named?
Table 1
In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?
The range to be included in the calculation
When would you not need to use a fully qualified structured reference?
When referring to a cell within the table
"John Smith" is a good example of a field.
false
A chart sheet can hold, at most, two charts.
false
On which tab will you find options if you have to print a large dataset?
page layout
A 100% stacked column chart is similar to what other chart in that it converts values to percentages?
pie
What chart type represents data as spokes going from the center to the outer edge of the chart?
radar
What is not a purpose of using an effective chart?
reveals even subtle errors in formulas
To what does the @ symbol refer in a structured reference?
row
In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?
the count function
It is important to select parallel ranges.
true
In the task pane, what does a diagonal white triangle next to a chart category indicate?
Correct None of the category's options are displayed.
A parallel range is one that consists of the same starting point of another range, but can have a different end point.
Sparkline
Which chart type is a visual "dashboard" of your data?
Sparkline
By default Excel prints page in what order?
Top-left section, bottom-left section, top-right section, and bottom-right section
What is true about adding a new field to the right side of an existing data table?
You can add it to the right of the data table and Excel will extend the table to include the new field.
Including what, distorts the effectiveness of charting data points?
aggregates
What does Excel not determine about the value axis when you create a chart?
average value
Which chart type is preferable when the category names are long?
bar
Which chart type cannot be displayed as a sparkline?
bar chart
Where does Excel display the Total row in a table?
below the last row in a table
Which one of the following filter options is not found on the number filter submenu?
bottom 10
Where does Excel display the Quick Analysis tool?
bottom-right corner
In a structured reference what do you use to indicate a column heading or field name?
brackets []
Using the data bars conditional formatting, how is the highest value represented?
by the longest bar
Which of the following is not a characteristic of a table?
can contain multiple ranges
Which axis in a chart displays the descriptive labels for the data points?
category
What can you not do from the Select Data Source dialog box?
change chart type
What icon is not displayed when you select a chart?
chart types
Which chart type displays the data vertically?
column
What chart type can display two different chart types at the same time?
combo
Which chart type is best when you want to chart two unrelated data types?
combo chart
What cannot be found on the Manage Rules dialog box?
copy rule
Which of the following is not a chart element?
data area
A chart style effects the formatting of the chart itself, but not the chart data.
false
Locking is the process of making sure that certain rows or columns are visible at all times.
false
Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
false
Records are individual pieces of information.
false
The range used for a sparkline cannot include more than one row.
false
To print row labels on the left side of each page you would select the row(s) that contain the labels in the rows to repeat at left box.
false
Which one of the following filter options is not found on the date filter submenu?
first quarter
In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?
top right
After a table has been named, that name can be used in functions instead of cell references.
true
Even after selecting a data source for a chart you can still apply various filters on one or more series.
true
Excel normally uses all the selected data in creating a chart.
true
In a data table calculated columns will copy down the table automatically.
true
It is a good practice to print column and row labels on each page.
true
It is good practice to delete any blank rows or columns before creating a chart.
true
Sparklines do not include the normal chart labels.
true
When you use the Freeze Panes option you freezing both columns and rows.
true
What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?
January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015
What is not true about using the AND function in a custom conditional formatting rule?
All the tests must be of the same data type, for example: all numbers or all text.
What is not true about creating a data table?
Make sure to leave one blank row below the data labels.
In the task pane, what does a diagonal white triangle next to a chart category indicate?
None of the category's options are displayed
What font color does Excel use by default for many of its elements?
Black, Text 1, Lighter 35%
Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?
Sparkline
What data does Excel print by default?
The entire dataset on the active sheet
What should you not select when selecting data for a chart?
Worksheet titles
Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.
false
Excel uses dashed blue lines to indicate manual page breaks.
false
Excel uses solid blue lines to indicate automatic page breaks.
false
In Page Break Preview, the area to be printed has a light blue background.
false
It is impossible to create a data table from random, unorganized data.
false
To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
false
To understand a chart you need to include the chart data.
false
When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
false
Which table style option shows the field names when it is checked?
header row
Which tab displays the tools for creating charts?
insert
Which table style option is useful to display aggregated data when it is checked?
last column
Where does the primary axis display on a Combo chart?
left side
Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
true
You can select multiple print areas.
true
You cannot enter data or formulas on a chart sheet.
true
Which conditional formatting option is not found in the Quick Analysis Gallery?
undo format
Which axis in a chart displays incremental numbers for the data points?
value
In a bar chart, which axis displays the categories?
vertical
As a general rule, Pie charts should be limited to how many slices?
7
Which chart type displays the data vertically
Column
In the task pane, what does a diagonal black triangle next to a chart category indicate?
All the category's options are displayed.
Which of the following is not a way to bring up the Go To dialog box?
Alt+F7
Which chart type displays the data horizontally?
Bar
What can you not do from the Select Data Source dialog box?
Change chart type
What is not found on the Chart Elements List?
Chart Type
Which of the following is not a chart element?
Chart foreground