How can we help?

You can also find more resources in our Help Center.

28 terms

CA I 4.01 Spreadsheet operations

STUDY
PLAY
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