Page 231 - Excel Progamming Weekend Crash Course

l540629 PR03.qxd 9/2/03 9:35 AM Page 206

T
R
PA R T
PA

# III
I

Saturday Afternoon

Part Review

1. How can you determine the number of rows and columns in a range?
2. What does Application.Columns refer to?
3. Your program inserts one new column at position B. What happens to the old
column B?
4. Assume that range R refers to cells A1:D6. To which cell does R.Cells(6) refer?
5. What does Worksheets(“Sales Data”).Cells refer to?
6. How could you refer to all blank cells in a range?
7. Cell A10 contains the formula =SUM($A$1:$A$9). If you copy this formula to cell
F20, what does it change to?
8. A formula contains the cell reference A$10. What happens when this formula is
copied to another cell?
9. How can a formula in one worksheet reference a cell in another worksheet?
10. How does Excel tell a cell formula from text data?
11. What is a circular reference?
12. Which Excel function is used to calculate the payment on an installment loan?
13. Which Excel function formats a numeric value to currency format?
14. Is it possible to use an Excel function in VBA code? If so, how?
15. How do you change the numeric display format of a range?
16. What are the three primary colors that are used in defining colors in Excel?
17. Which property would you set to change the background color of cells?
18. Which unit is used to measure the width of columns in a worksheet?
19. Which method would you call to adjust the width of columns to fit the data they
hold?