Critical Thinking QuestionsCase 2-1Camashaly needs to gather some additional statistics on its clients. An employee at Camashaly has created an initial query as shown in the accompanying figure that calculates the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. 
Which aggregate function will count the number of records?
What will be an ideal response?
COUNT
Computer Science & Information Technology
You might also like to view...
To display the Conditional Formatting dialog box, you click the Conditional button in the ________ group of the Design tab
A) Format B) Arrange C) Font D) Tools
Computer Science & Information Technology
A(n) label is text that describes data in a worksheet.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
To sort customer records into numerical order by the amount ordered field, use the ________ button
Fill in the blank(s) with correct word
Computer Science & Information Technology
Why is the syntax of an Excel Function important? How can you distinguish between required and optional portions of a function?
What will be an ideal response?
Computer Science & Information Technology