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
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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started