EXCEL

This month of February you have been learning the Spreadsheet Application - EXCEL.

On February 24th, Thursday, you will have an Excel Test. Check your notes and the handouts Mrs. Feld will give you, and remember what was already taught in class.

Study the Automatic Features in Excel: AutoComplete, AutoCorrect, AutoCalculate, AutoFill (& AutoFill Fill Handle), and AutoSum. Also answer the following questions, if you don’t find the answers in the hand-outs, check the Microsoft Office Textbook (Chapter 7 and Chapter 9). And review pages 5 and 6 of the Excel Summary.

What is a spreadsheet?

What is a spreadsheet document called in Excel?

How many worksheets does a new workbook contain? What is a worksheet?

What is a cell? What is an “active” cell?

What is a cell address?

Which are the column identifiers (labels)? Which are the row identifiers (labels)?

When does a cell display # # # #?

How can you quickly “add” numbers in and Excel Worksheet?

How can you quickly copy a formula to other cells?

How can you add a Header and Footer in an Excel Worksheet?

What is a chart, what is its purpose?

How do you add a chart in Excel? Mention two ways.

How is an entire column selected? How is an entire row selected?

What is a formula in Excel?

True/False Practice:

1. A cell reference consists of a column letter only.

2. Selected cell and active cell mean the same thing.

3. The contents of the active cell are displayed in the Name Box.

4. A cell’s alignment can be changed.

5. A cell address is also called a cell reference.

6. The “AutoComplete” Feature in Excel will automatically insert data in a cell that begins the same as a previous entry.

7. The “AutoCorrect” Feature automatically formats your data to your liking.

8. The “AutoFill fill handle” is the white cross (pointer) in an Excel workbook.

9. The “AutoSum” feature in Excel allows you to add and calculate the sum of a list of numbers in your worksheet.

10. The multiplication symbol in an Excel formula is an “x.”

11. The division symbol in an Excel formula is represented by a slash (“/”).

12. All formulas must start with an equal sign (=).

13. Any expression in a formula that is enclosed within a parentheses is calculated first.

14. Certain formulas can be entered in Excel without entering an equal sign.

15. To enter “today’s date” in Excel you enter =TODAY().

16. The “AutoCalculate” feature in Excel is a shortcut that allows you to view a calculation for a selected range of cells without placing a function in a cell.

Which is the Excel Formula that adds the numbers in cells A1 through A6?

Which is the Excel Formula that multiplies the numbers in cells B3 and C3?

Which is the Excel Formula to calculate the average of the numbers in cells B3 through B8?

Vocabulary: spreadsheet, workbook, worksheet, worksheet area, gridlines, cell, active cell, column identifiers, cell reference or cell address, name box, formula bar, AutoSum, AutoComplete, AutoFill Handle, AutoCorrect, AutoCalculate, chart.

If you have any questions, please feel free to ask Mrs. Feld.