CIS Quiz 1

Workbook

One or more worksheets saved together under the same filename

Sheet 1

The default name for the first worksheet

Sheet 2

The default name for the second worksheet

Cell address

Identified by its column and row

Column headers

Labels like Title, Platform, Unit Cost that appear above data rows (also called column names/labels)

Formula

What you enter into a cell to have Excel perform a calculation

= (equals sign)

All Excel formulas begin with this symbol

Fill Handle

Excel command/tool used to copy a formula to adjacent cells without typing it by hand (also: Copy/Paste)

Relative cell reference

A cell reference that automatically changes/transforms when a formula is copied to other cells

Range

A sequential collection of cells, e.g., G4:G9

SUM function

Function used to add up values in a range without naming each cell explicitly, e.g., =SUM(G4:G9)

AVERAGE function

Function used to calculate the average of a range, e.g., =AVERAGE(F4:F9)

MAX function

A commonly used function that returns the largest value in a range

MIN function

A commonly used function that returns the smallest value in a range

IF function

Function used to return one value if a condition is true and another if false

IF function syntax

=IF(logical test, value if true, value if false)

Cell reference

The name of a cell (like A1) used inside a formula

Absolute cell reference

A cell reference that is NOT modified by Excel when the formula is copied

$ (dollar sign)

Symbol used to "lock" a column or row reference so it doesn't change when copied

Locking column only

Prefix the column letter with $ (e.g., $A1)

Locking row only

Prefix the row number with $ (e.g., A$1)

Locking both column and row

Prefix both column and row with $ (e.g., $A$1) — makes reference fully absolute

Mixed reference

A reference where only the row OR only the column is locked with $ (e.g., A$1 or $A1)

AND function

Used inside an IF's logical test to require multiple conditions be true, e.g., =IF(AND(condition1, condition2), value if true, value if false)

OR function

Used inside an IF's logical test to require at least one of multiple conditions be true

Cross-sheet reference syntax

SheetName! placed before a cell reference to point to a cell on a different worksheet (e.g., Shipping!$A$1)

! (exclamation point)

Symbol used to separate a worksheet name from a cell reference when referencing another sheet

Relative reference — column copy rule

When a formula is copied one cell to the right, the column of the reference advances by one

Relative reference — row copy rule

When a formula is copied one cell down, the row of the reference is incremented by one