Show:
Types of Functions
Formulas
Vocabulary
Parts of a Workbook
Charts
100
uses operations such as addition, subtraction, multiplication, and division
What are mathematical and trigonometric functions?
100
=
What is the equal sign?
100
formatting that changes the looks of cells that meet a specified condition
What is conditional formatting?
100
horizontal placement of cells in a worksheet
What is a row?
100
shows the relationship of parts to a whole
What is a pie chart?
200
describes quantities of data
What is a statistical function?
200
the sequence used to calculate the value of a formula
What is order of evaluation?
200
a reference to the same cell or range in multiple worksheets that you use in a formula
What is a 3-D Reference?
200
feature on the status bar that can be dragged to zoom percentage of the worksheet you see in the window
What is a zoom slider?
200
chart inserted in the center of the worksheet
What is an embedded chart?
300
used to analyze loans and investments
What is a financial function?
300
=A3+A4 changes to =B3+B4
What is relative cell reference?
300
text that is printed at the top of each page
What is a header?
300
box that displays a formula when the cell of a worksheet contains a calculated value
What is a formula bar?
300
mini charts that you can insert into a cell
What is a sparkline?
400
displays text or values if certain conditions exist
What is a logical function?
400
in cell A5, the formula is =$A$3+$A$4 and when copied to cell B7, it is the same
What is absolute cell reference?
400
feature that lets you see the results of choices in a gallery before applying them
What is Live preview?
400
name of each worksheet at the bottom of the worksheet window
What is a sheet tab?
400
list that identifies patterns, symbols, or colors used in a chart
What is a legend?
500
used to format and display cell contents
What is a text function?
500
you can switch between formulas by using these
What is the Ctrl+`keys?
500
equation that calculates a new value from values currently in a worksheet
What is a formula?
500
worksheet view for adjusting page breaks in a worksheet
What is Page break preview?
500
area that displays the graphical representation of data
What is the plot area?