Exam 7: Excel 2: Working With Formulas and Functions

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. Write a formula using an absolute cell reference that would return a value of 1550 in cell C6.

The COUNTA function returns the number of cells in a range that contain numeric data.​

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. In your budget, which function can be used to eliminate the two decimal places in all cells with values that include decimal places?

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

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

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________

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

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

The COUNTA function is used to count the number of cells in a range that contain which type of data?

Discuss the difference between a relative cell reference and an absolute cell reference. Include the following information in your answer: how the two types of cell addresses are designated, what happens when each type of cell reference is copied, and when it is appropriate to use each type of reference.

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

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

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

Which of the following is a complex formula?

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________