click below
click below
Normal Size Small Size show me how
Excellent Excel
Stuff
Term | Definition |
---|---|
Spreadsheet | an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations. |
Workbook | a single file containing different types of information as separate worksheets |
Worksheet | a data file created and used by a spreadsheet program, which takes the form of a matrix of cells when displayed |
workbook | the window which displays which workbook you are currently working on |
cell | a field in a spreadsheet in which you can input data that is usually text, a numeric value, or a formula. |
sheet tab | the current worksheet being displayed |
active worksheet | a single spreadsheet that contains cells organized by rows and columns. |
workspace | group of workbooks |
columns | cells that run vertically |
rows | cells that run horizontally |
headings | the colored row of letter or numbers that identify each column or row on the sheet. |
cell reference | it refers to a cell or range of cells on a worksheet and can be used in a formula. |
Name Box | the box left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
Formula bar | a toolbar at the top of the Microsoft excel spreadsheet window that you can use to eo enter or copy an existing formula in to cells or charts. |
formula | self-defined instructions for performing calculations |
relative reference | a cell in a spreadsheet that is a location based cell reference |
absolute reference | a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. |
mixed reference | it is either an absolute and relative row or absolute row and relative column |
active cell | a cell in spreadsheet that is currently selected |
enter data | ways to put information and save them on excel |
Range | the term used for the cells selected. |
gridlines | lines that define the boundaries of cells, columns, and rows in a worksheet |
T or F:you can print more than one sheet on a single page | True |
T or F:You can change the data in your chart after creating it | True |
T or F:You have to manually do your own calculations | False |
T or F:You have to manually type down formulas | False |
T or F:You cannot create borders on your data | False |