Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Adv Excel Ch 2 Terms
Advanced Excel Chapter 2 Terms
| Question | Answer |
|---|---|
| Values version | shows the results of the formulas you have entered rather than the actual formulas |
| Formula version | shows the actual formulas you have entered rather than the resulting values |
| Debugging | the process of finding and correcting errors in the worksheet |
| CTRL ` | toggles between value version and formula version |
| Range Finder | verify the formula references |
| Accounting number format | dollar signs or displaying numbers specific ways as negative numbers in red--Insert commas or decimal points |
| Fixed dollar sign | is to the far left of the cell often with spaces between it and the first digit. |
| Order of Operation Direction | The formula in Excel is calculated left to right |
| Min Function | determining the lowest number in the range--example=MIN(D4:D12) |
| Conditional formatting | a format such as all shading or font color that Excel automatically applies to cells if a specified condition is true |
| Condition | is made up of two values and a relational operator (operator is a calculation symbol as + or /) |
| Best fit | the width of the column will be increased or decreased so the widest entry will fit in the column. |
| Argument | the values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers--what is inside the () of a function. |
| Average Function | sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. |
| Max Function | that displays the highest value in a range. |
| Function | a prewritten formula that is built into Excel. |
| Order of operation | 1. First negation(-) 2. All percentages (%) 3. All exponentiations (^) 4. All multiplications (*) and divisions (/) 5. All additions (+) and subtractions (-) |
| Point mode | allows you to select cells for use in a formula by using the mouse. |
| Smart Tags | produces a list of actions you can perform on the data in that specific cell. |
| Floating dollar sign | appears immediately to the left of the first digit with no spaces |
| Comma style format | can be assigned to a range of cells by clicking the Comma Style button on the Ribbon--default--2 decimals. |
| Percent Style | displays the value as a percentage rounding to the nearest percentage. |
| Valid Argument | =Sum(A1:Z33) |
| Example of an argument that is a range | =Sum (A1:Z22) |
| Valid Argument | =Sum (a1,a2,m3,22) (Valid or invalid) |
| Valid Argument | =Sum(1A,2A,3M) (valid or invalid) |
| Invalid Argument | =Sum(B1*2,A1 (valid or invalid) |
| Valid Argument | =Sum(B1*3,A1,22) |
| Worksheet Plan | 1. Plan layout2. formulas & functions3. special formats-decimals, currency, negative numbers ???4. Conditional formatting5. Printout appears-orientation, fit to one page, column,row headings, header/footer, etc.6. Worksheet name relates |
| Initial Cost Formula | Shares X Initial Price Per Share |
| Current Value Formula | Shares X Current Price Per Share |
| Gain/Loss Formula | Gain/loss/Initial Cost |
| If Function | Logical Function--will display text or values if certain conditions are met |
| If Function Format | =if(logical test, value if true, value if false) |
| Example of If Function | A1 is a grade: =if(a1>69,"passed","failed") |
| Example of If Function | A1 is number of cars you sold; you sell over 5 and you get a $500 bonus per car: =if(a1>5,a1*500,0) |
Created by:
eramig
Popular Computers sets