In VBA define a function named spaghetti, where spaghetti - (x + 8). Variable x must...

 

Transcribed Image Text:

In VBA define a function named spaghetti, where spaghetti - (x + 8)". Variable x must be taken as integers and the output of function spaghetti should be an integer. (15%) (a) If farfalle is a function of variables a and b, and is saved in an excel workbook called book1, how do you call function farfalle in another excel workbook? (15%) (b) (c) we define function linguine and fusilli in VBA as follows Function linguine(x) M = x * 10 linguine - fusilli(M) End Function Function fusilli(y) fusilli - y + 2 End Function What are the values of linguine(5.5) and fusilli(9)? Show your essential calculations. (40%) (d) We define function penne in VBA as follows Option explicit Function penne (p As integer) If p<= 10 Then penne - p^2 Elseif p <= 20 Then penne - (p ^ 10) + 2 Elseif m <= 30 Then penne - p * 2 + 10 Else penne = 10 * (p ^ 2) End If End Function What are the values of penne(15.8) and penne(52)? Show your essential calculations. (30%) In VBA define a function named spaghetti, where spaghetti - (x + 8)". Variable x must be taken as integers and the output of function spaghetti should be an integer. (15%) (a) If farfalle is a function of variables a and b, and is saved in an excel workbook called book1, how do you call function farfalle in another excel workbook? (15%) (b) (c) we define function linguine and fusilli in VBA as follows Function linguine(x) M = x * 10 linguine - fusilli(M) End Function Function fusilli(y) fusilli - y + 2 End Function What are the values of linguine(5.5) and fusilli(9)? Show your essential calculations. (40%) (d) We define function penne in VBA as follows Option explicit Function penne (p As integer) If p<= 10 Then penne - p^2 Elseif p <= 20 Then penne - (p ^ 10) + 2 Elseif m <= 30 Then penne - p * 2 + 10 Else penne = 10 * (p ^ 2) End If End Function What are the values of penne(15.8) and penne(52)? Show your essential calculations. (30%)

Answer rating: 100% (QA)

a Function spaghettix y spaghetti x 8 y End Function Outpu... View the full answer