FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel 2: Working With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) preserve the relationship to the formula location
B) never change the formula
C) preserve the exact cell address in a formula
D) memorize the formula

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

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.

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

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

Identify the letter of the choice that best matches the phrase or definition.

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.

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?

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

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

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?

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

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 is used to count the number of cells in a range that contain which type of data?

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

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

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. _________________________

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