Microsoft Excel Terms 100% Correct

Microsoft Excel Terms 100% Correct active cell the cell you are currently working on autoformat Predesigned formats that add a professional look to spreadsheets autosum A function used to add values in rows or columns. borders Adds or removes a frame around selected text or objects cell Point at which a column and row meet in a spreadsheet cell range A point to point distance in a worksheet ---ie. A2:D5 chart/graph A visual representation that shows statistical information and simplify complex set of data cursor Blinking line that appears on a blank screen that indicates where typing will begin data Information entered into the computer to be processed. decimal Two buttons that occur on the formatting toolbar- one to increase and one to decrease; used when formatting money formula In a spreadsheet, statement that performs calculation. formula bar The area on the spreadsheet that displays data that has been entered. function In a spreadsheet, built-in formulas that are shortcuts for common calculations such as sum and average. label Alphabetical text in a spreadsheet. merge & center A feature that enables you to automatically combine cells and align the contents name box The area on the spreadsheet that identifies the cell reference of the active cell. percent A fraction representing an amount out of 100 sorting Arranging data according to some particular order, such as alphabetical or numbering. spreadsheet Software designed to store and manipulate numeric data; the term is used interchangeably with worksheet value Numeric text in a spreadsheet. workbook A group of related spreadsheets. worksheet A grid with columns and rows. The term is used interchangeably with spreadsheet. arrows Keys that move up, down, left, or right in an Excel spreadsheet autofill A tool used to drag the cell contents to fill the appropriate range Columns Vertical arrangement of cells in a spreadsheet; identified by letters Rows Horizontal arrangement of cells in a spreadsheet; identified by numbers equal sign Used to indicate the start a formula fill handle The black square in the lower-right corner of the active cell or range that you drag over the cells you want to fill. Microsoft Excel 2013 (Excel) The spreadsheet program in Microsoft Office 2013. Column Appears vertically in the worksheet; identified by letters at the top of the worksheet window. Nonadjacent range A range that includes two or more adjacent ranges and selected cells. Adjacent range A range where all cells touch each other and form a rectangle. Cell reference A unique identifier for a cell, which is formed by combining the cell's column letter and row number. Worksheet A computerized spreadsheet in Excel. Formula Bar The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of the formula). Active worksheet The worksheet that is displayed in the work area. Spreadsheet A grid of rows and columns in which you enter text, numbers, and the results of calculations. Name box The cell reference area located below the Ribbon, which displays the cell reference of the active cell. Landscape orientation A page or worksheet rotated so it is wider than it is long. Range reference The unique identifier for a range, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon. Active cell The cell in the worksheet in which you can type data. Portrait orientation A page or worksheet ratated so it is longer than it is wide. Row The horizontal placement of cells in a table or worksheet. Sheet tab The name of each worksheet at the bottom of the worksheet window. Cell The intersection of a column and a row in a table or worksheet. Formula An equation that calculates a new value from values currently in a worksheet. Workbook The file used to store worksheets; usually a collection of related worksheets. Range A group of selected cells.