Microsoft Excel

Excel 2013 is a spreadsheet program that allows you to store, organize, and analyze information. While you may think that Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of Excel's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different kinds of data.

Introduction to Excel

*I will define the different components of Microsoft Excel.

*I will practice data entry with label and value and their formatting option.

*I will practice several shortcuts for ease of data entry.

*I will modify row and column height and width.

*I can insert and delete rows and columns.

*I can text wrap a cell range.

*I will merge cells.

1. Read through The Excel Interface with a Partner
2. Read through The Ribbon with a Partner
3. Read through Quick Access Toolbar with a Partner
4. Read through Worksheet Views with a Partner

Next:

5. Both you and your partner download the Excel Key Component Document

6. Click on the Excel Key Component Document to access the document.
7. Click on File
8. Save As in the File Ribbon
9. Click Download
10. In the bar below click on the down arrow to the right of Save
11. Click Save As
12. Click Computer on Main View Pane
13. Click on your network folder (B: drive with your name)
14. Click on your Digital Literacy Folder
15. Call it: 6-section # Excel Key Components last name
16. Each of you will be filling out your own worksheet, but you can discuss it together.
17. When you are finished drop your completed worksheet in the 6th Grade Dropbox Link

Assignment #2: Challenge

Watch the video Cell Basics

As you work on the following challenge, if you cannot remember how to do something - Click on Cell Basics to help you along the way.

Challenge!

1. Download the Cell Basics Practice Workbook. (Follow the steps in Assignment #1) - call your workbook 6-# Cell Basics Last Name
2. Select cell D3. Notice how the cell address appears in the Name box and its content appears in both the cell and the Formula bar.
3. Select a cell, and try inserting text and numbers.

4. Delete a cell, and note how the cells below shift up to fill in its place.
5. Cut cells and paste them into a different location. Cut cells D4:D6 and paste them to E4:E6.

6. Try dragging and dropping some cells to other parts of the worksheet.
7. Use the fill handle to fill in data to adjoining cells both vertically and horizontally. Use the fill handle to continue the series of dates across row 3.
8. Use the Find feature to locate content in your workbook.Type the name Lewis into the Find what: field.
9. When you are finished drop your completed worksheet in the 6th Grade Dropbox Link

Assignment #3: Challenge

Watch the Video Modifying Columns, Rows and Cells

As you work on the following challenge, if you cannot remember how to do something - Click on Modifying Columns, Rows and Cells to help you along the way.

Challenge!

1. Download the Modifying Columns, Rows and Cells Workbook. (Follow the steps in Assignment #1) - call your workbook 6-# Modifying Last Name
2. Modify the width of a column. Use the column that contains the players' first names.

3. Insert a column between column A and column B, then insert a row between row 3 and row 4.
4. Delete a column or a row.
5. Move a column or row.

6. Try using the Text Wrap command on a cell range. Wrap the text in the column that contains street addresses.
7. Try merging some cells. Merge the cells in the title row using the Merge & Center command (cell range A1:E1).
8. When you are finished drop your completed worksheet in the 6th Grade Dropbox Link

Assignment #4: Challenge

Watch the Video Formatting Cells

As you work on the following challenge, if you cannot remember how to do something - Click on Formatting Cells to help you along the way.

Challenge!

1. Download the Formatting Cells Workbook. (Follow the steps in Assignment #1) - call your workbook 6-# Formatting Cells Last Name
2. Select a cell and change the font style, size, and color of the text. Change the title in cell A3 to Verdana font style, size 16, with a font color of green.
3. Apply bold, italics, or underline to a cell. Bold the text in cell range A4:C4.
4. Try changing the vertical and horizontal text alignment for some cells.
5. Add a border to a cell range. Add a border to the header cells in in row 4.
6. Change the fill color of a cell range. Add a fill color to row 4.
7. Try changing the formatting of a number. Change the date formatting in cell range D4:H4 to Long Date.
8. When you are finished drop your completed worksheet in the 6th Grade Dropbox Link

Assessment - How to Prepare

Use Quizlet to help you study and if you click on each the terms it will take you to the place in the OneNote document to help you review.

You will need to know the following terms:

The Excel Interface

Ribbon

Vertical and Horizontal Text alignment

Fill Handle

Cell Range

Selecting a Cell

Modify Column Width

Modify Row Height

Insert a Column

Delete a Row

Text Wrap

Merge Cells

Find and Select

Formatting Text and Numbers

Merging Cells

Border and Fill Color

Font, Font Size, Font Color, Font Style(Bold Underline and Italic)