Editing Spreadsheet (section)

=== Functions ===
[[File:Functions in Excel.PNG|thumb|400px|Use of user-defined function ''sq(x)'' in [[Microsoft Excel]] ]]
Spreadsheets usually contain several supplied [[Function (mathematics)|functions]], such as arithmetic operations (for example, summations, averages, and so forth), trigonometric functions, statistical functions, and so forth. In addition there is often a provision for ''user-defined functions''. In Microsoft Excel, these functions are defined using [[Visual Basic for Applications]] in the supplied Visual Basic editor, and such functions are automatically accessible on the worksheet. Also, programs can be written that pull information from the worksheet, perform some calculations, and report the results back to the worksheet. In the figure, the name ''sq'' is user-assigned, and the function ''sq'' is introduced using the [[Visual Basic for Applications|''Visual Basic'']] editor supplied with Excel. ''Name Manager'' displays the spreadsheet definitions of named variables ''x'' & ''y''.