C268 Spreadsheets Test 1 Questions with Correct Answers

C268 Spreadsheets Test 1 Questions with
Correct Answers
Relative Cell Reference

Cell reference that automatically updates when a formula is pasted into a new cell

Absolute Cell Refernce

Cell reference that remains constant when a formula is pasted into a new cell

$

Used to make a cell absolute. Goes in front of the part you want to remain constant.

SUM function

=SUM() when you want to add a group of numbers together

COUNT function

=COUNT() Counts the number of cells in a range of cells that contain numbers

COUNTA function

=COUNTA() Counts the number of cells in a range that are not blank

AVERAGE function

=AVERAGE() Calculates the simple average of a set of numbers

MAX function

=MAX() Returns the largest value in a set of numbers

MIN function

=MIN() Returns the smallest value in a set of numbers

, Circular Reference

when one cell either directly or indirectly references itself in completing a calculation

Direct Circular Reference

When a cell contains a reference to itself

Indirect Circular Reference

When multiple cells reference others cells but will eventually lead back to a main cell

Population

The complete set of entities for an item of interest

Sample

Part of a population

Standard deviation

A measure of how diverse the elements in our data sets are.

Standard deviation of a sample

=STDEV.S(number 1,[number 2],...)

Standard deviation of a population

==STDEV.P(number 1,[number 2],...)

Confidence Intervals

The range of values that we believe that the "true" value for the population falls within

CONFIDENECE.NORM Function

=CONFIDENCE.NORM(alpha,standard_dev,size)