Microsoft Excel Terms 100% Correct

Document Content and Description Below

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. [Show More]

Last updated: 2 years ago

Preview 1 out of 7 pages