1.       Spreadsheet-Software that the paper spreadsheet environment but makes it fast and easy. A spreadsheet appears on screen as a matrix of rows and columns. Spreadsheet can have thousands of cells and can be scrolled horizontally or vertically to be viewed.

2.       Excel-Microsoft’s version of spreadsheet

3.       Worksheet-One page of a Workbook. It is the page that you use to input data to organize into information.

4.       Workbook-A file that contains a series of  Worksheets

5.       File-a document-in this case a spreadsheet document

6.       Filename-The name given to your spreadsheet document when you save it

7.       Active cell-The selected cell

8.       Cell-A rectangle that is contained within a worksheet. Text and numbers and formulas can be inputted in individual cells.

9.       Column-Spreadsheet organizes data in columns and rows. Columns are identified by letters of the alphabet and run vertically—that is up and down

10.   Row- Spreadsheet organizes data in columns and rows. Rows are identified by numbers and run horizontally-that is left to right or right to left

11.   Cell Address-The intersection of a column and a row

12.   Operands-Values or references to cells containing a value

13.   Operators-Indicates type of calculation that will take place

14.   Syntax – Structure or order of the elements (operands and operators) in a formula

15.   Formula-An equation that performs various operations within a work sheet

16.   Range -A rectangle of cells that is selected. For example cell A1:A5

17.   Arguments-Terms between the parentheses OR commas. Terms in bold are required; terms not bold are optional

18.   Formula Palette-Assists you in building the formula

19.   Functions-Predefined formulas; part of spreadsheet features. There are 356 functions in Excel 2007. The “everyday” functions are Math, Date and Time, and Text Functions.

20.   Fx or Paste Function-Command to help you enter functions. It’s the function wizard.

21.   Function SUM-A predefined spreadsheet function that calculates the sum of the numeric value of all cells specified within a range.

22.   Function AVERAGE-A predefined spreadsheet function that returns the average or arithmetic mean of its arguments

23.   Function COUNT- Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that's in a range or array of numbers. Syntax is =COUNT(A1:M100)

24.   Function MIN - Returns the smallest number in a set of values.

25.   Function MAX - Returns the largest value in a set of values.

26.    Function NOW - Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date.

Syntax NOW( )

27.   Function TODAY - Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was  General before the function was entered, the result is formatted as a date. Syntax TODAY( )

28.   Function DATE - Returns the sequential serial number that represents a particular date. If the cell format was General before the function was entered, the result is formatted as a date. Syntax DATE(year,month,day)

29.   Function LOWER - Converts all uppercase letters in a text string to lowercase. Syntax LOWER(text)

30.   Function UPPER - Converts text to uppercase. Syntax UPPER(text)

31.   Function PROPER Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. Syntax PROPER(text)

32.   Function CHAR - Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Syntax CHAR(number)

33.   Operation sign for addition           +

34.   Operation sign for subtraction     –

35.   Operation sign for multiplication   *

36.   Operation sign for division            /

37.   Operation sign for the powers     ^

o        For example:

§         10^0 = 1                      

§         10^1 = 10

§         10^2 = 100

§         10^3 = 1000

§         10^4 = 10,000   (10 * 10 * 10  * 10)

o        And for example:

§         10^-1 = 1/10

§         10^-2 = 1/100

§         10^-3 = 1/1000

§         10^-4 – 1/10,000