Relative referencing is the most common type of referencing a cell in which cell is called by row and column level (example A1 means column A and Row 1). When a formula with relative referencing is copied, reference of cell will have relative change. For example, if cell C1 has formula =SUM(A1,B1) and the formula is copied to Cell C2, it will be changed to =SUM(A2,B2).
Absolute Referencing will have absolute reference to the cell. If you place $ sign in front of cell reference, cell reference will not be changed during copy. For example, if cell C1 has formula =SUM($A$1,$B$1) and the formula is copied to Cell C2, it will remain =SUM($A$1,$B$1).
Mixed referencing is the mix of relative and absolute referencing. Example is =SUM(A$1,B$1) or =SUM($A1,$B1) or any other combination of relative and absolute referencing.
20. Share Point Designer
Share Point is Web applications that focus on the sharing and collaboration of content and documents. In its most basic of definitions, SharePoint provides the infrastructure for creating and
maintaining Web sites that can be used for a variety of Internet-based operations besides sharing
Office or non-Office content and collaboration. You can later customize these Web sites that
SharePoint creates to suit your business needs, format, or branding.
