Save
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

Calc functions

QuestionAnswer
Returns the number of days of the month in which the date entered occurs. DAYSINMONTH
Returns the integer portion of a division QUOTIENT
Returns a value if a condition is met or another if the condition is not met. IF
Count how many numbers are in the list of arguments. COUNT
Returns the most common value in a sample. MODE
Returns the sum of all arguments SUM
Returns the number of days of the year in which the date entered occurs DAYSINYEAR
Returns the maximum value in a list of arguments MAX
Counts how many values are in the list of arguments COUNTA
Determines the sequential date of the month as an integer (1-31) in relation to the date value. DAY
Calculates the remainder of a division MOD
Count the arguments which meet the set conditions and they are not empty. COUNTIF
Returns the minimum value in a list of arguments MIN
Returns the year of a date value as an integer. YEAR
Calculates the date of the Easter Sunday in a given year EASTERSUNDAY
Rounds a number to a predefined accurancy ROUND
Returns the average of all arguments AVERAGE
Menu where you can find automatic formatting FORMAT
Calculates the number of days between two dates DAYS
Format menu option to change the number format CELLS
It totals the arguments which meet the conditions. SUMIF
This function allows you to search a table which is set up vertically. VLOOKUP
This function allows you to search a table which is set up horizontally. HLOOKUP
Returns the central value of a sample where the numbers are ordered from highest to lowest or from lowest to highest. MEDIAN
Determines the current time of the computer. NOW
Determines the sequential number of a month of the year (1-12) for the date value. MONTH
Returns the day of the week for the date value as an integer (1-7) WEEKDAY
Calculates the number of years in a specific period YEARS
Calculates the number of months between two dates MONTHS
Calculates the number of weeks between two dates WEEKS
Created by: anapalasi
Popular Computers sets

 

 



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