Excel II
Order by
36 terms
Terms | Definitions |
|---|---|
 Accounting Number Format | displays numbers with a dolla sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place) |
| arguments | the values that you use with a function |
| asterisk | The symbol that indicates multiplication. |
| AVERAGE function | sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range |
| best fit | the width of the column will be increased or decreased so the widest entry will fit in the column |
| blank cell | in excel has a numerical value of zero |
| Comma style format | can be assigned to a range of cells by clicking the Comma style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths |
| condition | is made up of two values and relational operator, it is true or false for each cell in the range |
| conditional formatting | formatting that appears only when the value in a cell meets conditions that you specify |
| debugging | fixing errors |
| e-mail | An electronic message sent from one person's computer to another person's computer where it is stored until read by the receiving person. |
| equal sign | ( = ) alerts Excel that you are entering a formula or function and not text |
| fixed dollar sign | places a dollar sign to the left of the cell leaving spaces between it and the cell numbers |
| floating dollar sign | appears immediately to the left of the first digit with no spaces |
| formula | An equation that calculates a new value from values currently in a worksheet |
| formulas version | shows the actual formulas you have entered, rather than the resulting values |
| function | a prewritten formula that is built into excel |
| hiding cells | a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want to see otherwise |
| landscape orientation | A page layout in which documents are printed across the length of a page, making the page wider than it is tall |
| MAX function | displays the highest (maximum) value in a range |
| MIN function | determines the lowest (minimum) number in the range |
| Normal View | the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane |
| order of operations | a set of rules for evaluating an expression involving more than one operation |
| Page Layout View | allows you to create or modify a worksheet while viewing how it will look in printed format |
| pixel | A picture element (dot) on a computer screen or printout. Groups of pixels compose the images on the monitor and the output of a printout. |
| Point mode | allows you to select cells for use in a formula by using a mouse |
| portrait orientation | Worksheets printed in this orientation are longer than they are wide |
| previewing the worksheet | see exactly how it will look without generating a printout |
| Range Finder | checks which cells are referenced in the formula assigned to the active cell |
| relative cell references | is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location. |
| smart tag indicator | a small purple triangle in a cell that indicates that a smart tag is available |
| smart tags | An icon which appears automatically when performing certain actions such as pasting in text or with AutoCorrection . |
| spell checker | the process of checking the spelling of words in a document against a dictionary of known words and offering advice on how to make corrections |
| theme | a predefined set of colors, fonts and chartstyles |
| values version | shows the results of the formulas you have entered, rather than the actual formulas |
| Web query | import data stored on a website using this |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.