click below
click below
Normal Size Small Size show me how
Stack #1598376
spreadsheets
| Term | Definition |
|---|---|
| worksheet | in Excel, a table of data that is organized into columns and rows |
| workbook | in Excel, a file that contains worksheets |
| range | a selected group of cells |
| Autofit | in Excel, a function that can automatically change the width of a column to fit the longest entry or change the height or a row to fit the font |
| arithmetic operator | a symbol that represents a specific action such as adding, subtracting, multiplying, or dividing |
| formula | in Excel, the relationship between cells, such as adding or dividing the contents of cells in an arithmetic equeation |
| function | an automatic formula in an arithmetic operation |
| Autosum | in Excel,a function that adds a column of numbers above or a row of numbers left |
| relative addressing | the change a formula makes when it is moved or copied to other cells with different data |
| sort | to arrange, classify, or separate from others according to class, kind or size |
| criteria | the characteristics that define your data, such as a name, a color, or a date |
| ascending sort | to arrange data in order form A to Z or from smallest number to gratedst number |
| descending sort | to arrange data in order from Z to A or greatest number to samllest nunber |
| filter | to limit information to the specific data or criteria you want |
| hiding | in Excel, to eliminate rows or columns that do not contain specific data or criteria |
| chart | a graphic tool used to compare data in a worksheet (aka a graph) |