Java Games: Flashcards, matching, concentration, and word search.

CBA EXCEL Function Formulas

AB
SQRTFinds the square root of a cell
FVUsed to determine how much an investment will be worth in the future
COUNTDetermines how many cells have values
IFUsed to determine a choice between two.
PVDetermine the amount of value for equal payments at a fixed rate
STDEVThe measure of the average amount by which individual items deviate from the mean
AVERAGEFind the mean of a range of numbers
NOW()Displays the current date
DATEDisplays the date in a variety of formats
MAXThe largest value
ROUNDDisplays number of decimal places desired
REPTDisplays text a specified number of times
PMTUsed to determine how much your monthly payment will be for a loan at a fixed rate and time.
MINThe smallest value
VARAnother statistical function to describe the spread of data from the mean


LISA ACADEMY
Little Rock, AR

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities