Graphical Integration, Excel, Logic Flow, and Engineering Scale Review

Vocabulary flashcards created from the lecture transcript covering graphical integration and differentiation, Excel navigation and formulas, logic flowcharts, and engineering scale rules.

Integral (Graphical)

Represents the area under the curve.

Area Below the x-axis

Has a negative sign in graphical integration.

Derivative (Graphical)

Represents the slope.

Integral of Acceleration

Represents the change in velocity.

Integral of Velocity

Represents the change in position.

Derivative of Position

Represents velocity.

Derivative of Velocity

Represents acceleration.

Excel Rows

Labeled with numbers.

Excel Columns

Labeled with letters.

Excel Cell Naming

Named by its column letter and row number.

Workbook

The entire Excel file.

Worksheet

A tab within an Excel file.

Relative Cell Reference

A reference that changes when copied based on the new location.

Absolute Cell Reference

A reference that stays fixed when copied.

Absolute Reference Symbol

The dollar sign ($).

Excel Formula Starting Symbol

An equal sign (=) that every Excel formula must begin with.

Blank Cell in Excel Formula

Interpreted by Excel as zero.

IF Function

An Excel function whose purpose is to make a logical decision.

IFS Function

An Excel function whose purpose is to evaluate multiple logical conditions.

AND Function

An Excel function that requires all conditions to be true.

OR Function

An Excel function that requires at least one condition to be true.

Arrows (in Logic Flowchart)

Represent the direction of flow.

Loop (in Logic Flowchart)

A path back to an earlier step.

Engineering Scale Format

Formatted as $1\text{ inch} = \text{\_\_\_ units}$.

Engineering Scale Non-Zero Numbers

An engineering scale can have one non-zero number, which must be in the range between 1 and 6.

Engineering Scale Conversion

The process where you only move the decimal.