Spreadsheet Terms
Order by
15 terms
Terms | Definitions |
|---|---|
 Excel | spreadsheet application that can help you calculate and analyze numerical information |
| simple formulas | one mathematical equation |
| order of operation | tells which operator to calculate first |
| PEMDAS rule | Parentheses, exponenetial, multiplication, division, addition, subtraction |
| relative references | when copied or filled, cell references change based on the relative position of rows and columns |
| absolute references | when copied or filled, cell references do not change so the values stay the same |
| Dollar sign $ | designates in the formula that a cell reference is absolute |
| function | a predefined formula |
| common functions | sum, average, product, or count |
| = sign | indicates to the computer that a formula is to be used |
| colon : | creates a reference to a range of cells |
| sorting | a common task that allows you to change or customize the order of the spreadsheet data |
| A - Z | ascending order |
| Z- A | descending order |
| numerical order | sorting numbers from smallest to largest or largest to smallest |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.