tailieunhanh - A Guide to Microsofl Excel 2002 for Scientists and Engineers phần 3

, thống kê, ngày tháng và thời gian, cơ sở dữ liệu, tra cứu thông tin, tài chính, và tham khảo, và văn bản. Ngoài ra, người dùng có thể xây dựng người dùng định nghĩa (tùy chỉnh) chức năng - xem Chương 8. Giả sử bạn muốn biết giá trị của Đăng nhập (3). | 4 Using Functions Concepts Note The Analysis ToolPak add-in is required for the Engineering functions to be available. Microsoft Excel provides over 300 worksheet functions which are divided into 10 groups mathematical and trigonometric engineering logical statistical date and time database financial informational lookup and reference and text. In addition the user may construct user-defined custom functions - see Chapter 8. Suppose you wish to know the value of Log 3 . We call 3 the argument of the function. It is the value that is used by the function to compute the required quantity. Some functions take more than one argument. We say that a function returns a value. The syntax of a function are the rules for its use. Figure illustrates a formula using a function. The MAX function returns the value of the largest argument. The formula in the figure will return the larger of the value in Al one of the values in the range B1 B8 or the constant value 10. In this example the arguments are a cell reference a range reference and a constant. Equal sign when function begins formula Function name Ị Argument list ị Y V MAX A1 10 Commas separate each argument . . Arguments are enclosed in parentheses No space is permitted between the name and the opening parenthesis Figure 56 A Guide to Microsoft Excel 2002for Scientists and Engineers Depending on the function the number of arguments may be fixed variable or even zero. For example zero arguments one argument two arguments variable number PI SQRT A2 or SQRT A2 2 ROUND A2 2 SUM A1 A10 or SUM A1 A10 B3 B4 When the number of permitted arguments is variable the maximum number is 30 and the number of characters may not exceed 1024. Note that a range such as Al A100 counts as one argument not 100. While some functions require specific types of arguments most functions permit an argument to be a cell reference a range reference a constant an expression or another function. Certain functions require text type arguments