Excel Module 3 Flashcards for Students

Front

*Front:* Cell Reference

Back

a cell's location in a worksheet

Front

*Front:* SUM Function

Back

latex="= \text{SUM}(A1:A10)"> adds values in a range

Front

*Front:* Relative Reference

Back

when a formula is copied to another cell

Front

*Front:* Absolute Reference

Back

Front

*Front:* AVERAGE Function

Back

latex="= \text{AVERAGE}(B1:B10)"> calculates mean of values

Front

*Front:* IF Function

Back

latex="= \text{IF}(A1 > 10, "Yes", "No")"> checks condition

Front

*Front:* VLOOKUP Function

Back

for a value in the first column of a table

Front

*Front:* Data Validation

Back

data entry to specific criteria

Front

*Front:* Pivot Table

Back

data for analysis

Front

*Front:* Line Chart

Back

data trends over time