click below
click below
Normal Size Small Size show me how
Stack #1598442
Spreadsheets
| Term | Definition |
|---|---|
| Worksheet | Is a table of data and preform various calculations columns |
| Workbook | The Excel file that hold your worksheets |
| Range | A group of cells, you can make changes to all cells in range |
| AutoFit | Excel can also automatically change the width of a column ti fit the largest entry or change |
| Arithmetic Operator | Is a symbol that represents a specific action |
| Formula | Is a calculation that describes the relation between cells |
| Function | A built-in formula |
| AutoSum | Button on the formulas tab, Excel automatically know that you want to add the column of numbers or add the row of numbers to the left |
| Relative Addressing | Refers to the change a formula makes when it is moved or copied to other cells with different data |
| Sort | Is a way of arranging data in a particular way |
| Criteria | Are characteristics that define an item, such as age or last name |
| Ascending Sort | IS a sort to rearrange data from lowest to highest, such as A to Z or smallest to largest |
| Descending Sort | Is a sort to rearrange data from highest to lowest, such as Z to A or largest to smallest |
| Filter | Finds just the information you need and hides the rest |
| Hiding | Is another way to reduce the amount of information displayed |
| Chart | Is a visual way to display and compare data |