VOCAB 03: Excel Function Basics Vocabulary

What is the term for the following definition? Typing = in a cell displays a list of common functions in the Name Box.

• Functions List

• Formula Bar

• Cell Reference

• AutoSum

What is the term for the following definition? Buttons that work like Esc and Enter to cancel or confirm formulas.

• Cancel/Enter

• Shift/Tab

• Alt/Space

• Ctrl/Del

What is the term for the following definition? Opens a dialog to help enter function arguments (numbers, cells, or ranges).

• Function Arguments Dialog Box

• Formula Bar

• Name Box

• AutoSum Tool

What is the term for the following definition? Shows the formula in the selected cell; you can also type or edit formulas here.

• Formula Bar

• Status Bar

• Name Box

• Task Pane

What is the term for the following definition? A formula currently being typed, showing the formula itself instead of the result. Highlighted cell ranges indicate included arguments.

• Active Formula

• Formula Bar

• Cell Reference

• Formula Result

Which Excel function guesses and inserts a SUM function for selected cells; dropdown offers more functions?

• COUNT

• AutoSum

• MAX

• COUNTBLANK

Which Excel function returns the mean of a range?

• COUNT

• AVERAGE

• MAX

• COUNTBLANK

Which Excel function counts numeric values in a range (ignores text/blanks)?

• COUNT

• AVERAGE

• MAX

• COUNTBLANK

Which Excel functions return the highest or lowest value in a range?

• COUNT

• AVERAGE

• MAX and MIN

• COUNTBLANK

Which Excel feature allows you to search and insert any function; opens from the Formula Bar button or 'More Functions.'?

• COUNT

• Insert Function Dialog Box

• MAX

• COUNTBLANK