Basic Excel Review Questions

1. What is a workbook?
2. What is displayed in the name box?
3. What is the intersection of a column and row in Excel called?
4. What is the default number of sheets in a workbook?
5. What tasks can you perform in the formula bar?
6. What symbol is typed before a number to make the number a label?
7. What is an example of a function?
8. What is a predefined formula for a commonly used calculation called?
9. What symbol precedes a formula entered in the formula bar?
10. What is the purpose of the fill handle?
11. What character is used to create an absolute cell reference?
12. How does a mixed cell reference differ from an absolute or relative cell reference?
13. What is conditional formatting?
14. How many conditional format can be created for a specific cell?
15. How does the currency format differ from the accounting format?
16. Where is the $ located when a number is formatted in accounting format?
17. Which Excel feature applies formatting attributes based upon the contents of the cell?
18. What is the name of the feature used to resize a column to its widest entry?
19. What is the object in a chart called that identifies the patterns used for each data series?
20. What chart type compares data over time and is the Excel default chart type?
21. What chart type shows trends over even time intervals?
22. What is the term for a row or column of data on a chart?
23. What do we call the page orientation with dimensions 11" wide by 81/2" tall?
24. In a 2-dimensional chart what is another name for the Value axis?
25. In a 2-dimensional chart what is another name for the Category axis?
26. What the math and logical operators in Excel?
27. How does the COUNT function differ from the COUNTA function?
28. What are the arguments for the IF function?
29. What is a conditional formula?
30. What is an example of a logical test in a conditional formula?Can dates be used in calculations? 
31. What function places the current date in a cell?
32. What is the purpose of the AutoSum button on the Standard Toolbar?
33. What buttons are found on the Standard Toolbar?
34. What is a page header and footer? 
35. Whih menu bar let a user change the header and footer?
36. What is a 3-D reference?