Microsoft chapter 6

What is the difference between a relative cell reference and an absolute cell reference?

A relative cell reference automatically changes when copied, and an absolute cell reference is a cell reference that does not change when copied. An absolute cell reference contains a dollar sign in front of both the column letter and row number, such as $A$1.

List two other "What If?" questions that can be answered using the Charity Fundraiser workbook.

Answers will vary. Two other "What If?" questions that can be answered using the Charity Fundraiser workbook are, "What if ticket prices are raised? How will that impact the profit?" and "What if the auditorium rental was lowered? How will that impact the profit?

What formatting does a newly inserted column contain?

Cells in a newly inserted column have the same formatting as the cells in the column to the left.

What formatting does a newly inserted row contain?

Cells in a newly inserted row have the same formatting as the cells in the row above.

A #### error value indicates the formula is trying to divide by zero.

False. A #### error value indicates the result of the formula is too wide to fit in the column or the result is a negative time or date value

A modified cell style is accessible to all new workbooks.

False. A modified cell style is only accessible in the active workbook.

An absolute cell reference changes when copied.

False. An absolute cell reference does not change when copied.

There is no difference between formatting and rounding

False. Rounding is different than formatting in that the ROUND function changes the value stored in a cell and formatting only changes the way data is displayed.

When a formula produces a result and a green triangle in the cell, this indicates a correct formula.

False. When a formula produces a result and a green triangle in the cell, this indicates a possible formula error.

Explain why it would be a good idea to change sheet names from Sheet1, Sheet2, and so forth in a workbook with multiple data sheets.

It would be a good idea to change the sheet names to a name that is descriptive of the sheet contents so that the user knows what data is stored on each sheet.

If a row is inserted directly above row 20, what must be done in order to include the new cell in the sum?

Nothing must be done in order to include the new cell in the sum.

If row 20 is deleted, what must be done to the formula so that the deleted cell is no longer in the range?

Nothing must be done to the formula because the deleted cell is no longer in the range.

Why is it important to check the range placed in the SUM function when using Formulas > AutoSum?

The range placed in the SUM function when using the AutoSum button should be double-checked since Excel guesses the range.

If a row is inserted directly above row 24, what must be done to include the new cell in the sum?

The sum formula must be edited to include the new cell. The formula must be changed from =SUM(C3:C22) to =SUM(C3:C24).

List two advantages of using the Insert Function dialog box to insert the name of a function in a formula instead of typing the formula.

There is a less chance of typing errors and arguments are specified.

Linked data will automatically update if the source cell is changed.

True

The SUM function ignores cells that contain text when their cell references are included as arguments.

True

When rows are inserted, Excel automatically changes the cell references in any affected formulas.

True

What will be displayed by the following formulas if cell D4 stores a value of 30 and cell E7 stores a value of -12?

a) =IF(D4<=E7, 10, 20) 20 b) =IF(E7*D4<-5, E7, D4) -12 c) =IF(D4-42=E7, D4*2, E7*3) 60

Using functions, write a formula to calculate: round

a) the sum of the values in cells C5, C6, C7, C8, and C9 rounded to 2 decimal places. =ROUND(SUM(C5:C9), 2) b) the sum of the values in cells B5, C5, D5, and E5 rounded to the nearest integer. =ROUND(SUM(B5:E5), 0) c) the average of the values in cells A1, A2, A3, B1, B2, and B3 rounded to 1 decimal place. =ROUND(AVERAGE(A1:B3), 1)

When the formula =SUM(C3:C22) is entered in cell C24

it is used to sum the values in cells C3 through C22.

Using functions, write a formula to calculate:

the sum of the values stored in cells B4, B5, B6, and B7. =SUM(B4:B7) the average of the values stored in the column of cells D7 through D35. =AVERAGE(D7:D35) the maximum value stored in the range of cells D4 through Y5. =MAX(D4:Y5) the minimum value stored in the range of cells C1 through C9. =MIN(C1:C9)