CA I 4.01 Spreadsheet operations

28 terms by jenningba 

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set