Multiple Choice
Use the data given below to answer the following question(s) .
Following is an extract from the Employee Payroll Database of HFR Informatics Inc.
-The Excel 2010 function ________ computes the kᵗʰ percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.
A) PERCENTILE.INC(array, k)
B) PERCENTILE(array + k)
C) PERCENTILE.IF(array, k)
D) PERCENTILE(SUM(array) , k)
Correct Answer:

Verified
Correct Answer:
Verified
Q5: Construct a PivotChart to visualize the purchase
Q6: Which of the following relies on sorting
Q27: Use the data given below to
Q28: How does Excel distinguish between vertical and
Q29: Use the data given below to
Q35: How is a frequency distribution calculated for
Q41: To select a chart type in Excel
Q42: Use the data given below to answer
Q46: Use the data given below to
Q49: Use the data given below to