Excel Chapter 3 & 4
What are the sort options?
1) Text, A-Z and Z-A 2) Dates, oldest to newest and newest to oldest 3) Values, smallest to largest and largest to smallest 4) Color, cell color or font color
What is the Go To Command?
Click Find & Select in the editing group on the home tab and select Go to or F5 or Ctrl+G to display the go to dialog box
What does freeze panes do?
It keeps both rows and columns above and to the left of the active cell visible as you scroll through a spreadsheet
To prevent wasting paper, always use __________. It enables you to adjust page settings until you are satisfied with how the data will print
Print Preview
______ is the sequence in which the pages are printed.
Print order
You should plan ______ before creating a table
Structure
_______ control the fill color of the header row (row containing field names) and rows of records
Table styles
Two ways to go to a specific cell
Use the go to function or click in the name box and type cell reference
When do you need to use fully qualified structured references?
When you need to use table data in a formula outside the table boundaries
A page break is:
an indication where data will start on another printed page
A _______ is a collection of formatting that controls the color of the chart area, plot area and data series
chart style
______ indicate where automatic page breaks occur and ______ indicate manual page breaks
dashed lines, solid blue lines
The default print settings send an entire __________ on the active worksheet to the printer
dataset
Once a data range is converted into a table, each column represents a _______, which is an individual piece of data
field
_______ is the process of specifying conditions to display only those records that meet certain conditions
filtering
a structured formulas that includes references, such as table name, is called a ___________
fully qualified structured reference
________- is the process of arranging records by the value of one or more fields within a table
sorting
a ________ is a tag or use of a table element, such as a field heading, as a reference in a formula (ie: =[Amount]-[Down_Pay]
structured reference
the ________ calculates an aggregate value, such as totals or averages for displayed values in a range
subtotal function
Icon sets are ________________
symbols or signs that classify data into three, four or five categories based on the values in a range
_____ is a structured range that contains related data organized in a method that increases the capability to manage and analyze information
table
After you create a table, the ____________ tab displays. Excel applies the default _____________ style to the table and each cell in the header row has _________.
table tools design, table style medium 2, filter arrows
The calculations on a total row use _________
the subtotal function
A ______ displays below the last row of records in a table and enables you to display summary stats, such as the sum of values displayed in a column
total row
The use of field headings without row references in a structured formula is called a __________
unqualified reference
In page break preview, the print area has a _______ background and ______border. The rest of the worksheet has a gray background
white, solid blue
Excel enables you to sort data on __ different levels.
64
What is a sparkline
A small line, column or win/loss chart contained in a single cell
A _____ controls which data series and categories are visible in a chart
Chart Filter
Chart tool design tab contains two other groups to update a chart outside of chart elements:
Chart Styles and Data
______ format cells with different colors based on the relative value of a cell compared to other selected cells
Color scales
Benefits of a table
Column headings remain onscreen without having to use freeze panes, filter arrows, table styles, calculated columns, calculated total rows, can use structured references and can export to a sharepoint
__________ applies special formatting to highlight or emphasize cells that meet specific conditions
Conditional Formatting
_____ add a gradient or solid filled bar in which the width of the bar represents the current cell's value compared relatively to the other cells' value
Data bars
The organization method used to manage multiple data points within a dataset
Data structure
What are the 3 Freeze options?
Freeze panes Freeze top row Freeze first column
How do you unlock frozen panes?
Freeze panes in the window group under View tab and select Unfreeze Panes
_____ is the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large data sheet
Freezing
What are the table style options?
Header row Total Row First Column Last Column Banded Rows Filter Button
Before using freeze panes, make the active cell ____________________
one row below and one column to the right of the rows you want to freeze and the columns you want to freeze
The range of the cells that will print is called the _______
print area
Each row in a table represents a ______, which is a collection of related data about one entity
record