load
load
load
load
load
load
load
load
Sugarcane will be shutting down on June 30, 2018. For more information, .

Excel 1.04 and 1.05 Using Basic Functions

Review of Function and example of the function
a data set by jluper
created September 22, 2016
COPY & EDIT
FAMILY TREE
TermExample
Absolute Cell Reference$B$5
Formula=B4*B5
Function=Count(B2:B10)
RangeB2:B10
Addition Operator+
Mulitiplication Operator*
Range Operator:
Returns Current Date=Today()
Returns Current Date and Time=Now()
Subtraction Operator-
Division Operator/
Totals the adjacent cells=Sum(A2:A15)
RateInterest charged by lender for use of month, /month
NperTime it will take to repay the loan; number of payments
PVAmount of a loan
Payment Function=PMT(rate,nper,pv)
Mixed Cell Reference$B3
Ready to learn about Excel 1.04 and 1.05 Using Basic Functions?