Multiple Choice
All of the following statements are TRUE about an Excel database EXCEPT:
A) An Excel database is a way of storing data that is made up of records and fields.
B) In a database, each record is one unit of data.
C) All database functions are named using the format DBXXX() where XXX is the name of the corresponding nondatabase Excel function.
D) All database functions include the same three arguments.
Correct Answer:

Verified
Correct Answer:
Verified
Q20: The first argument of the AVERAGEIFS function
Q21: The _ function looks for a value
Q22: The _ functions provide added flexibility of
Q23: If letters appear for the column headings,the
Q24: Data that is manually calculated is known
Q26: Which of the following is NOT an
Q27: The IF function can employ other logical
Q28: A(n)_ allows you to break down potential
Q29: The _ function expands on the AVERAGEIF
Q30: If numbers appear for the column headings,the