Using formulas in tables MCQs (calculations) – PowerPoint

Which PowerPoint formula is used to calculate the sum of a range of cells in a table?A) =SUM(range)
B) =TOTAL(range)
C) =ADD(range)
D) =SUMPRODUCT(range)
Answer: A) =SUM(range)
To calculate the average of numbers in a table cell range, which formula would you use?A) =MEAN(range)
B) =AVERAGE(range)
C) =MEDIAN(range)
D) =SUM(range)/COUNT(range)
Answer: B) =AVERAGE(range)
What formula calculates the highest value in a range of cells?A) =MAX(range)
B) =HIGHEST(range)
C) =TOP(range)
D) =LARGE(range)
Answer: A) =MAX(range)
Which formula would you use to find the smallest value in a cell range?A) =MIN(range)
B) =LOWEST(range)
C) =SMALLEST(range)
D) =MINIMUM(range)
Answer: A) =MIN(range)
To count the number of cells that contain numbers within a specified range, which formula is used?A) =COUNT(range)
B) =NUMCOUNT(range)
C) =COUNTS(range)
D) =COUNTIF(range)
Answer: A) =COUNT(range)
What formula is used to calculate the sum of values that meet a certain condition in a table?A) =SUMIF(range, criteria, sum_range)
B) =SUM(range, condition)
C) =TOTALIF(range, criteria)
D) =ADDIF(range, criteria)
Answer: A) =SUMIF(range, criteria, sum_range)

To calculate the number of cells that meet a specific criterion in a range, which formula would you use?A) =COUNTIF(range, criteria)
B) =SUMIF(range, criteria)
C) =COUNT(range, criteria)
D) =FILTER(range, criteria)
Answer: A) =COUNTIF(range, criteria)
Which formula would you use to calculate the product of values in a specified range?A) =MULTIPLY(range)
B) =PRODUCT(range)
C) =PRODUCE(range)
D) =SUMPRODUCT(range)
Answer: B) =PRODUCT(range)
To calculate the percentage change between two values, which formula is used?A) =(New Value – Old Value) / Old Value * 100
B) =PERCENTCHANGE(New Value, Old Value)
C) =CHANGE(New Value, Old Value)
D) =DIFFERENCE(New Value, Old Value)
Answer: A) =(New Value – Old Value) / Old Value * 100
What formula would you use to find the standard deviation of a range of values?A) =STD(range)
B) =STDEV(range)
C) =DEVIATION(range)
D) =VAR(range)
Answer: B) =STDEV(range)

To find the median of a set of numbers in a table, which formula should be used?A) =MEDIAN(range)
B) =MID(range)
C) =MEAN(range)
D) =CENTRAL(range)
Answer: A) =MEDIAN(range)
Which formula calculates the sum of products of corresponding values in two ranges?A) =SUMPRODUCT(range1, range2)
B) =MULTIPLY(range1, range2)
C) =SUM(range1 * range2)
D) =PRODUCTSUM(range1, range2)
Answer: A) =SUMPRODUCT(range1, range2)

Using formulas in tables MCQs (calculations) – PowerPoint
By: Prof. Dr. Fazal Rehman Shamil | Last updated: July 30, 2024