COS 211 Lecture 11: COS213Assg11
16 Feb 2016
School
Department
Course
Professor
Document Summary
Papers should be left in the drop box outside 131 neville. In the last step of the macro the macro writer clicks in cell a1. When this macro executes from any cell in the workbook it will always select cell a1 as the last step: true, false. 1: a user-defined function is shown below. It is passed the grams of fat in a food item and returns the number of calories associated with the value. There are 9 calories per gram of fat. End function: the result of function call: =fatcalories(5) is value 45, the fatcalories function has one parameter so must be passed one argument value, assume cell a1 is empty and cell a2 contains formula =fatcalories(a1). The fatcalories function returns an error: the user could click in cell a1 of a worksheet, issue the insert function command and select the. Fatcalories function from the user-defined category: a user-defined function is shown below.
