Excel Review

1. The simplest way to enter data in a worksheet is to click the cell in which you want to enter data and type.

2. The purpose of AutoFill and FillSeries is to enter patterns of data or a series of data by more quickly and efficiently.

3. When using AutoFill, there are four options that appear:
a. Copy Cells
b. Fill Series
c. Fill Formatting Only
d. Fill Without Formatting

4. The Pick from Drop-down List action can be used for more options than what is initially shown on the icon.

5. The Paste Options button appears on the far right of the Ribbon in the Home tab. In a spreadsheet it may be used to copy data from cells and pasted to other cells or worksheets.

6. You may locate specific data on a work sheet by using the Find & Select feature located on the far-left side of the Ribbon in the Home Tab.

7. The Replace tab in the Find & Select dialogue box can be used to replace or correct specific data in a worksheet.

8. Three proofing and Research tools available in Excel 2007:
a. Spelling Checker
b. Thesaurus
c. Translator
9. You can create a Data table in Excel 2007 by clicking on the Table icon on the Insert tab.

10. The purpose of a Total row in a table is to calculate the total value of data in a specific series of cells.