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