Course Lab

Tables are composed of ...?
What is the intersection of the above, called?
What 4 things can you put into the above?
How do you identify this storage area?
How else can you identify this area, say for use in English like statements?
What do you call a group of these storage areas?
How do you identify this group of storage areas?
How do you enter text or numbers, and how does excel display them?
What is ?
How does work?
What is actually in the cell, and what actually displays?
What do all non-numerical and all non-text entries begin with?
When a cell is selected there is a handle at the bottom right. What can that handle do, if dragged?
What can be used to more easily convey numerical information? How can one be easily created?
Discuss AutoCalculate on the Status Bar

How can you enter multiple lines of text in one cell? Describe turning on wrap text
Describe the parts of a formula.
When using a cell's contents as part of a formula, name 3 ways to include that cell address.
Name and show the Excel versions of the arithmetic operators.
How can you tell Excel which operations to do first? Discuss order of operations.
What is a function?
What are the compound parts of the 'Average' function?
What button do you click to access functions?
What is the difference between .4, 40%, and =2/5? How do you change the display method?
What is the range finder? How can you see to cell references?
What are borders used for? How can they be applied?
Discuss Conditional Formatting.
How can you change the size of a row or column? How can you have Excel automatically resize?
What does ###### mean?
Is Excel 100% WYSIWYG? If not, how so?
How can you add class information, for example, to a printed worksheet?
Describe getting a worksheet to fit on a page. Discuss Page Setup
How can you display the actual contents of a cell, and not just the results?
A workbook may contain many sheets. How to you rename the sheets? How can you display the contents of something on one sheet in another sheet?

How can you rotate text in a cell?
Can you autofill month names?
How can you insert or delete cells, etc., in Excel?
How do you freeze an area, and what is that freeze good for?
Discuss dates and times.
Compare and contrast absolute and relative addresses.
What are the parts of an IF functions? What interesting item can you place in the last option?
Discuss the Format Painter
Describe docking.
Describe 3D charts, and other formatting tricks.
Can you rearrange sheets in a workbook? If so, how?
Discuss 'What if.'