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
You might also like to view...
What are some ways EFS keys may be lost?
What will be an ideal response?
When a range of cells is converted to a table, the default setting in the Filter gallery is ________
A) Select All B) Sort by Color C) Sort Smallest to Largest D) Sort Largest to Smallest
What is the 802.11ac technology that is used to direct transmission of the radio signal to a specific device?
A) Beamforming B) TIMO C) Spatial transfer D) CSMA/CA
Which of the following is NOT a part of the maintenance phase of the software life cycle?
a) correcting user-detected errors b) adding more features to the software c) proving the correctness of algorithms d) modifying existing features of the software to better suit the users