Chapter 3 and 4 Charts and Datasets and Tablets

What is the main benefit creating a stacked bar chart for the # of Jobs in 2010 and # of New Jobs values instead of creating a cluster bar chart

The stacked bar chart makes it easier to visualize the total of both groups of data

Why would you change the height of a chart using the Ribbon instead of using a sizing handle?

You can use the Ribbon when you want to select a specific height for a chart

Why would you create a pie chart instead of a clustered column chart or a line to depict the number of new jobs

you want to show the proportion number of new jobs by category to the total number of new jobs.

What is the purpose of creating a combo chart

You want to combine two different but related data types

You created a stacked bar chart using the job titles, numbers of jobs in 2010 and the number of new jobs. What is a good chart title for this chart

Projected number of jobs by 2020

What is the purpose for applying axes titles to a chart

-To provide more clarity about the value or category axis
- To inform people when the numbers are abbreviated, such as in millions, so that they comprehend the magnitude of the values
-To conform to ADA compliance
-All of the above

You created a pie chart showing the proportion of students in a class who earned A, B, C, D, and F grades. Which data label helps detail the proportion of the class that earned each grade?

Percentages

What is the purpose for exploding a slice in a pie chart

When you want to draw attention to a particular data point

The chart style controls the fonts, capitalization, font color and font size of

Data labels
Chart title
Category labels
All of the above

To temporarily remove data from being depicted in a chart, you should:

Apply a chart filter

What is the purpose in creating a sparkline

To create a simple visualization of data that is contained in one cell

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

Pie Chart

Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the category axis

CIS Managers

Which of the following is not a type of Sparkline

Bar

If you want to show exact values for a data series in a bar chart, which chart element should you display?

Data labels

The value axis currently shows increments such as 50000 and 100000. What option would you select to display the values in increments of 50 and 100?

Show Axis in Thousands

You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?

100% stacked column chart

Currently, a column chart shows values on the values axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?

Click Switch Row/ Column in the Data group on the Design tab.

What do you click to remove a data series from a chart so that you can focus on other data series?

Chart Filters

Which of the following does not display automatically when you create a clustered column chart?

Data labels

After you create a line type Sparkline, what option should you select to display dots for each data point?

Markers

Chart that groups columns side by side to compare data points among categories

Clustered Column Charts

Miniature chart contained in a single cell

Sparkline

Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time

Line Chart

Label that describes the entire chart

Chart title

Label That describes either the category axis or the value axis

Axis title

Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Legend

Chart type that compares categories of data horizontally

Bar chart

Chart that shows each data point in proportion to the whole data series

Pie Chart

Numeric value that describes a single value on a chart

Data point

Chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages

Combo Chart

A circle that enables you to adjust the height or width of a selected chart

Sizing handle

Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area

Gridline

Chart type that shows the relationship between two variables.

XY (scatter) chart

Group related data points that display in row or column in a worksheet

Data series

Window of options to format and customize chart elements

Task pane

Provides descriptive labels for the data points plotted in a chart

Category axis

Section of a chart that contains graphical representation of the values in a data series

Plot area

A container for the entire chart and all of its elements

Chart area

An identifier that shows the exact value of a data point in a chart

Data label

Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart

Value axis

The ____axis helps measure data from left to right in a graph

X

The _____ is the visual key to a chart

Legend

Do not use data _____ and individual values in a chart

aggregates

In a column chart horizontal axis displays the

Value

In a Chart Filter Excel uses ____ to indicate which chart categories are displayed in a chart

the row titles as the category names.

An _____ is a type of chart which fits in one cell

Sparkline

Where does Excel display the Quick Analysis tool?

Bottom-right corner

What is a disadvantage of a stacked column chart

Segments do not start at the same point

Which axis in a chart displays incremental numbers for the data points

Value

Which of the following is not a chart element?

These are chart elements: Axes
Axis titles
Chart titles
Data labels
Data table
Error bars
Gridlines
Legend
Trendline

Which chart type cannot be displayed as a Sparkline

Bar Chart

Which chart type is a visual "dashboard" of your data

Sparkline

What icon is not displayed when you select a chart

Quick Analysis

What does Excel not determine about the value axis when you create a chart?

Average value

Which of the following is not a chart element

Chart foreground

Which chart type displays the data vertically

categories

Where does the primary axis displays on a combo chart

Left side

What chart type represents data as spokes going from the center to the outer edge of the chart?

Radar

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed

Top right

A stacked column chart displays multiple columns for each category

False

To switch to a different chart type after the chart has been created you use the switch chart type tool

False

Pie charts can only display one data series

True

Including the column and row labels in a chart makes the chart harder to understand

False

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold

False

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

False

You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup

Change the print page order

You are working with a large worksheet. Your row headings are in column A. Which commands should be used to see the row headings and the distant information in columns X,Y,Z

Freeze Panes Command

Which statement is not a recommended guideline for designing and creating an Excel table

Leave one blank row between records in the table

Which of the following characters are wildcards in Excel

*, ?

What should you do to ensure that records in a table are unique

Use the Remove Duplicates command

Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values

Top 10 Items

Which date filter option enables you to restrict the view to only dates that occur in March of 2018

Between

Which of the following is an unqualified structured reference

[Purchase_Price]-[Down_Payment]

Which of the following is not an aggregate function that can be applied in a total row

VLOOKUP

If you would like to set a conditional formatting rule based on the function =AND(G6="Finance", H7<7000), which formatting rule type is needed

Use a formula to determine which cells to format

A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells

Data bar

A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications

Conditional formatting

A conditional format that displays a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

Data bar

The smallest data element contained in a table, such as first name, last name, address, and phone number.

Field

The process of specifying conditions to display only those records that meet those conditions.

Filtering

The process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.

Freezing

Symbols or signs that classify data into three, four, or five categories, based on the values in a range.

Icon set

An indication of where data will start on another printed page

Page break

The range of cells within a worksheet that will print

Print area

The sequence in which the pages are printed

Print order

A structure that organizes data in a series of records(rows), with each record made up of a number of fields(columns)

Table

The process of listing records or text in a specific sequence, such as alphabetically by last names.

Sorting

A tag or use of a table element, such as a field label, as a reference in a formula.

Structured reference

A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database

SUBTOTAL function

A group of related fields representing one entity, such as data for one person, place, event, or concept.

Record

The rules that control the fill color of the header row, columns, and records in a table.

Table style

A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as a sum or an average

Total row

To go to the first unfrozen cell you would press Ctrl+________ at the same time

Home

Using the Print ________ can help you save paper

Preview

A(n) ________ is a range of organized, related data.

table

When you include table names in a structure reference it is called a(n) ________ structured reference

fully qualified

If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n) ________ sort.

custom

If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells, you would use the Data ________ conditional formatting option.

bars

When you set up various conditions with the purpose of only showing a subset of data, that process is called ________.

filter

I. Highlight Cells Rules
II. Top/Bottom Rules
III. Data bars
IV. Color Scales
V. Icon Sets
A. Formats cells if they fall in the lowest % (% determined by the user)
B. Formats cells with gradients of color depending on the cell's value compared to the othe

I=D, II=A, III=B, IV=C, V=E

I. Header Row
II. Total Row
III. First Column
IV. Last Column
V. Filter Button
A. Displays a total row when selected
B. Makes sure that the row headings stand out
C. Displays on the right side of each heading in the header row
D. Used to make aggregated d

I=E, II=A, III=B, IV=D , V=C

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

The first unfrozen cell becomes the active cell.

What is not true about tables in Excel?

Row headings stay on the screen automatically

What is not true about creating a data table?

Make sure to leave one blank row below the data labels.

Which table style option is useful to display aggregated data when it is checked?

Last Column

What is not true about creating a data table?

For efficiency, make sure your data table does not exceed 256 rows.

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.

In conditional formatting what happens if the cell value does not pass the logical test?

...

What is not true about using the AND function in a custom conditional formatting rule?

The first of those nested IF statements where both conditions have to be met to return TRUE can be simplified using an AND statement and the second where either condition is true can be simplified using an OR statement. We will cover both of those now.
The AND statement follows this syntax; AND(conditional_statement_1, conditional_statement_2, conditional_statement_3 and so on). Each conditional statement is separated by a comma. The OR statement has exactly the same syntax except you use the OR function rather than AND.
In the AND statement all conditions are evaluated and if all are true they return TRUE.
In the OR statement if any of the evaluated conditions are true, it returns TRUE. Unlike the AND statement if the OR statement finds a suitable true condition it stops evaluating other conditions and returns TRUE. So on to some examples.
=IF(AND(First_Value<Second_Value,Third_Value<Fourth_Value),TRUE,FALSE) returns TRUE because 1 is less than 2 and 3 is less than 4. However, the remaining AND examples all have at least one condition that is untrue so they return FALSE.https://www.ablebits.com/office-addins-blog/2014/12/17/excel-and-or-xor-not-functions/#excel-not-function

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

The COUNT function

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

You cannot sort cells by their fill color.

False

You can add a row to a data table as long as you put in the row immediately below the table.

True

Filter arrows are always displayed in data tables

False

Excel uses solid blue lines to indicate automatic page breaks.

False

When you use the Freeze Panes option you freezing both columns and rows.

True