Excel Formulas and Functions For Dummies. Bluttman Ken
Чтение книги онлайн.

Читать онлайн книгу Excel Formulas and Functions For Dummies - Bluttman Ken страница 9

СКАЧАТЬ Enter a ).

      This ends the AVERAGE function.

      13. Press Enter.

Figure 1-27 shows the result of your nested function. Cell C14 has this formula: =AVERAGE(MAX(B4:B10),MAX(D4:D10)).

image

       Figure 1-27: Getting a result from nested functions.

      remember When you use nested functions, the outer function is preceded with an equal sign (=) if it is the beginning of the formula. Any nested functions are not preceded with an equal sign.

      tip You can nest functions up to 64 levels.

Chapter 2

      Saving Time with Function Tools

       In This Chapter

      ▶ Displaying the Insert Function dialog box

      ▶ Finding the function you need

      ▶ Using the Function Arguments dialog box

      ▶ Entering formulas and functions

      Excel has so many functions that it’s both a blessing and a curse. You can do many things with Excel functions – if you can remember them all! Even if you remember many function names, memorizing all the arguments the functions can use is a challenge.

      remember Arguments are pieces of information that functions use to calculate and return a value.

      Never fear: Microsoft hasn’t left you in the dark with figuring out which arguments to use. Excel has a great utility to help you insert functions, and their arguments, into your worksheet. This makes it a snap to find and use the functions you need. You can save both time and headaches, and make fewer errors to boot – so read on!

      Getting Familiar with the Insert Function Dialog Box

The Insert Function dialog box (shown in Figure 2-1) is designed to simplify the task of using functions in your worksheet. The dialog box not only helps you locate the proper function for the task at hand, but also provides information about the arguments that the function takes. If you use the Insert Function dialog box, you don’t have to type functions directly in worksheet cells. Instead, the dialog box guides you through a (mostly) point-and-click procedure – a good thing, because if you’re anything like me, you need all the help you can get.

image

       Figure 2-1: Use the Insert Function dialog box to easily enter functions in a worksheet.

      In the Insert Function dialog box, you can browse functions by category or scroll the complete alphabetical list. A search feature – you type a phrase in the Search for a Function box, click the Go button, and see what comes up – is helpful. When you highlight a function in the Select a Function box, a brief description of what the function does appears under the list. You can also click the Help on This Function link at the bottom of the dialog box to view more detailed information about the function.

      You can display the Insert Function dialog box in three ways:

      ✔ Click the Insert Function button on the Formulas Ribbon.

      ✔ On the Formula Bar, click the smaller Insert Function button (which looks like fx).

✔ Click the small arrow to the right of the AutoSum feature on the Formulas Ribbon, and select More Functions (see Figure 2-2). AutoSum has a list of commonly used functions that you can insert with a click. If you select More Functions, the Insert Function dialog box opens.

image

       Figure 2-2: The AutoSum button offers quick access to basic functions and the Insert Function dialog box.

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAQCAwMDAgQDAwMEBAQEBQkGBQUFBQsICAYJDQsNDQ0LDAwOEBQRDg8TDwwMEhgSExUWFxcXDhEZGxkWGhQWFxb/2wBDAQQEBAUFBQoGBgoWDwwPFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhYWFhb/wAARCAJEAkQDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAA
СКАЧАТЬ