Term | Definition |
Worksheet | is a table of data that is organized into rows and columns. |
Workbook | the excel file that holds your worksheet |
Range | which is a group of cells, you can make the same changes to all cells in the range. |
AutoFit | excel can also automatically 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 | is a calculation that describes the relationship between cells. |
Function | a built-in formula in excel |
AutoSum | automatically 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 date. |
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 date from lowest to highest, such as A to Z or smallest number to largest. |
Descending sort | is a sort to rearrange data from 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 a visual way to display and compare data. |