Home
Subjects
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Excel Function formulas
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
A list of Excel Functions for formulas.
Terms in this set (14)
SUM
Displays the sum of cells with numerical values in the argument range. For example, =SUM(D6:D21) displays the total added together if all the cells are filled.
MAX
Displays the maximum or largest of the range identified in the argument. For example, =MAX(E4:E9) displays the maximum or largest of the numbers contained in the range E4:E9.
MIN
Displays the minimum or smallest of the range identified in the argument. For example, =MIN(E4:E9) displays the minimum or smallest of the numbers contained in the range E4:E9.
AVERAGE
Displays the average of the range identified in the argument. For example, =AVERAGE(E4:E9) displays the average of the numbers contained in the range E4:E9.
COUNT
Displays the number of cells with numerical values in the argument range. For example, =COUNT(D6:D21) displays 16 if all the cells are filled.
SQRT
Displays the square root of the number identified in the argument. For example =SQRT(C4) will display the square root of the value in C4.
LN
Displays the natural logarithm of a number. For example, =LN(50) will display 1.69897.
STDE
Displays the standard deviation of the numbers contained in the range of the argument.
VAR
Displays the variance for the numbers contained in the range of the argument.
FV
Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.
PV
Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.
PMT
Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.
DATE
Displays the date in a variety of formats.
NOW
Displays the current date or time based on the computer's clock.
THIS SET IS OFTEN IN FOLDERS WITH...
Microsoft Excel
46 terms
1.05 Information and Support
24 terms
Computer Ethics Vocabulary
36 terms
Word & Excel 2010
82 terms
YOU MIGHT ALSO LIKE...
Computer Skills
16 terms
CSE Quiz 1
24 terms
LESSON 4: ADVANCED SPREADSHEET SKILLS
11 terms
CS105 Functions
11 terms
OTHER SETS BY THIS CREATOR
Lesson 1: Computers and Computer Systems
29 terms
Test Review 01
7 terms
Keyboard Commands
8 terms
PASS Technology Terms for Oklahoma
11 terms
OTHER QUIZLET SETS
Case Exam Financial Portion
22 terms
BUSINESS FINAL
22 terms
Econ 202 - Midterm II
43 terms
Financial Management Exam 2
33 terms