Microsoft Excel

• The IF function performs a logical test and returns one value if the test is true and another value if the test is false.
• The AVERAGE function calculates the average of a set of values.
• The SUM function adds numbers together.
• The MIN function returns the smallest value in a range of cells.
• The SUM function adds up all the numbers in a range of cells.
• The formula bar is where the formulas are displayed.
• The MIN function finds the smallest number in a range or array.
• The MAX function finds the largest number in a range or array.
• The MAX function finds the largest number in a range.
• The SUM function adds up all the numbers in a range or array.
• The MAX function returns the largest value in a range of cells.
• The COUNT function counts the number of cells that contain numeric values.
• Formula is used to calculate values
• Text are any letter, symbol, number and spaces that you enter into a cell
• Values are any number that you enter into a cell that you may use in a formula later
• The number symbol (###) appears when the number is too long to fit in the cell boundary
• #DIV/0! means you have attempted to divide by zero.
• #VALUE! means you've tried to calculate something that is not a value
• #REF! means that you address a cell that is invalid
• #NAME! means the used cell name cannot be identified
• #N/A! means the reference or lookup value isn’t found within the table
• #NUM! means you have attempted an invalid numeric data for the operation
• #NULL! means that space was used for a formula that reference multiple ranges
• #SPILL! means the spill range has exceeded its limit
• The Data tab contains all the tools needed to work with lists of information.
• The formula for remarks is =IF(M6>75, "PASSED", "FAILED")
• A spreadsheet is a tool used to organize information