Basic
Types of Functions
Creating Formulas
Insert Function Button
Misc.
100
True or False.....To create a minus sign in a formula, use the hyphen key.
What is True
100

The function that adds the range and divides it by the number of observations.

What is the Average function?

100
All Excel formulas begin with ____.
What is equal sign
100

A wizard box provided by Excel to help us find out the type of function.

What is the Insert Function button?

100
____ formulas perform calculations that you could perform using a scientific calculator.
What is mathematical?
200

True or False.....You can change the order of operations by using hyphens.

What is False

200

What function will return the largest value in a given list of arguments?

What is the MAX function?

200
A(n) ____ cell reference does not change when the formula is copied or moved.
What is absolute?
200

True or False. The Insert Function dialog box allows you to search for a function.

What is True?

200

Are predefined worksheet formulas that enable you to perform complex calculations easily?

What are functions?

300
True or False...The COUNT and SUM functions are not interchangeable.
What is True
300

What function counts the number of cells that contain numbers, and counts numbers within the list of arguments?

What is the COUNT function?

300
Two non-adjacent cells are distinguished in a function using a ____. a.comma c.semi-colon b.colon d.hyphen
What is A?
300

Can be numbers, text, logical values such as TRUE or FALSE, arrays, error values such as #N/A, or cell references.

What is an argument?

300

Dragging the fill handle on a cell copies the cell’s contents or continues a series of data (such as Quarter 1, Quarter 2, etc.) into adjacent cells.

What is Auto Fill?

400
A(n) ____________________ is a symbol that indicates the mathematical operation to perform.
What is operator
400

Using the ____________________ feature, Excel scans the worksheet and identifies the most logical column or row of adjacent cells containing numbers to add.

What is Autosum?

400
Tyler tells Eleni that ____ is an absolute cell reference. a. A1 c. A$1 b. $A1 d. $A$1
What is D
400

The Excel Formula _________ feature makes it easier to enter function names by typing because it suggests functions depending on the first letters you type.

What is Autocomplete?

400
The ____ is a value, cell reference, range, or text used in a function.
What is argument?
500
Formulas containing more than one operator are called ____________________ formulas.
What is complex
500

What function will find the lowest number in a range?

What is the MIN function?

500
The ____________________ reference enables you to access data from multiple worksheets.
What is 3D
500

A set of one or more contiguous cells such as a cell, a row, a column, or a block of cells.

What is a range?

500
Tyler tells Eleni that the * (asterisk) character is used to represent ____.
What is multiplication?
M
e
n
u