CH 2: Formulas and Functions
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Absolute cell reference | show 🗑
|
||||
| show | A variable constant input, such as a cell reference or value, needed to complete a function. The entire group of arguments for a function is enclosed in parenthesis.
🗑
|
||||
| show | A statistical function that calculates the arithmetic mean, or average, of values in a range.
🗑
|
||||
| Breakpoint | show 🗑
|
||||
| Circular reference | show 🗑
|
||||
| show | The number of the column in the lookup table that contains the return values. Used as the third argument in a VLOOKUP or HLOOKUP function.
🗑
|
||||
| show | A statistical function that tallies the number of cells in a range that contain values you can use in calculations, such as the numerical and date data, but excludes blank cells or text entries from the tally.
🗑
|
||||
| show | A statistical function that tallies the number of cells in a range that are not blank; that is, cells that contain data, whether a value, text, or formula.
🗑
|
||||
| COUNTBLANK function | show 🗑
|
||||
| show | A feature that displays a list of functions and defined names that match letters as you type a formula.
🗑
|
||||
| show | A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments.
🗑
|
||||
| show | A small pop-up description that displays the arguments for a function as you enter it directly in a cell.
🗑
|
||||
| HLOOKUP function | show 🗑
|
||||
| IF function | show 🗑
|
||||
| show | An expression that evaluates to true or false; the first argument in an IF function.
🗑
|
||||
| Lookup table | show 🗑
|
||||
| Lookup value | show 🗑
|
||||
| MAX function | show 🗑
|
||||
| show | A statistical function that finds the midpoint value, which is the value that one half of the values in a list are above or below.
🗑
|
||||
| MIN function | show 🗑
|
||||
| show | A designation that combines an absolute cell reference with a relative cell reference, such as $B4 or B$4.
🗑
|
||||
| show | A function that contains another function embedded inside one or more of its arguments.
🗑
|
||||
| show | A date & time function that uses the computer's clock to display the current date and time in a cell.
🗑
|
||||
| Nper | show 🗑
|
||||
| show | A financial function in Excel that calculates the periodic loan payment.
🗑
|
||||
| show | The present value of a loan or an annuity; the third argument in the PMT function and refers to the original amount of the loan.
🗑
|
||||
| Quick Analysis | show 🗑
|
||||
| Range name | show 🗑
|
||||
| Rate | show 🗑
|
||||
| Relative cell reference | show 🗑
|
||||
| SUM function | show 🗑
|
||||
| show | The rules that dictate the structure and components required to perform the necessary calculations in an equation or to evaluate expressions.
🗑
|
||||
| show | The range that contains the body of lookup table, excluding column labels. The first column must be in ascending order to find a value in a range;it can be in any order to look up an exact value. The second argument within a VLOOKUP or HLOOKUP function.
🗑
|
||||
| TODAY function | show 🗑
|
||||
| VLOOKUP function | show 🗑
|
||||
| A set of rules that governs the structure and components for properly entering a function. | show 🗑
|
||||
| show | TODAY function.
🗑
|
||||
| Indicates a cell's specific location; the cell reference does not change when you copy the formula | show 🗑
|
||||
| show | Circular reference.
🗑
|
||||
| show | Argument.
🗑
|
||||
| show | MAX function.
🗑
|
||||
| Tallies the number of cells in a range in a range that contains values. | show 🗑
|
||||
| Looks up a value in a vertical lookup table and returns a related result from the lookup table. | show 🗑
|
||||
| A range that contains data for the basis of the lookup and data to be retrieved. | show 🗑
|
||||
| Calculates the arithmetic mean, or average, of values in a range. | show 🗑
|
||||
| Identifies the midpoint value in a set of values. | show 🗑
|
||||
| show | NOW function.
🗑
|
||||
| Evaluates a condition and returns one value if the condition is true and a different value if the condition is false. | show 🗑
|
||||
| Calculates the total of values contained in two or more cells. | show 🗑
|
||||
| Calculates the periodic payment for a loan with a fixed interest rate and fixed term. | show 🗑
|
||||
| show | Relative cell reference.
🗑
|
||||
| Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula. | show 🗑
|
||||
| A word or sting of characters that represents one or more cells. | show 🗑
|
||||
| show | Logical test.
🗑
|
||||
| show | MIN function.
🗑
|
||||
| show | Circular reference.
🗑
|
||||
| show | =AVERAGE(B5:F5)
🗑
|
||||
| show | Formula AutoComplete
🗑
|
||||
| A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear inits new location? | show 🗑
|
||||
| show | =TODAY()-B10
🗑
|
||||
| show | 90
🗑
|
||||
| Given the function =VLOOKUP(C6,$D$12:$F$18,3), the entries in | show 🗑
|
||||
| The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5? | show 🗑
|
||||
| Which of the following is not an appropriate use of the SUM function? | show 🗑
|
||||
| show | Goal for 2016
🗑
|
||||
| show | The process of using the mouse pointer to select cells while building a formula.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Created by:
TroyIS2241
Popular Computers sets