or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01

 Flashcards Matching Hangman Crossword Type In Quiz Test StudyStack Study Table Bug Match Hungry Bug Unscramble Chopped Targets

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

Excel Chapter 2

Definitions for chapter two

____________ is the process of using the mouse pointer to select cells while building a formula. Semi-selection
____________ indicates a cell's relative location from the cell containing the formula; the cell reference changes when a formula is copied. Relative cell reference
____________ indicates a cell's specific location; the cell reference does not change when you copy the formula. Absolute cell reference
___________ contains both an absolute cell reference and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy it. Mixed cell reference
____________ occurs when a formula directly or indirectly refers to itself. Circular reference
____________ is a predefined formula the performs a calculation. Function
___________ is a set of rules that govern the structure and components for properly entering a function. Syntax
____________ is an input, such as a cell reference or value, needed to complete a function. Argument
___________ displays a list of functions and defined names as you enter a function. Formula AutoComplete
____________ is a small pop-up description that displays the arguments for a function as you enter it. Function ScreenTip
____________ calculates the total of values contained in two or more cells. SUM function
_____________ calculates the arithmetic mean, or average, of values in a range. AVERAGE function
____________ identifies the midpoint value in a set of values. MEDIAN function
____________ displays the lowest value in a range. MIN function
____________ identifies the highest value in a range. MAX function
____________ tallies the number of cells in a range that contain values. COUNT function
____________ tallies the number of blank cells in a range. COUNTBLANK function
____________ tallies the number of cells in a range that are not blank. COUNTA function
____________ displays the current date. TODAY function
____________ displays the current date and time. NOW function
____________ evaluates a condition and returns one value if the condition is true and a different value if the condition is false. IF function
____________ is an expression that evaluates to true or false. Logical test
____________ is a function that contains another function embedded inside one or more of its arguments. Nested function
____________ is a range that contains data for the basis of the lookup and data to be retrieved. Lookup table
____________ is the lowest value for a specific category or series in a lookup table. Breakpoint
____________ looks up a value in a vertical lookup table and returns a related result from the lookup table. VLOOKUP function
____________ is a reference to a cell containing a value to look up. Lookup value
____________ is a range containing a lookup table. Table array
____________ is the argument in a VLOOKUP function that identifies which lookup table column from which to return a value. Colomn index number
____________ looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value. HLOOKUP function
____________ calculates the periodic payment for a loan with a fixed interest rate and fixed term. PMT function
____________ is the periodic interest rate, such as a monthly interest rate. Rate
____________ is the total payment periods. Nper
____________ is the present value of the loan. Pv
____________ is a word or string of characters that represents one or more cells. Range name
If cell D15 contains the formula =\$C\$5*D15, what is the D15 in the formula?
What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
When you type a function, what appears after you type the opening parenthesis?
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 in its new location?
A B10 cell contains a date, such as 1/1/2012. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?
Given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 containvalues 10, 20, and 30, respectively, what value will be returned by the function =IF(B6.A3,C6*A1,D6*A2)?
Given the function =VLOOKUP(C6,D12:F18,3), the enteries in:
Created by: TroyIS2241