Business Department

Forms and Projects:
Excel Worksheet

1. What is a worksheet?

2. What is a cell?

3. What do you call a consecutive group of cells going vertically down a spreadsheet?

4. What do you call a consecutive group of cells going horizontally across a spreadsheet?

5. What do you call a random block of selected consecutive cells on a spreadsheet?

6. What is an active cell?

7. What is a cell reference?

8. What is a label?

9. What is a value?

10. What is a function?

11. How do you format a number to be a label?

12. What is the equation to add the two cells A3 and A4?

13. What is the equation to multiply the two cells C6 and D6?

14. What is the equation to divide the two cells G15 by H35?

15. What is a relative cell reference?

16. What is an absolute cell reference?

17. How do you make a cell reference absolute?

18. What is the function that will find the total of a column of numbers?

19. What is the function that will find the average of a column of numbers?

20. What is the function that will find how many numbers there are in a group of cells?

21. What is the function that will find the highest number in a group of cells?

22. What is the function that will find the smallest number in a group of cells?

23. Write a conditional function that will determine an "A" in this class. (Use 90% as the number you must get for an "A")

24. List steps to create an embedded chart in Excel?

25. What is the purpose for the Future Value and PMT function?

26. What does a lookup table do?

Webmaster: Bruce Case | Last Updated: 6/23/06 | Site designed by Todd W. Mar '04; Updated by Tim B Jun '06