Save
Busy. Please wait.
Log in using Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
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.
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
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

CTS 130 EM03

Excel Module 3

QuestionAnswer
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing. cube
The ____ category of Excel functions retrieves and analyzes data. database
The ____ category of Excel functions returns (true-false) values logical
=INT(AVERAGE(A1:A100)) is an example of a(n) ____ function. nested
After you describe a function in the Insert Function dialog box, click ____. go
Every function has to follow ____. syntax
The numbers, text, or cell references used by the function to return a value are called ____. arguments
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= “NO”? returns “RESTART”
The PMT function is a(n) ____ function. financial
With ____ interest, the borrower always pays more money to the lender the following year. compound
The FV function stands for ____. future value
The amount of money being loaned is known as the ____. principal
If you were to see ##### in cell B10, the ____ is too small to view the entire value. column width
The ____ function returns the maximum value in the range. max
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations. relative
Absolute references are marked with a ____. $
When you copy a formula that contains an absolute reference to a new location, the reference ____. does not change
Use ____ references when you want different formulas to refer to the same cell. absolute
One of the most common statistical approaches is to ____ the sample data. average
Another name for the middle value is the ____ value. median
The ____ is most often used with data that has only a few possible values. mode
____ arguments may provide more control over the returned value. optional
FUNCTION(argument1, argument2, ...) is ____. general syntax of all functions
Arguments can be ____. cell references, numbers, or text
If an optional argument is not included, Excel assumes a(n) ____ value for it. default
Excel functions are organized into ____ categories eleven
Lookup & Reference is ____. an excel function category
The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP. cube
In “SUM(number1 [, number2, number3, ...])”, number 1, number 2, and number 3 may be numbers or ____. cell references
Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____ information
Functions can be ____. incorporated as part of larger formulas or placed inside another function
In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____ find the average of A1:A100
When you nest functions, you should have ____. same number of left and right parentheses
The Insert Function button is in the ____ group. function library
Optional arguments are in ____ type. normal
The Insert Function dialog box has a(n) ____ option. search
Most Recently Used is a ____. category in the Insert Function Arguments dialog box
The fill handle copies ____. content and formats
Using AutoFill is ____ than copying and pasting. faster
Blue, Accent1, Light 60% is an example of cell ____. formatting
Another way to copy a formula is to use the Fill button on the ____ group. editing
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting. content.
Using AutoFill, what would be the extended series of the initial entry Jan? ___ feb, mar, apr, etc.
For most loan and investment calculations, you need to enter the annual interest rate ____ the number of times the interest is compounded during the year. divided by
As you drag the fill handle, you will see ____. screen tips
A logical function is a function that works with values that are either ____. true or false
>= is a(n) ____ operator. comparison
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. A ≠ B
Part of effective formula writing is knowing when to use relative, absolute, and ____ references. mixed
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table. mixed
Created by: galvanl
 

 



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