1Pick a category for functions (do not use \"Most Recently Used\" or \"All\"). 2
ID: 3877065 • Letter: 1
Question
1Pick a category for functions (do not use "Most Recently Used" or "All").
2Pick a function in that category.
3The function chosen must be different than any function presented in the lesson, and must use standard syntax for functions. Standard syntax is comma separated syntax. This means you CANNOT use SUM( ) or AVERAGE( ) or one of the other functions that use a range. Make sure you read the entire help on a function to ascertain that it cannot accept a range as an input. The purpose of this restriction is to force students to search for a function new to them and learn how to use it by substituting actual parameter (or values) for formal parameters (or place holders).
4Create a function call in one cell that strictly uses constants as the arguments.
5Create a function call in a separate cell that strictly uses cell references as the arguments.
6Create a function call in a third cell that generates a syntax error.
7Explain in part of your spreadsheet file (e.g. in a "merged" cell):
8Exact name of the category you chose (do not use "Most Recently Used" or "All").
9Give the complete syntax diagram of the function of your choice, e.g. LOG(number,[base]) including any optional or repeating parts.
10Identify where each of the three required features (use of constants, use of references, generation of syntax error) are used in your spreadsheet. Make sure you give the cell identifier of the function call (e.g. don't give the cell identifier for the constant).
Explanation / Answer
Dear student,
I have given some basic examples here, that are given in c#, but mostly the function calls are same for most of the languages.
Please use them in the format you want.
Create a function call in one cell that strictly uses constants as the arguments.
static class Constants //class that defines constants
{
public const double Pi = 3.14159;
public const int SpeedOfLight = 300000; // km per sec.
}
class Program
{
static void Main()
{
double radius = 5.3;
double area = Constants.Pi * (radius * radius); //accessing the constant values
int secsFromSun = 149476000 / Constants.SpeedOfLight; // in km
}
}
=============================================================================================
Create a function call in a separate cell that strictly uses cell references as the arguments.
class Program
{
static void Main(string[] args)
{
int arg;
// Passing by reference.
// The value of arg in Main is changed.
arg = 4;
squareRef(ref arg);
Console.WriteLine(arg);
// Output: 16
}
// Passing by reference
static void squareRef(ref int refParameter)
{
refParameter *= refParameter;
}
}
=======================================================================================
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.