Site hosted by Angelfire.com: Build your free website today!

Intermediate Computer Technology

DDC book: Excel Questions

1. Name, explain, draw and indicate the standard toolbar, formatting tool bar in Excel.

2. Explain and draw what the merge cells toolbar icon looks like.

3. What does the save function do? What does the save as function do? What is the difference between the two?

4. What combination keys help you move to cell A1?

5. What is a formula? What is a mathematical operator? What is the difference between the two?

6. List the mathematical operators.

7. What is a numeric label? What is a value? What is the difference between the two?

8. List and explain the different ways you can format numbers.

9. What is an absolute reference? Explain a situation that absolute reference is useful.

10. In fonts, how many points to an inch?

11. What is an Excel function? Name and explain the five functions listed in the DDC book (p. 210)

12. What is auto calculate? Does Excel 97 (your computer’s version) have this feature? What actions do you do to find auto calculate?