Excel Quiz

Formula Start Symbol

Equals sign (=)

Euler's Number in Excel

Use exp(argument)

Exponentiation Operator

^

Highest Precedence Operation

Parentheses (innermost pair first)

Third Precedence Operations

Multiplication and division

Cell Reference

A cell to which another cell refers

Relative Cell Reference Behavior

The cell address changes relative to its new location.

Absolute Cell Reference Behavior

The cell reference stays the same because rows and columns are anchored.

Mixed Cell Referencing

Anchoring either the row or the column while leaving the other free to change.

PC Shortcut for Reference Types

F4

Referencing Another Worksheet Syntax

='WorksheetName'!A1

Excel Error: #####

Numeric value exceeds cell size.

Excel Error: #DIV/0!

Divided by 0 or blank cell.

Excel Error: #NUM!

Formula contains invalid numeric values.

Excel Error: #REF!

Formula contains invalid cell reference.

Excel Error: #VALUE!

Wrong argument type in formula.

Calculate Mean Function

=AVERAGE(cell range)

Calculate Median Function

=MEDIAN(cell range)

Calculate Mode Function

=MODE(cell range)

Calculate Standard Deviation Function

=STDEV.S(cell range) or =STDEV(cell range)

Printing Just the Plot

Click on the plot before opening the print menu.

PDF Export for Assignments

Use Print to PDF function (not Save as PDF).

Fitting Worksheet to One Page

Select 'Fit Sheet on One Page' in the Print Menu.

Required Plot Type for Trendlines

X-Y Scatter plot

Good Graphing Practices Components

Descriptive title, axis labels with units, and even increments.

Formatting Multiple Data Sets

Use different data markers and include a legend.

R² Value Meaning

Indicates how closely the function fits the data set.

Theoretical Data Graphing

Continuous data connected with a smooth line.

Experimental Data Graphing

Discrete data where points are not connected.

Preventing Equation Evaluation

Start with a single quote (') before pasting.