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) |