1.
Advanced Functions: used in higher-level operations, such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.
2.
Count: used to return the number of cells in a range
3.
Count: number of cells in a range that contain numbers
4.
CountA: number cells in a range that contain value or letter
5.
CountIf: cells that meet a condition set forth in the formula
6.
Date functions: used to calculate a period of time
7.
Days360: calculates difference in days between two dates
8.
Embedded: a spreadsheet is converted into a graphic image when placed in a target document and does not change to reflect edits made at the source
9.
Fill Series: is used to fill a column or row with consecutive data
10.
Freeze panes: allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges
11.
IF statements: conditional operators
12.
Link: when an object maintains its connection to the source and updates when changes are made.
13.
Linking and embedding: is used to integrate spreadsheet data with other software applications
14.
List: used to assist in organizing spreadsheet information
15.
Lookup: used for two column vectors
16.
LookUp function: used to compare a cell value to an array of cells and return a value that matches the location of the value in the array.
17.
Non-validated: allows additional entries other than those provided in the drop-down menu
18.
NOW: returns the current date
19.
primary sort: indicates the first sort range of data.
20.
Print: used to provide a hard copy
21.
Print a selection: used to print a portion of a spreadsheet
22.
Print preview: used to view how data is represented on paper
23.
secondary sort: indicates the additional range of a sort.
24.
Sort: used to arrange data in alphabetical or chronological order.
25.
Source: the program in which the object is created.
26.
Target: the program in which the object is stored.
27.
Validated: limits data entry to specific choices programmed into the function
28.
VLookUp: used when there are more than two columns in the array (lookup table).