Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

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.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove Ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards




share
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

QuestionAnswer
____________ 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