Excel 2007 tutorial 11 series#

That appears at the bottom of every page of your printed worksheet. You can use the Header & Footer button on the Insert tab to create headers and footers.ДЄ header is text that appears at the top of every page of your printed worksheet. The cells fill in as a series: Lesson 1, Lesson 2, Lesson Here is another interesting fill feature.Д®1 to E14. Click the down arrow next to the number format box.Press Esc and then click anywhere on the worksheet to remove the.Note that each cell fills, using military time. Grab the fill handle and drag with your mouse to highlight cellsД¬1 to C14.The Column adjusts to fit the longest entry.ДЄfter you complete the remainder of the exercise, your worksheet will look like the one shown here. Move your mouse pointer over the line that separates column B and C.YouД¬an quickly adjust the column width to fit the longest entry. Some of the entries in column B are too long to fit in the column. Choose the Fill Weekdays radio button.

Excel 2007 tutorial 11 series#

The cells fillДЄs a series from Sunday to Saturday, but the entries are not bolded.

Choose the Fill Without Formatting radio button.

Click the Auto Fill Options button again.

Note that the Auto Fill Options button appears. Note how the days of the week fill the cells in a series.

Grab the fill handle and drag with your mouse to fill cells A1 toД«14.

The small black square is called the fill handle.

Find the small black square in the lower-right corner of the selectedДЄrea.

EXERCISE 2 Fill CellsДЇollowing demonstrates filling the days of the week: You can use Microsoft Excel to fill cells automatically with a series.ДЇor example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series. The number of items in the series, which is 3, appears. The guess is incorrect, so you must select the proper cells. Excel places the count function in cell C9 and takes a guess at which cells you want to count.

Press the right arrow key to move to cell B9.

You can use the count function to count the number of numbers in a series. The highest number in the series, which is 27, appears.

Press the right arrow key to move to cell B8.

You can use the MAX function to find the highest number in a series Note: You can also use the drop-down button next to the AutoSum button to calculate minimums, maximums, and counts. The lowest number in the series, which is 12, appears.

Press the right arrow key to move to cell B7.

You can use the MIN function to find the lowest number in a series of The average of cells C1 to C3, which is 100, appears. Click the down arrow next to the AutoSum button.In Microsoft Excel, you can use the AutoSum button to calculate an average. The average of cells B1 to B3, which is 21, appears.Д¬alculate an Average with the AutoSum Button Press the right arrow key to move to cell B6. You can use the AVERAGE function to calculate the average of a series ДЄs you learned in Lesson 2, you can also calculate a sum by using the

Click the down arrow next to the Borders button.

The sum of cells C1 to C3, which is 300, appears.

Type C1:C3 in the Number1 field, if it does not automatically.

The Function Arguments dialog box appears.

Click Sum in the Select A Function box.

Choose Math & Trig in the Or Select A Category box.

The sum of cells B1 to B3, which is 63, appears.ДЄlternate Method: Enter a Function with the Ribbon Excel will complete the function name and enter the first parenthesis. You can double-click on an item in the AutoComplete list to complete your entry quickly. For example, arguments specify the numbers or cells you want to add.ДЄfter you type the first letter of a function name, the AutoComplete list appears. Arguments are values on which you want to perform the calculation. When using a function, remember the following: Not the operators, such as +, -, *, or /. Understanding FunctionsДЇunctions differ from regular formulas in that you supply the value but The referenceДЄ7,B8:B10,C9,10 refers to cells A7, B8 to B10, C9 and the number 10. A union referenceД¬onsists of two or more numbers, range references, or cell addresses separated by a comma. The referenceДЄ1:C3 includes cells A1, A2, A3, B1, B2, B3, C1, C2, and C3.ДЄ union reference includes two or more references. The reference A1:A3 includes cells A1, A2, and A3. A range reference consists of two cell addresses separatedД«y a colon. Types of reference operators: range and union.ДЄ range reference refers to all the cells between and including the Reference operators refer to a cell or a group of cells. To use functions, you need to understand reference operators.