Data

Copy and paste the text below. It is read-only. Select All

Sort used to arrange data in alphabetical or chronological order. primary sort indicates the first sort range of data. secondary sort indicates the additional range of a sort. Freeze panes allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges Fill Series is used to fill a column or row with consecutive data Print used to provide a hard copy Print preview used to view how data is represented on paper Print a selection used to print a portion of a spreadsheet Linking and embedding is used to integrate spreadsheet data with other software applications Target the program in which the object is stored. Source the program in which the object is created. Link when an object maintains its connection to the source and updates when changes are made. 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 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. IF statements conditional operators Date functions used to calculate a period of time NOW returns the current date Days360 calculates difference in days between two dates 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. Lookup used for two column vectors VLookUp used when there are more than two columns in the array (lookup table). List used to assist in organizing spreadsheet information Validated limits data entry to specific choices programmed into the function Non-validated allows additional entries other than those provided in the drop-down menu Count used to return the number of cells in a range Count number of cells in a range that contain numbers CountA number cells in a range that contain value or letter CountIf cells that meet a condition set forth in the formula