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