CSC Notes

Sum Function

Calculates all numbers in range of cells

Average Value

Calculates the average value of the sum

Max Value

Calculates the maximum value of the sum

Min Value

Calculates the minimum value of the sum

Flash Fill

A feature that looks for a pattern in data entry and automatically fills in values based on that pattern.

Formula

A mathematical expression that calculates a value based on given inputs and operations.

Circular Reference

In a spreadsheet, an error that occurs when one of the defining values in a cell is itself is called a circular reference.

Direct Circular Reference

An error occurs when a formula refers to the same cell in which it is entered. (direct)

Indirect Circular Reference

A formula in a cell refers to another cell (indirectly) that include a formula from original cell.

Source Range

The specific group of cells that data is pulled from to be used in another function…

Destination Range

When a range is used as a destination in a data exchanged, it sometimes is called…

Relative References

Cells that automatically change to reflect the new location when the formulas are copied or moved are called…

Debugging

Process of finding and correcting errors

Assumptions

Cell values that you change to determine new values for formulas

Volatile Function

Where the number that is the function is not constant but changes each time worksheet is open.

Cell Reference

A formula in a cell address (reference) that refers to a specific cell and does not change when you copy the formula.

Relative Cell Reference

A cell address in a formula that automatically changes to reflect the new location when the formula is copied or moved.

Mixed Cell Reference

When a cell reference combines both absolute and relative cell addressing, it is called a…

$B$4

Absolute cell reference

B4

Relative cell reference

B$4 or $B4

Mixed reference

If-Function

Assign a value to a cell based on logical test

=IF(B4>=$B$21,$B$20,0)

Logical_Test, Value if true, Value if false

Goal Seek

Problem-solving method in which you specify a solution and then seek the input value that produces the answer you want.

Pixel

is short for picture element, is an individual point of color on a display screen or printout. The size of the dot is based on your screen’s resolution.

Character

is defined as a letter, number, symbol, or punctuation mark.

Three Forces of Management

Social Forces, Economic Forces, Political Forces

Types of Management

1. Classical Management: Belief of workers having only physical and economic needs (centralized, decision making, and profit maximization)

2. Behavioral Management: Focused on home aspects of work and referred as human relations. Improving productivity (behavioral aspects, motivation conflict, expectations, and group dynamics)

3. Modern Management: Use of systematic mathematical techniques, analyze, and understood inter-relationships ( Quantitive Approach, System approach, and contingency

Elton Mayo

Human Relations Theory: Behavioral theories of leadership focus on what leaders do rather than what traits they are born with. These theories suggest that anyone can become a good leader by learning the right behaviors. Unlike theories that say leaders are born with certain qualities, behavioral theories believe leadership can be developed through experience and learning.