Show:
Charts
Functions
Data
Format
Tables
100
Sales per year plotted within a y and x axis and connected with line
What is a line chart?
100
Click this icon in the ribbon to total data within the highlighted range.
What is auto-sum?
100
Controls the type of data or the values that users enter into a cell.
What is data validation?
100
This tool allows you to hold header rows stationary as you scoll down the spreadsheet.
What is freeze pains?
100
Row and columns in a spreadsheet can be converted to this for ease of manipulating the data.
What is a table?
200
A round graph that depicts the persentage of each to the whole.
What is a pie chart?
200
Information needed to determine payments.
What is interest rate, number of periods and present value of loan?
200
Use this feasture to pull multiple ranges of data into one range.
What is consolidate?
200
This button/option allows you to limit edit rights in certain cells.
What is lock cell?
200
The first step to create a Pivot Table is found on this tab in the ribbon
What is insert?
300
the list of names of each of the data series in the chart.
What is the legend?
300
The function used to combine data in two cells into one cell
What is concatenate?
300
One way to arrange data from largest to smallest.
What is sort?
300
This tool aids in duplicating formatting of one cell to another cell.
What is format painter?
300
This is a graph created in a pivot table.
What is pivot chart?
400
Mini graph depicting trends
What is a sparkline?
400
This function is helpful in calculating a weighted average.
What is SUMPRODUCT?
400
Grabbing the right corner of a cell with data and dragging to complete sequences of numbers, names etc
What is fill down?
400
This option allows the user to attach a note to a particular cell that can be hid or shown, printed or not.
What is comment?
400
After changing data on the worksheet this click must be done to update the pivot table.
What is refresh?
500
Add the value of each data cell to its area on a chart.
What is data labeling?
500
This function highlights cells of interest with colors, shading, etc based on set critiera.
What is conditional formatting?
500
A process of identifing the largest to smallest without rearranging data.
What is ranking?
500
Professor Wilson prefers this format for all dollar values.
What is number?
500
Used to format the data in a pivot table.
What is value field settings?