1 / 18

More basic excel 2007

Learn how to format an Excel worksheet to emphasize entries and improve readability. Follow step-by-step instructions for text alignment, auto-correction, table creation, sum calculations, formatting changes, and saving. Improve your Excel skills now!

thurstonj
Download Presentation

More basic excel 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. More basic excel 2007 Mrs. Macias Computer Science SS 2008

  2. OPEN Excel • Click cell A1 to make cell A1 the active cell. • Type: Walk and Roll Music in cell A1 and the point to the Enter Box in the formula bar. • Click the Enter Box to complete the entry and enter the worksheet title in cell A1. • Click cell A2 to select it. • Type: First Quarter Rock-It MP3 Sales as the cell entry. Click the Enter Box to complete the entry and enter the worksheet subtitle in cell A2.

  3. Entering Text in Excel Automatically: Left-Aligned When the text is longer than the width of a column, Excel displays the overflow characters in adjacent cells as long as these adjacent cells do not have any data. If there is data, only a portion of the text will appear. Excel stores the overflow characters in cell A1 and displays them in the formula bar whenever A1 is the active

  4. AutoCorrect Corrects two initial capital letter by changing the second letter to lowercase. For example, changes “SCience” to “science” Capitalizes the first letter in the days of the week. Fixes commonly misspelled words with the correct ones. For example, “recieve” into “receive” when you complete the entry.

  5. Creating the Table (1.) Enter the column titles for our table: Click cell B3 to make cell B3 the active cell. Type: Northeast in cell B3. Press the right arrow key to move to cell C3. Type: Southeast in cell C3. Type: Midwest in cell D3. Type: South in cell E3. Type: West in cell F3. Type: Total in cell G3.

  6. Creating the Table, cont’d (2.) Enter the row titles for our table: Click cell A4 to select it. Type: Video in cell A4. Press the down arrow key to move to cell A5. Type: Mini in cell A5. Type: Micro in cell A6. Type: Flash in cell A7. Type: Accessories in cell A8. Type: Total in cell A9.

  7. Entering Numbers in Excel Number in Excel contain only the following: 0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e If your cell contains any other keyboard character (including spaces), Excel treats your entry as text.

  8. Creating the Table, cont’d (3.) Enter the Sales Numbers for our table: Use the handout to enter the Sales by locale and product. Enter as numbers. Don’t enter total amounts, we want to use the formula for that.

  9. Calculating a Sum Sum Function – Adds up all number in the range of cells. Range – series of two or more cells

  10. Creating the Table, Sum the Column (4.) To sum the columns: Click cell B9 to make it the active cell. Click on the Sum button on the Ribbon. (It’s in the Editing Group; looks like this: Σ The formula box should display =sum(B4:B8) Click Enter and Repeat for all regions.

  11. Creating the Table, Sum the Rows (5.) To sum the rows: Click cell G4 to make it the active cell. Drag the mouse pointer down to cell G9 to highlight the range G4:G9. Click on the Sum button on the Ribbon. (It’s in the Editing Group; looks like this: Σ Select cell A10 to deselect the range G4:G9.

  12. Save the Workbook Click MS Office Button, click Save As, select Excel 97-2003 Workbook (to make sure you can use it at home or someone with an older version of MS can open it.) Select H drive. Find your user name folder. Click on File name box and change file name to (Your Name) Excel Project #3.

  13. FORMATTING THE WS Format(change the appearance) of worksheet to emphasize certain entries and make the worksheet easier to read and understand. Using formatting you can make the worksheet look more professional.

  14. Change a Cell Style Click cell A1 to make cell A1 the active cell. Click the Cell Styles button on the Ribbon to display the Cell Styles gallery. Point to the Title cell style in the Titles and Heading area of the Cell Styles gallery to see a preview of the cell style in cell A1. Click the Title cell style to apply the cell style to cell A1.

  15. To Change the Font Type Click cell A2 to make cell A2 the active cell. Click the Font box arrow on the Ribbon to display the Font gallery. Point to Cambria in the Theme Fonts area of the Font gallery to see a live preview of the Cambria font in cell A2. Click on the Cambria in the Theme Fonts area to change the font type of the worksheet subtitle in cell A2 from Calibi to Cambria.

  16. More Font Changes… Bold cell A2. Change font size of cell A2 to 14. With cell A2 selected, click the Font Color button arrow on the Ribbon to display the Font Color palette. Select the dark blue color in column 4, row 1.

  17. Center and Merge Cells Select the range A1:G1. Click the Merge & Center button on the Ribbon to merge the contents of A1 across columns A through G. Repeat the above steps to center and merge subtitle across cells A2 through G2.

  18. Excel Project #2 Go to shortcut on desktop to class web site. Or go to my page though www.alemany.org. Go to Calendar for today. Access the Excel Project #2 Workbook. Follow the directions provided in the “Assignment” worksheet. Make sure you save and name the file as directed. DO NOT PRINT. Save it to your H: drive under your user name. That’s how I will correct it.

More Related