Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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 Ch 02

Formulas and Functions

QuestionAnswer
A formula in Excel must begin with: an Equals (=) sign
A relative cell reference: indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula.
A circular reference: occurs when a formula directly or indirectly refers to the cell containing the formula.
Excel displays a green arrow in the top left corner of a cell if it detects a: potential error.
A function is a: redefined formula that performs a calculation.
An argument (as it applies to Excel 2010): is an input such as a cell reference or a value needed to complete a function.
The SUM function: calculates the total of values contained in two or more cells.
For a BASIC/SIMPLE mathematical expression it is best to use: Formulas, such as =B4+C4.
The AVERAGE function: calculates the arithmetic mean or average of values in a range.
The MIN function: displays the lowest value in a range.
The COUNT function: tallies the number of cells in a range that contain values.
The COUNTA function: tallies the number of cells in a range that are not empty.
The MAX function: identifies the highest value in a range.
The TODAY function displays the current date (not time). True
The NOW function evaluates a condition and returns one value if the condition is true and a different value if the condition is false. False
The IF function evaluates a condition and returns one value if the condition is true and a different value if the condition is false. True
A nested function is the lowest value for a specific category or series in a lookup. False
A lookup table contains data for the basis of the lookup and the data to be retrieved. True
The breakpoint is a reference to a cell containing a value to look up. True
The VLOOKUP function looks up a value and returns a related result from a column in the lookup table. True
The column index number is the periodic interest rate, such as a monthly interest rate. True
The PMT function is the total number of payment periods. False
The NPER is the total number of payment periods. True
A range name indicates a cells relative location from the cell containing the formula. False
To simplify entering ranges in formulas, you can use range names. True
D15 contains the formula =$C$5*D15, what is the D15 in the formula Circular reference
What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5 =averarage(B5:F5)
When you type a function, what appears after you type the opening parenthesis Function Screen Tip
A formula containing the entry =-$B3 is copied to a cell one column to the right and two row down. How will the entry appear in the new location =$B5
Cell B10 contains a date, such 1/1/2012. Which formula will determine how many days are between that date and the the current date, given that the cell containing the formula is the formatted with Number Format +TODAY()-B10
Given that cellsA1, A2 andA3contain values 2, 2 and 10respectively, and B6, C6, and D6contain values 10, 20, and 30, respectively, what value will be returns by the function =IF(B6.A3, C6*A1, D6*A2)? 90
Given the function+VLOOKUP(C6,D12:F18,3), the entries in: Range D12:D18 are in ascending order
The function =PMT(C5,C7,-C3)is stored in cell c15. What must be stores in cell c7? Number of payment periods
Which of the following is not an appropriate use of the SUM function? =SUM(D15-C15)
Which of the following is not an acceptable range name? Goal for 2012
Created by: tstaton
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards