Excel Module 2

An Excel user should use a relative cell reference when it is important to ____.

The formula =A4+A8*($B$12) is an example of a(n) ____________________ formula.

An asbolute cell reference uses a __ in front of column or row references

In Excel, MAX and AVERAGE are examples of ____.

Which of the following is a complex formula?

In this formula,  =(A6*A8)+$D$1, cell references A6 and A8 are relative cell references

With Auto Fill, dragging the fill handle copies cell's contents into adjacent cells.

When using the Insert Function button it is necessary to type the equal sign.

When cells are copied using the copy function, what happens to data in the copied cells?

Formula AutoComplete feature suggests functions depending on the letters typed by the user

Which type of cell reference preserves the exact cell address in a formula?

The __ function specifies the number of decimal places to be used for values and formulas.

All functions begin with the formula prefix ____.

Cut command removes data from original location & the Copy command leaves it.

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10

When cells or rows are inserted/deleted, how are cell references affected?

A cell reference that does not change when it is copied is called a relative cell reference

The __ button on the formula bar is one way to easily insert a function into a worksheet cell.

According to arithmetic operators, operations within parentheses are performed last.

An Excel complex formula uses more than one arithmetic operator.

=D8+E8*0.5 is a complex formula.

When copying or moving formulas, the default type of cell reference is __

A method to enter a function requires users to know name & initial characters of a function?

Mixed reference is when the column&row reference in the formula is absolute, not both

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

The = sign is also called the __and is automatically inserted when a function is selected.

In the formula =ROUND(D4:F4,0), what does the zero indicate?

The $ symbol placed before a row and column address indicates a ____ cell reference.

Functions can be entered for formulas using all of the following methods except ____.

In the formula =D1+C1/F3, which calculation will be performed first?

Absolute cell reference changes when the formula is copied to a new location.

Predefined formulas are called functions & are accessed using the Insert Function button.