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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- ms excel mcq quiz set 1 e library wcl
- advanced excel statistical functions formulae
- advanced excel
- count and sum your data in excel 2002
- excel proj 1 true false
- calculation of repeatability and reproducibility
- the mathematics of value at risk
- wemba excel review
- unit 3—introductory microsoft excel
- introduction to excel formulae and functions
Related searches
- true premises false conclusion
- mental health true false pdf
- true or false solver
- true premises false conclusion example
- true or false excel formula
- true false on excel
- excel add 1 to number
- true false excel logic
- false premises true conclusion
- excel add 1 to column
- excel add 1 to cell
- true prophecy verses false prophecy