EXCEL

You will start learning, or remembering, Excel - the spreadsheet application of Microsoft Office this new quarter. Please download the PDF on Microsoft Office 2011 for Macs, and start on page 175 (for Excel). Mrs. Feld will tell you what to highlight, to practice doing this with a PDF and you will create your own PowerPoint answering the following questions:

1. What is Excel?
2.  What is a Workbook?
3. What are Worksheets? Where do you find them?
4. What are the different parts of the Excel Interface? Name at least 10 items.
5. View the Excel Interface to locate these parts. If you want copy the example from the PDF and paste in your PowerPoint.
6. What is a Cell Reference or Cell Address? Where can you find it?
7. What is a Column? What is a Row? How are these labeled?
8. What is an Active Cell?
9. What is the AutoFill?
10. What are Excel "Automatic Features" Please understand what these are (check the Excel PowerPoint in Edmodo).
11. What is the Worksheet Area?
12. How do you rename a Sheet? Check page 192.
13. How do you add and delete a Sheet? Check page 194.
14. How do you resize a Column? How do you resize a Row? Mention and learn two ways to do this. Check pages 206 and 207.
15. How do you delete Columns and Rows? Check page 209.
16. How do you insert Columns and Rows? Check page 210.
17. You must learn how to Merge Cells, how to add Borders, and how to format text and numbers. Pages 214, 215 and 216.
18. You must also learn how to apply Color to cells. Page 217.
19. You must learn how to add Clipart and Images in Excel. Page 224.
20. You will learn how to enter simple formulas in Excel, Sum, Multiplication (Product), Average, and others. Also how to enter “today’s date” and the “date and time” using a formula. Page 240.
21. You will also learn how to insert create tables, charts and graphs. Page 242 and 253 (Chapters 13 and 14).

       To answer some of these questions, like Excel Automatic Features, I downloaded a Power Point with this information in Edmodo, and I will explain in class.
   
Your first Excel Exercise is called "bscex1" - I will explain it in class. When you finish this exercise you must download it in Edmodo for a grade. If you have any questions, please feel free to ask. All your Excel exercises must have a Title and the date (using the Today's Date Formula) and you will enter your Name, Period No. and Section, and Grade in the Footer.

Later, you will create a Column Chart and a Pie Chart for this exercise, and also create the second Excel Exercise, bscex2. You will also create a Column Chart and a Pie Chart for this one. You MUST understand how to do this for the test you're having this quarter and for the FINAL EXAM. If you  have any questions, please feel free to ask me.