click below
click below
Normal Size Small Size show me how
Stack #1598364
Spread Sheet
| Term | Definition |
|---|---|
| work sheet | is a table of data that is organized into rows and columns. |
| work book | can be one worksheet or it can hold hundreds of worksheets. |
| range | a group of cells, you can make the same changes to all cells in the range. |
| auto fit | change the width of a column to fit the longest entry or change the height of a row to fit the font, |
| arithmetic operator | is a symbol that represents a specific action. |
| formula | in excel is a calculation that describes the relationship between cells. |
| function | a built in formula excel. |
| auto sum | button on the Formulas tab, Excel knows that you want to add the column of numbers above 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 order. |
| 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 to highest to lowest, such as Z to A or largest number 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 | also known as a graph, is visual way to display and compare data. |