Chapter 6 Functions and Data Organization

Name: Date: Period:

Chapter 6 Functions and Data Organization

Chapter 6 Review Questions

1. Describe how to insert a column between column A and column B.

Answers

2. a) What formatting does a newly inserted row contain?

Answers

b) What formatting does a newly inserted column contain?

Answers

3. List the step required to delete row 8.

Answers

4. The formula =SUM (C3:C22) is entered in cell C24 and used to sum the values in cells C3 through C22.

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

Answers

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

Answers

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

Answers

5. a) What is a function?

Answers

b) What does a function require to perform a calculation?

Answers

6. Using functions, write a formula to calculate:

a) The sum of the values stored in cells B4, B5, B6, and B7.

Answers

b) The sum of the values stored in cells B4, C4, D4, and E4.

Answers

c) The average of the values stored in the column of cells D7 through D35.

Answers

d) The average of the values stored in the row of cells F3 through J3.

Answers

e) The maximum value stored in the range of cells D4 through Y5.

Answers

f) The minimum value stored in the range of cells C1 through C9.

Answers

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

Answers

8. List the steps required to create a formula in cell G5 that multiplies the value in cell F5 with the value in cell B1 so that when the formula is copied, the cell reference to B1 remains constant.

1. Answers

2. Answers

3. Answers

4. Answers

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

Answers

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

Answers

11. Describe two common error values.

Answers

12. a) Describe two common formula errors.

Answers

b) List the steps required to remove the green triangle from a cell that displays a result and the formula does not contain an error.

1. Answers

2. Answers

3. Answers

13. Using functions, write a formula to calculate:

a) The sum of the values in cells C5, C6, C7, C8, and C9 rounded to 2 decimal places.

Answers

b) The sum of the values in cells B5, C5, D5, and E5 rounded to the nearest integer.

= Answers

c) The average of the values in cells A1, A2, A3, B1, B2, and B3 rounded to 1 decimal place.

Answers

14. a) List the steps required to sort the data in a workbook in descending order based on the data in column C.

1. Answers

2. Answers

3. Answers

4. Answers

b) What is the key sort column?

Answers

15. 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)

Answers

b) =IF (E7*D4<-5, E7, D4)

Answers

c) =IF (D4–42=E7, D4*2, E7*3)

Answers

16. Using functions, write a formula to:

a) Display 50 if the value stored in D20 equals the value in C70, or 25 if they are not equal.

Answers

b) Display the value in B40 if the sum of the range of cells C20 to C30 exceeds 1000, otherwise display a 0.

Answers

c) Display the value of R20*10 if R20 is less than 30, otherwise display the value in R20.

Answers

17. a) List the steps required to print a worksheet across the widest part of the paper.

Answers

b) What can be decreased in order to fit more rows and columns on a printout?

Answers

c) What can be used to control how a worksheet is divided into pages?

Answers

d) List the steps required to print only the values displayed in the cell range A3:D17.

1. Answers

2. Answers

3. Answers

e) List the steps required to print the entire worksheet after a print area was previously set.

1. Answers

2. Answers

18. Write formulas using the IF function for each of the following:

a) if B3 is less than or equal to C12 display Low; if greater than, display High.

Answers

b) if A5 is equal to Z47 display Jonathan; if not equal to, display Judith.

Answers

c) if cell C6 is empty, display the contents of cell D3, otherwise display New Student.

Answers

19. Briefly explain what an amortization table is and the terminology associated with it.

Answers

20. a) How much interest is paid in the first month of a loan of $5,000 borrowed for 5 years at 12% per year interest?

Answers

b) Write the PMT function used to calculate the monthly payments on the above loan.

Answers

21. a) How is a sheet made active?

Answers

b) List the steps required to rename Sheet1 to Jan Sales.

1. Answers

2. Answers

3. Answers

c) Explain how to add a new sheet to a workbook.

Answers

d) How is the sheet order changed?

Answers

22. List the steps required to print all the sheets in a workbook at one time.

1. Answers

2. Answers

23. List the steps required to print Sheet1 in landscape orientation and Sheet2 in portrait orientation.

1. Answers

2. Answers

3. Answers

4. Answers

5. Answers

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

Answers

25. List the steps required to copy or move data between sheets in a workbook.

1. Answer

2. Answers

3. Answers

4. Answers

5. Answers

26. List the steps required to reference cell B5 on Sheet1 and multiply its value by 3.6 in a formula stored in cell C4 on Sheet2.

1. Answers

2. Answers

3. Answers

4. Answers

5. Answers

6. Answers

7. Answers

27. a) What is the difference between pasting data and linking data?

Answers

b) List the steps required to link cell A25 on Sheet2 to cell A20 on Sheet1.

1. Answers

2. Answers

3. Answers

4. Answers

5. Answers

6. Answers

28. a) What does a “What If?” question ask?

Answers

b) What is a spreadsheet model?

Answers

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

Answers

30. Explain how scenarios can be used to analyze data within the same worksheet.

Answers

31. Determine if each of the following are true or false. If false, explain why.

a) A new cell style can be added to the Cell Styles gallery.

Answers

b) A modified cell style is accessible to all new workbooks.

Answers

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

Answers

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

Answers

e) An absolute cell reference changes when copied.

Answers

f) The range placed in the SUM function when AutoSum is clicked is always correct.

Answers

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

Answers

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

Answers

i) There is no difference between formatting and rounding.

Answers

j) The key sort column can be any column with data on the worksheet.

Answers

k) The arguments of an IF function can only contain values.

Answers

l) The location of page breaks in a worksheet can be changed.

Answers

m) Clearing a print area sets the entire worksheet as the print area.

Answers

n) The principal of a loan decreases each time a payment is made.

True.

o) Sheet1 can print a different header than Sheet2.

True.

p) A new workbook contains three sheets.

True.

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

True.

A Guide to Microsoft Office 2007