How does a nested function work? Provide an example

What will be an ideal response?


A nested function occurs when one function is embedded as an argument within another function. Each function has its own set of arguments that must be included. For example, =ROUND(AVERAGE(B2:B12),0)--the nested AVERAGE argument averages the range the ROUND argument rounds the result.

Computer Science & Information Technology

You might also like to view...

Show that the relation schemas produced by Algorithm 15.4 are in 3NF.

What will be an ideal response?

Computer Science & Information Technology

The more keyframes a movie contains, the smaller the file size.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Writer's ________ feature checks a document for mistakes in spelling, punctuation, writing style and word usage

Fill in the blank(s) with correct word

Computer Science & Information Technology

Name the six objects in an Access database and briefly describe the purpose of each one

What will be an ideal response?

Computer Science & Information Technology