Commonly used functions
The _________ function returns the highest value of the range specified in the argument.
MAX function
_______ are usually divided into categories, including financial, statistical, mathematical, date and time, and logical.
Functions
An area you enter the formula into.
Formula Bar
What is the operator to the equal to logical function?
=
What does a cell consist of?
column /row
Th______ functions finds the average value of arguments
average function
Are values the functions needs for calculation, enclosed in parenthesis.
arguments
In what tab in your Microsoft Excel Ribbon can you find your functions?
Formulas tab
What is the operator to the greater than logical function?
>
what row is cell b2 located in?
row 2
If function
Functions that test for True or Fals.
Logical Functions
What tab did we use to enter the heart chart?
Insert
What is the meaning of this operator? <
less than
Name the cells that belong in range B2:C5
B2,B3,B4,B5,C2,C3,C4,C5
The function finds the sum of a list of numbers or teh content of a range of cells.
Sum Function
The amount of the loan is called?
Principal
What tab can you merge and center in?
Home
What is an example of a logical function?
if, and, or, iferror
What type of chart did we use for the heart?
scatter chart
The function returns the current date.
The length of time it takes to repay a loan.
term
In your microsoft excel ribbon in the Home tab what is the name of group you can find to use the dollar bill sign?
Number group
A commonly used logical function used in Microsoft Excel is the .....
IF function
What function did we use for the heart chart?
SQRT