Third Quarter

On February 26, Thursday, you will have a Test on Excel. Please check the hand-out (“Introduction to Excel”), the Excel Summary Mrs. Feld gave you on February 23, and also remember what was 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).

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 copy a formula to other cells quickly?

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?

Why would you use Conditional Formatting in Excel?

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?