Put your calculator away - this function adds together a range of cells selected by the user.
What is "SUM"?
100
Copy and paste this will turn a function within a cell into a specific value.
What is Paste Values?
100
This identifies each column.
What is a column heading?
100
This chart is designed to show you a trend of the data over a period of time.
What is a line chart?
100
You would do this with a list of data to put it in an order of your choosing?
What is sort it?
200
This finds the arithmetic mean of a range of cells selected by the user.
What is "AVERAGE"?
200
Rather than inserting a row or column and cutting and pasting a row or column of data here, you can cut and do this.
What is insert cut row?
200
Need to maneuver through your sheet? Located on the right and bottom, these allow you to move your sheet.
What are scroll bars?
200
Use this chart if you want to see how much different categories make up of the total.
What is a pie chart?
200
In a data table, you might use this tool to find only entries that meet certain criteria.
What is filtering?
300
Using this function allows you to combine multiple cells into one cell.
What is "CONCANTENATE"?
300
Make it easy on yourself: Rather than creating a new worksheet to copy your current worksheet, right click on your current worksheet's tab and select this.
What is "Move or Copy"?
300
Within a workbook, these identify the different worksheets.
What are tabs?
300
These are the actual numbers shown on a chart at the given points?
What are data labels?
300
To find something in a worksheet, you can either use the "Find and Select" button, or hold Ctrl + this key.
What is the F key?
400
These types of functions deliver a specified value based on whether that test is true or false.
What are "IF THEN" functions?
400
Put your mouse away - Holding down Ctrl + this key allows you copy a cell, then holding Ctrl + this other key will paste it wherever your chose.
What is Ctrl + C and then Ctrl + V?
400
Rather than scrolling from top to bottom, or right to left, you can simulatenously hold this key and hit an arrow to move from one cell to the last cell in a table of data.
What is the Ctrl key?
400
Use this chart when you want to compare data across different categories.
What is a bar chart?
400
Use this if you want your cells to look a certain way if they meet a certain criteria (e.g. shade all cells with "ABC" yellow)
What is Conditional Formatting?
500
This function is used when you need to "look up" a value in a table for another value.
What is "VLOOKUP"?
500
All of the different paste options are within here.
What is "Paste Special"?
500
Clicking here will highlight an entire worksheet.
What is the "Select All" button, or the upper left hand button?
500
This is the generic name for a chart that combines two different chart styles into one chart (e.g. a line and bar chart).
What is a combo chart?
500
Use this tool to simply create summary tables of a list of data, no matter how large.