VOCAB 05a: Advanced Functions and Charts FLASHCARDS

Front

Opens a box where you can search for and add functions. Type what you want to do, and Excel suggests the right one.

Back

Insert Function

Front

Adds numbers for you automatically using the SUM function. Always double-check the range before pressing Enter.

Back

AutoSum

Front

Used to calculate money-related data like interest, payments, or loans.

Back

Financial Functions

Front

Used to manipulate text data, such as combining text, changing case, or extracting parts of a string.

Back

Text Functions

Front

Helps in working with dates and times, such as calculating the difference between dates or extracting specific parts of a date.

Back

Date & Time Functions

Front

Includes mathematical and trigonometric calculations like SUM, AVERAGE, SIN, and COS.

Back

Math & Trig Functions

Front

Displays all formulas in the worksheet instead of their results, making it easier to audit and debug.

Back

Show Formulas

Front

Helps identify and fix errors in formulas, ensuring the worksheet functions correctly.

Back

Error Checking

Front

Allows you to name ranges or cells for easier reference in formulas.

Back

Defined Names

Front

Shows arrows that indicate which cells affect the value of the selected cell.

Back

Trace Precedents