Match the following terms to their meanings:

I. Statistical function
II. Logical function
III. Lookup function
IV. Nested function
V. Array formula

A. used to describe a collection of data such as totals, counts, and averages
B. used to find values that are stored in lookup tables
C. a function that is placed inside another function
D. can perform calculations across multiple items
E. used to create formulas that test whether a condition is true or false

Answer: A, E, B, C, D

Computer Science & Information Technology

You might also like to view...

Which of the following BEST describes the reason a network administrator would task a technician with replacing a hub with a switch?

A. The hub did not provide PoE B. The hub had too many collisions C. The hub was out of ports D. The hub had a bad port

Computer Science & Information Technology

Alice's Vehicle property lets us synchronize the movements of two objects.

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

Computer Science & Information Technology