or...

incorrect cards (0)
correct cards (0)
remaining cards (0)
Save
0:01

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size     Small Size show me how

# Excel Vocab

Absolute Reference a cell reference that does not change when a formula is copied to a new location
Arrange to organize more than one window on the screen at the same time
AutoSum a function used to add values in rows or columns
Border a line or box that frames a cell
Button a graphic item that can be clicked to perform a specific task
Cell Reference the column letter and row number of a cell
Count a function that counts the number of cells in the range that contain numbers
Fill Handle a tool that lets you fill multiple cells with the same content by using one cell as an example
Filter a feature that allows you to look at only the data that you need
Footer text that appears at the bottom of the printed page
Formula Bar the bar that displays the contents of a cell
Freeze to keep headings in place while you scroll through a worksheet
Function a list of preset formulas that are used to solve equations
Go to a command that allows you to move directly to a particular cell
Header text that appears at the top of the printed page
Horizontal Alignment the side-to-side placement of the contents of a cell
IF a function that checks to see if a condition is met and then has one result if it is true and another if it is false
Landscape the orientation of a worksheet that is wider than it is tall
MAX a function used to identify the largest value in a group of cells
MIN a function used to identify the smallest value in a group of cells
NOW a function that displays the date and time that a worksheet is opened or used
Page Orientation the direction that a worksheet prints on a page (either landscape or portrait)
PMT a function that calculates payments for a loan based on interest rate, number of payments and the amount of the loan
Portrait the orientation of a worksheet that is taller than it is wide
Range a group of cells
Relative Reference a cell reference that changes when a formula is copied to a new location
Sheet Tab a small flap at the bottom of a worksheet that displays the name of the worksheet, allows you to move from one worksheet to another within the same workbook
Sort to put a list of data in ascending or descending order
Split to divide a window into two panes that you can scroll independently
Style a group of formatting traits that has been given a name
Text Box a moveable, resizable rectangle that contains text
Toolbar the bar that contains buttons that can be clicked to perform common tasks
Created by: ValerieSchanke on 2012-03-05