Excel Proj 1 - True False



Name _________________________ Date ___________

Excel 2007 Chapter 4 – True/False

Instructions: Circle T if the statement is true or F if the statement is false.

|T |F |1. Cell protection ensures that users do not change values inadvertently that are critical to the worksheet. |

|T |F |2. The backslash is the concatenation character. |

|T |F |3. You must format a cell before you enter data into it. |

|T |F |4. A cell name can be created from column and row titles through the use of the Cell command on the Insert menu. |

|T |F |5. Excel considers names to be relative references. |

|T |F |6. You can add up to eight different conditions to a cell or range of cells. |

|T |F |7. A column border is an unused column with a significantly reduced width. |

|T |F |8. When you first create a new worksheet, all the cells are unprotected. |

|T |F |9. You can move from one unprotected cell to another unprotected cell by using the ALT key. |

|T |F |10. Background formula checking means that Excel continually will review the workbook for errors in formulas as you |

| | |create or manipulate it. |

Excel 2007 Chapter 4 – Multiple Choice

Instructions: Circle the correct response.

1. _______________ portions of a workbook let’s you show only the parts of the workbook that the user needs to see.

a. Deleting

b. Hiding

c. Locking

d. Protecting

2. Which of the following is true of cell names?

a. a name can be a minimum of 1 character to a maximum of 255 characters

b. names are global; a name assigned on one workbook can be used on other workbooks on the same disk to reference the associated cells

c. names are absolute cell references

d. all of the above

3. Names are ________________ to a workbook.

a. referential

b. local

c. global

d. protected

4. Use the ________________ to return the present value of an investment.

a. PV function

b. Goal Seek command

c. amortization schedule

d. Data Table command

5. A _______________ allows you to vary the values in two cells, but you can apply it to only one formula.

a. one-input data table

b. two-input data table

c. multi-input data table

d. value-input data table

6. To define a range as a table, use the ________________ command on the What-If analysis button on the Data tab.

a. Create

b. Insert

c. Define

d. Data Table

7. If you assign formats to a range and wish to start over, select the range, click the Cell Style button, and then click ________________ in the Cell Style gallery.

a. Normal

b. Undo

c. Refresh

d. Basic

8. _______________ cells are cells whose values you can change at anytime.

a. Protected

b. Unprotected

c. Hidden

d. Locked

9. Sheets are hidden by first selecting one and then using the _______________ on the sheet tab’s shortcut menu.

a. Hide command

b. Protect command

c. Lock Table command

d. Hide All button

10. Excel has a(n) _______________ that checks formulas in a worksheet for rule violations.

a. error checker

b. formula checker

c. format checker

d. data checker

Excel 2007 Chapter 4 – Short Answer

Instructions: Fill in the blanks with the appropriate term or phrase.

1. A cell name is created through the use of the _______________ command.

2. To use a name that is made up of two or more words in a formula, replace each space with the _______________.

3. You can double-click a cell with a formula and Excel will use ________________ to highlight the cells that provide data to the formula.

4. Excel’s ________________ function returns the future value of an investment based on periodic, constant payments, and a constant interest rate.

5. A(n) ________________ is a range of cells that shows the answers generated by formulas in which different values have been substituted.

6. To add conditional formatting to a range, click the _______________ button on the Home tab on the Ribbon and then click New Rule to add the condition.

7. A(n) _______________ shows the beginning and ending balances and amount of payment that applies to the principal and interest for each year over the life of the loan.

8. A(n) _______________ is a series of fixed payments at a fixed interest rate.

9. When Excel displays the Page Setup dialog box, click the Page tab and then click _______________ in the Scaling area to set the worksheet to print on one page.

10. _______________ cells are cells that you cannot change.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download