Microsoft Excel Questions... 9 pages of questions.

Name _________________________ Date ___________

Excel 2010: Chapter 4 – Multiple Choice

Instructions: Circle the correct response.

1. You use a(n) ____________ to automate data analyses and organize the answers returned by Excel.

a. Cell b. data table c. formula d. annuity

2. ____________ formatting is when you assign a format to all the cells in all the worksheets in a workbook.

a. Class inheritance b. Absolute c. Global d. Frontline

3. The ____________ can help add clarity to your formulas by allowing you to assign names to cells.

a. Office Clipboard b. Formula Documenter c. Assignment Wizard d. Name Manager

4. Which of the following will display when you enter .5 in a cell that is formatted as percent?

a. .5% b. 5% c. 50% d. 500%

5. The ___________ function returns the present value of an investment.

a. FV b. PMT

c. PV d. INV

6. A(n) ____________ data table allows you to vary the values in two cells.

a. absolute b. relative c. mixed d. two-input

7. ____________ cell references are cells with a dollar sign.

a. Absolute b. Relative c. Function d. Hidden

8. To save toner or ink, instruct Excel to print ____________ documents.

a. draft quality b. save mode c. page setup d. weak print

9. ____________ cells are cells whose values you can change at any time.

a. Non-hidden b. Open c. Unprotected d. Unlocked

10. You can create a(n) ____________ when you want to keep others from changing your worksheet.

a. global format b. password c. assumption table d. sheet button