FINAL EXAM - EXCEL

ATTENTION COMPUTER APPS STUDENTS: 

(PLEASE SPREAD THE WORD...)

I decided to make it easier for all of you and count the next TEST (Excel) as your Final (our Vice-Principal approved). 

I'll review with you next week and if you have any questions or need any assistance you MUST come and see me (we already reviewed this material, but you must study for this exam). I'm attaching here the Excel Review with True and False questions (with the answers) for you to study. Review the previous entry on Excel, to make sure you can answer those questions (for Multiple Choice and Matching questions) - the information you added in the Excel PowerPoint. Also, make sure you understand how to create a table with charts like Excel Exercises No. 1 and 2. Also, how to use the AutoSum to enter the Sum formulas and how to create Average formulas.

Any questions, please come and see me ASAP. 

Group 3 will take the test on Wednesday, May 21st; Group 1 on Friday, May 23rd; and Group 2 on Wednesday, May 28th. If you must take it another time, you MUST let me know. Thanks! 

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.

Second Semester

On our Third and Fourth Quarter you will continue learning how to format Word Documents properly; you will learn how to create spreadsheets, tables and graphs using Excel, and you will learn how to save documents in the Office 365's Skydrive.

 It is essential to learn to format Word Documents per the teacher's instructions, here in school and in college. You need to master this well, so that you can easily change margins, change indentation, change the orientation of the page, change line spacing, add tab stops, insert tables, insert pictures, create two or more columns, add Headers and Footers, add page numbers, etc. You must become familiar with the Ribbon in Microsoft Office 2011 (Macs) and 2010 (Windows). Most of you probably have Windows computers at home.

Feel free to use our textbook for more information. Presentation is always very important!

Tab Stops:

Tabs provide a way for you to control the indentation and vertical alignment of text in your document. When you press the Tab key, Word inserts a tab in the document; this moves the cursor—and any text to the right of it—to the next tab stop. By default, Word has tab stops at 1/2-inch intervals across the width of the page. You can modify the location of tab stops and control the way text aligns at a tab stop.

There are four basic types of tab stops (besides the first line indent and the hanging indent tabs), and each aligns text differently:

• Left-aligned The left edge of text aligns at the tab stop. Word's default tab stops are left-aligned.
• Right-aligned The right edge of text aligns at the tab stop.
• Center-aligned The text is centered at the tab stop.
• Decimal-aligned The decimal point (period) is aligned at the tab stop. You use this type of tab for aligning columns of numbers.  

REVIEW:

1. What are tabs?
2. When do you use tabs in Microsoft Word?
3. What’s the first thing you should do when you need to work with tabs?
4. What are default tabs?
5. Which are the different types of tab stops?
6. How can you set tabs more precisely? Where do you go?
7. How do you change the tabs for an entire document?
8. What are first line indents? What are hanging indents?
9. Mention two ways to indent a paragraph in Microsoft Word?
10. When do you move the left indent square?
11. How do you create a hanging indent? Mention two ways.
12. Which tab is the most used?
13. How do you remove tab stops from your ruler?
14. How do you set a tab stop?
15. What are tab leaders? How do you create them?

Exercise:

In a Word Document enter theTitle: Kennel Log (bold) - like you see it below. Then, enter the following tab stops: Center Tab Stop on 1", Center Tab Stop on 1.75", Right Tab Stop on 3.25", and Decimal Tab Stop on 4". Enter all the information below, horizontally please! Pressing the Tab Key only once between entries. Bold the titles and then change the Decimal Tab Stop on the title "Weight (kg)" to a Center Tab Stop on 4". Change the information below the title "Name" to Italic. Enter your name in the footer - Left Aligned.

Insert a picture or two of dogs under the text, and wrap the pictures to "In front of text" so that you can move them around easily. Print for Mrs. Feld and make sure you save this document in the Server, under you account. Deleted from the local computer. Thank you...

Kennel Log

Name          Age         Kennel        Feeding Time        Weight (kg)

Peach           12             19B                       4 p.m.               8.5

Meatball         2               6C                        6 p.m.                9.25

Mango            1              12A                   6:30 p.m.               5.75

Booper           6               5A                        2 p.m.             12.5

(Basically, the first column remains on "0" - no tab stop, the second column centered on 1", the third column centered on 1.75", and the fourth column, a decimal tab stop on 4" and later a center tab stop on 4" for the title "Weight" only.)

By now you should have two exercises done, the Vitamins one, and the Hawaiian Islands one (pages 107 and 108 from the Microsoft Office textbook). These two exercises MUST be in your accounts, and not in the local computers. If you still have difficulties understanding how to save your work in your accounts or understanding this type of exercises, please ask Mrs. Feld to assist you.