click below
click below
Normal Size Small Size show me how
AR CBA Excel Ch 1
Term | Definition |
---|---|
Excel | spreadsheet program in Microsoft Office 2010 that includes rows,and columns, used primarily for calculations |
Spreadsheet | grid of rows and columns used to enter text, numbers, formulas, results of calculations. |
Worksheet | same as a spreadsheet basically. a computerized spreadsheet in Excel. this is made for a specific thing, a page for a special item, i.e., the 4-H trap shooting events we looked at for an example |
Workbook | a collection of worksheets |
Sheet tab | the name of each worksheet appears in the sheet tab at the left bottom corner of the worksheet |
Coulumns | appear vertically-- go down the page, labeled by A, B, C's |
Rows | appear horizontally and are identified by numbers on the left side of the worksheet |
Cell | an intersection of a row and a column, you can type data in it, looks like boxes |
Cell reference (address) | formed by combining the column letter and the row number, It is the identification of the cell location |
Active cell | the cell on the worksheet where you can enter data |
Name box | located below the ribbon- displays the cell reference of the active cell |
Formula bar | appears to the right of the name box and displays a formula when the cell of a worksheet contains a calculated value |
Formula | an equation that calculates a new value form values currently in the worksheet. You have to type and "=" first in cell before the formula. HAve to use cell addresses not just the number |
Range | a group of selected cells on the spreadsheet |
Range reference | like cell reference identifies what cells are in your range. Starts at left corner goes to bottom right corner as you drag the mouse over the range of cells |
Active worksheet | the worksheet that is displayed on you monitor that you are working on now. |