![]() If you want to average the sales of each clothes from January to August. If the averaging result rounds up to too many decimal places, you can press Ctrl + 1 to open the "Format Cells" dialog, select the "Number" tab, and then select the "Number" on the left, enter the number of decimal places on the right of "Decimal Places", and click "OK". Tip: If you drag down, the cells that have passed does not become the average of the corresponding month, press Ctrl + S to save, they will be updated to the average of the corresponding row. The average formula =AVERAGE(B2:H2) automatically fill in the F2, press Enter to find the average of all types of clothing in January move the mouse to the cell fill handle in the lower right corner of F2, double cliick after the mouse changes to the bold black plus, then the remaining cells automatically finds the averages of the clothing sales of the corresponding month the operation process steps are as shown in Figure 1:Ģ. ![]() Select the cell F2, select the "Formula" tab, click the down arrow under "AutoSum" in the upper left corner of the screen, and select Average in the pop-up menu. If you want to average the sales of various types of clothing every month. I, How to calculate average in excel(Use options to find)ġ. When calculating average, you can calculate only one row, one column, or one range of cells at a time, or you can quickly calculate multiple rows or columns or multiple ranges of cells including discrete at one time in batches When calculating average in batches, you need to use shortcut keys to achieve. It is not so convenient to press, but after the familiarity, the speed is not slow. Average with the shortcut keys, you need to press four keys, and you need to press and hold a key, and then press the other three keys in sequence, which is more than two keys for the sum shortcut. ![]() How to find average in excel? There are two ways to average in e xcel, one is to use the averaging option, and the other is to use the averaging shortcut. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |