What is the word used to identify the guide for understanding a charts contents?
Pie and Exploded Pie charts are effective for...
Displaying proportional relationships
only used when the number of categories is small and the relative sizes of the different slices is easily determined
Column Charts/Stacked Column Charts
Used for displaying numbers
displays data vertically also have clustered column chart
depicts total by category instead of each individual data point
useful when you want to compare totals by category
show numbers horizontally
This type of chart uses a line to connect data points in order to show trends over a period of time (x-axis displays time units, y-axis displays values for each point)
best for categories that follow sequential order with a constant time interval
Emphasizes the magnitude of changes over time by filling in the space B/W lines with a color
XY (Scatter) Chart
This type of chart shows the relationship B/W two variables
show patterns or a relationship B/W 2 or more sets of value
shows the high, low, opening, and closing prices for individual stocks over time
Displays trends using two dimensions on a continuous curve
Displays values as percentages of a whole, but may contain more than one data series
Shows the relationship among three values by using bubbles
What are line charts best used for?
Showing changes in time
KISS Principle in designing charts
KEEP IT SIMPLE
Pie, column, bar and line charts assume?
numbers are plotted against categories
If you change the cell values in the tables related to the charts, do the values in the charts automatically change?
Is the range that contains the data you want to display in the chart
Chart is placed in a worksheet next to its data source
A miniature chart displayed in a single cell
Controls which data series and categories are visible in a chart
Freezing Rows and Columns
Lets you keep headings visible as you work with the data in a large worksheet
Structured range of related data formatted to enable data management and analysis
An individual piece of data
Complete set of data for an entity
Can table names contain spaces?
Controls the fill color of the row, columns, and records
Rearrange, or sort, the records in a table or range based on the data in one or more fields
A tag or table field name used in a formula or function
The process of displaying only records that meet specific conditions
Ex) Numeric, Date, "Equals",
What is the subtotal function used for?
Provides a sum for a range of data
Specifies the type of condition (such as formatting cells greater than a specified value), the type of formatting when that condition occurs
When is the New Formatting Rule dialog box used?
To create a customized rule
Can file Names have Blanks?
an indication where data will start on another printed page
A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications
Helps others see the hierarchal structure of data
makes the data appear on multiple times by adjusting the row height to fit the cell contents within the column width
tallies the numbers of cells in a range that are not blank
displays incremental numbers to identify the worksheet values (such as number of jobs or revenue) used to create the chart.
component that completes or helps clarify the chart
Horizontal and vertical lines than span across the chart to help people identity the values plotted by the visual elements, such as column, Excel displays horizontal gridlines for column, line, scatter, stock surface and bubble charts and vertical gridlines.
Labels that describe the category and value exes
An aggregate calculation, such as SUM or AVERAGE, that applies for a subcategory of related data within a larger dataset
Subtotaling feature creates outlines
A hierarchical structure of data organized so that groups can be expanded to show details or collapsed to show high-level structure.
Process of identifying trends and patterns in data
Excels Interactive data mining Feature
Great way to summarize data in a professional looking report
enables you to summarize a ray of data in a excel table into a concise, tabular format for easier reporting and analysis
Can you change the data directly in a PivotTable?
NO, you must edit the excel table then refresh or update, the pivot table to reflect the current state of art objects list
What process to PivotTables support?
Type of Sorts and Filters for a PivotTable
Sorts- Smallest to largest and Vice Versa
Filters- report and group
provide buttons that you can click for quick filtering
indicate the current filtering state
What are Slicers used for in Excel
Filtering PivotTable data
Graphical representation of a PivotTable
A constraint in Solver enforces to reach a target value
A value that you can change
process of changing variables to see how changes will affect the calculated results
Value that replaces the original value of a variable in a data table
Helps to perform more sophisticated what-if analysis
Best Case, Most likely, Worst case
Creates a scenario summary report
A program that can be added into excel to provide enhanced functionality
A set of values that represent a possible situation
One variable data table
A data analysis tool that provides various results based on changing one variable
Method for finding solutions in What-If analysis by working backwards from the end result to determine the input to produce that result
An add in application that manipulates variables based on constraints to find the optimal solution to a problem
A lookup and reference value or reference to a value within a range
What What-if analysis tool is best for manipulating one variable to determine one result?
Once a slicer is inserted into a worksheet, which of the following actions cannot be performed?
Append the Slicer
True or False: Histogram is a tool of the Analysis tool pack?
Nested Logical function
Logical function embedded in another logical function
True or False: the not function can only contain one argument
Returns the position of a value on a list
Returns a value or the reference to a value within a range based on x and y coordinates
Set criteria for fields using the drop-down list for the field
Can set criteria for multiple fields
Advanced Filter extends Autofiltr in 2 important ways
Creates more complex criteria
copies the rows to another section of the worksheet, leaving the original list intact
Criteria are case sensitive
Text entries treated as though they have wildcards(*)
similar to statistical functions. their names are preceded with a D
Three arguments: database,field,criteria
Profit Loss/Income Statement
How much money businesses make or lose over a period of time
Determining values that do not appear in a given set of values
Inferring values that do not appear in a given value set
Cost, salvage value, life
Process of decreasing or accounting for an amount; over a period