#Tutorial on how to use microsoft excel 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.