How can we help?
You can also find more resources in our
Select a category
Something is confusing
Something is broken
I have a suggestion
What is your email?
What is 1 + 3?
CA I 4.01 Spreadsheet operations
used to arrange data in alphabetical or chronological order.
indicates the first sort range of data.
indicates the additional range of a sort.
allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges
is used to fill a column or row with consecutive data
used to provide a hard copy
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
the program in which the object is stored.
the program in which the object is created.
when an object maintains its connection to the source and updates when changes are made.
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
used in higher-level operations, such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.
used to calculate a period of time
returns the current date
calculates difference in days between two dates
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.
used for two column vectors
used when there are more than two columns in the array (lookup table).
used to assist in organizing spreadsheet information
limits data entry to specific choices programmed into the function
allows additional entries other than those provided in the drop-down menu
used to return the number of cells in a range
number of cells in a range that contain numbers
number cells in a range that contain value or letter
cells that meet a condition set forth in the formula