Monday, November 26

NOVEMBER 26, 2007
Manage workbooks
Navigate and edit a worksheet
Change number formats and copy and move data
Check and correct cell data and formats
Manipulate rows and columns
Apply and modify cell formats
Apply styles and AutoFormats
Modify the page setup
Preview and print worksheets

1. Warm-Up- Mavis- 10 Minutes, Please keep track of your WPM and add to your spreadsheet that has your rice donations. You will be printing on Friday & turning in as a test grade.
2. Be sure the following assignments are completed, printed and turned in to the tray by the end of the period today. In order to get the datafiles listed below, you can click on the link below OR you can go to www.mhsbcis.blogspot.com; click on My Website Downloads and click on the file you need

• 11-20, pages 210-213, Employee Info
  11-19, pages-206-208, Employee Info
  11-16, pages-203-205,xxx Facts&Figures
  11-15 pages 190-202, xxxMail Employees
  11-14, Pages 174-177, Final Facts
  11-13 , Pages 166-172, xxx-facts
  FEED THE HUNGRY-WORD PLANNER

3. Create a sentence using the vocabulary below (post to your blog titling it Excel Vocabulary 1)

Vocabulary Review (QUIZ OVER THESE WORDS ON FRIDAY, NOV. 30TH)

• 1. Active Cell-In Excel, the cell that is currently selected is called the active cell
• 2. Cell-A cell is the intersection of a row and a column in a table or worksheet. It contains information such as text, numbers, or graphics.
• 3. Column-A column is the vertical line of cells identified by an alphabetic label in the first cell on the top.
• 4. Find-The Find command allows you to search for specified text and/or formatting in a document.
• 5. Formula-In Excel, a cell entry that performs a calculations and begins with an equal sign in the cell [i.e. =SUM(A1:A20)] is called a formula.
• 6. Label-A label is a text entry in an Excel worksheet.
• 7. Range-A cell or group of cells that can be selected in an Excel worksheet is called a range.
• 8. Replace-The Replace command allows you to search for specified text and/or formatting in a document and replace it with new text and/or formatting that you specify.
• 9. Row-A row is the horizontal line of cells identified by a number in the first cell on the left.
• 10. Value-A numeric entry in Excel is called a value.
• 11. Workbook-A workbook is an Excel file that can contain up to 256 worksheets.
• 12. Worksheet-A worksheet is a page—or one spreadsheet—in an Excel workbook.

4. Closure- Freerice.com -Keep track of your donations on your spreadsheet, remember you will be printing in class Friday for a test grade. 10 minutes