Microsoft Excel 2007 - Functions in Excel 2007, Creating Chart, How to use Graphics in excel 2007
| Functions in Excel 2007 |
| The Sum Function in Excel 2007 |
| Functions are prewritten formulas. Functions differ from regular formulas in that you supply the value but not the operators, such as +, -, *, or /. For example, you can use the SUM function to add. When using a function, remember the following: |
1) Use an equal sign to begin a formula. 2) Specify the function name. 3) Enclose arguments within parentheses. |
| Arguments are values on which you want to perform the calculation. For example, arguments specify the numbers or cells you want to add. |
| - Use a comma to separate arguments. |
| Here is an example of a function: |
| =SUM(2,13,A1,B2:C7) |
| Functions |
| The SUM function adds argument values. |
 |
1. Open Microsoft Excel. 2. Type 12 in cell B1. 3. Press Enter. 4. Type 27 in cell B2. 5. Press Enter. 6. Type 24 in cell B3. 7. Press Enter. 8. Type =SUM(B1:B3) in cell A4. 9. Press Enter. The sum of cells B1 to B3, which is 63, appears. |
| AVERAGE function |
| You can use the AVERAGE function to calculate the average of a series of numbers. |
 |
1. Move to cell A6. 2. Type Average. Press the right arrow key to move to cell B6. 3. Type =AVERAGE(B1:B3). 4. Press Enter. The average of cells B1 to B3, which is 21, appears. |
| Calculate an Average with the AutoSum Button |
| In Microsoft Excel, you can use the AutoSum button to calculate an average. |
 |
1. Move to cell C6. 2. Choose the Home tab. 3. Click the down arrow next to the AutoSum button . 4. Click Average. |
 |
| 5. Select cells C1 to C3. 6. Press Enter. The average of cells C1 to C3, which is 100, appears. |
| Excel 2007 Date Function |
| The TODAY( ) function automatically retrieves the current date. It is useful for creating spreadsheets that continuously update themselves such as to determines the number of days a payment is overdue. |
| The NOW( ) function is similar to the TODAY( ) function, except it retrieves the current date along with the current time. |
| To demonstrate the use of Date and Time Functions: TODAY |
| . Create a spreadsheet as follow: |
 |
| . Click on the cell B3, where the answer will appear. . From the Formula tab, in the Function Library group, click the Date & Time icon and from the drop down menu, click the TODAY command. |
 |
| . From the Function Arguments dialog box displayed, click OK. . The today date will display on the cell B3. |
| Note: If you directly type =TODAY( ) to the cell B3, the same result will appear. The following day, month and year functions are based on this date. |
| To demonstrate the use of Date and Time Functions: DAY |
| . Click on cell B4 and enter the following function: |
| =DAY(B3) |
| . Press the Enter key. You will notice that the current day of the month is displayed on the cell B4. |
| To demonstrate the use of Date and Time Functions: MONTH |
| . Click on cell B5 and enter the following function: =MONTH(B3) . Press the Enter key. You will notice that the current day of the month is displayed on the cell B5. |
| To demonstrate the use of Date and Time Functions: YEAR |
| . Click on cell B6 and enter the following function: =YEAR(B3) |
| . Press the Enter key. You will notice that the current day of the month is displayed on the cell B6. |
| . Here are the results: |
 |
| The Excel 2007 DATE function is a quick and easy way to insert a date into a formula. DATE( ) accepts three numbers, each of which represents a different component of the date. Here's what it looks like: |
| DATE(year, month, day) |
| So, if you enter this formula into a cell: =DATE(2010, 1, 1) |
| Excel displays the date 1/1/2010. |
| Time Functions in Excel 2007 |
| There are a number of ways to enter the current time in an Excel 2007 spreadsheet. Try this: |
| . Click inside a blank cell on your spreadsheet . Click into the Formula Bar at the top . Type the following inbuilt function: |
| = Now( ) |
| Hit the enter key, and you'll get the current date and time |
| Creating Charts |
| Creating a Chart |
| In Microsoft Excel , you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. |
| The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. |
| To create the column chart shown above, start by creating the worksheet below exactly as shown. |
 |
| After you have created the worksheet, you are ready to create your chart. |
| Create a Column Chart |
 |
| 1. Select cells A3 to D6. You must select all the cells containing the data you want in your chart. You should also include the data labels. 2. Choose the Insert tab. 3. Click the Column button in the Charts group. A list of column chart sub-types types appears. 4. Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear. |
| Move & Resize your Chart Sheet |
| By default, when you create a chart, Excel embeds the chart in the active worksheet. However, you can move a chart to another worksheet or to a chart sheet. A chart sheet is a sheet dedicated to a particular chart. By default Excel names each chart sheet sequentially, starting with Chart1. You can change the name. |
| Move a Chart to a Chart Sheet |
 |
| 1. Click your chart. The Chart Tools become available. 2. Choose the Design tab. 3. Click the Move Chart button in the Location group. The Move Chart dialog box appears. |
 |
| 4. Click the New Sheet radio button. 5. Type Toy Sales to name the chart sheet. Excel creates a chart sheet named Toy Sales and places your chart on it. |
| Change the Size and Position of a Chart |
 |
| 1. Use the handles to adjust the size of your chart. 2. Click an unused portion of the chart and drag to position the chart beside the data. |
| Modify a Chart |
| Any change you can make to a chart that is embedded in a worksheet, you can also make to a chart sheet. For example, you can change the chart type from a column chart to a bar chart. |
 |
1. Click your chart. The Chart Tools become available. 2. Choose the Design tab. 3. Click Change Chart Type in the Type group. The Chart Type dialog box appears. 4. Click Bar. 5. Click Clustered Horizontal Cylinder. 6. Click OK. Excel changes your chart type. |
 |
| Chart Styles & Layouts |
 |
1. Click your chart. The Chart Tools become available. 2. Choose the Design tab. 3. Click the Quick Layout button in the Chart Layout group. A list of chart layouts appears. 4. Click Layout 5. Excel applies the layout to your chart. |
| Change the Style of a Chart |
 |
| 1. Click your chart. The Chart Tools become available. 2. Choose the Design tab. 3. Click the More button in the Chart Styles group. The chart styles appear. |
 |
| 4. Click Style 42. Excel applies the style to your chart. |
| How to use Graphics in excel 2007 |
| Insert Image from File |
| To add a picture: |
. Click the Insert tab . Click the Picture button . Browse to the picture from your files . Click the name of the picture . Click Insert . To move the graphic, click it and drag it to where you want it |
 |
| Editing Pictures and Clip Art |
| When you add a graphic to the worksheet, an additional tab appears on the Ribbon. The Format tab allows you to format the pictures and graphics. This tab has four groups: |
| Adjust: Controls the picture brightness, contrast, and colors Picture Style: Allows you to place a frame or border around the picture and add effects Arrange: Controls the alignment and rotation of the picture Size: Cropping and size of graphic |
 |
| Adding Shapes |
| To add Shape: |
. Click the Insert tab . Click the Shapes button . Click the shape you choose |
 |
| . Click the Worksheet . Drag the cursor to expand the Shape |
 |
| To format the shapes: |
| . Click the Shape . Click the Format tab |
 |
| Inserting SmartArt |
| SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics, including flow charts, lists, cycles, and processes. To add SmartArt: |
. Click the Insert tab . Click the SmartArt button . Click the SmartArt you choose |
 |
| . Select the Smart Art . Drag it to the desired location in the worksheet |
| To format the SmartArt: |
| . Select the SmartArt . Click either the Design or the Format tab . Click the SmartArt to add text and pictures. |
 |
Post a Comment