Question

6. Which of the following commands will compute the median of data stored in column C from rows 4 to 51?
(a) med(C4:C51) (b) median(C4:C51) (c) mid(C4:C51) (d) q50(C4:C51)

7. Which function will find the next highest integer of a given number? (For example, if the number is 3.12, the next highest integer is 4)
(a) round (b) ceiling.math (c) floor.math (d) rounddown

8. Which command in Excel will find the sum of values stored in column C from rows 40 to 50?
(a) summation(40:50) (b) sum(C:40-50) (c) sum(C40:C50) (d) summation(C:C)

9. Which equation in Excel will find the standard deviation of column B from rows 12 to 24?
(a) sd(12:24) (b) stdev(12:24) (c) std(B12:B24) (d) stdev(B12:B24)

10. Which equation in Excel will find the variance of column B from rows 12 to 24?
(a) variance(12:24) (b) var(12:24) (c) var(B12:B24) (d) var(12:14)

Answer 1

Questions	Answer	Explanation
6. Which of the following commands will compute the median of data stored in column C from rows 4 to 51?	Correct Answer is (b) median(C4:C51)	As using the function Median and we will write “=MEDIAN(C4:C51)” in the cell of MS Excel Sheet, we can compute the median of data stored in column C from rows 4 to 51
7. Which function will find the next highest integer of a given number? (For example, if the number is 3.12, the next highest integer is 4)	Correct Answer is (b) ceiling.math	As this function can round a number up either to the nearest Integer or to the nearest multiple of significance, thus CEILING.MATH Function is useful for finding the next highest integer of a given number
8. Which command in Excel will find the sum of values stored in column C from rows 40 to 50?	Correct Answer is (c) sum(C40:C50)	As, using the Function SUM, we will use in the way like “=SUM(C40:C50)” in any cell of the MS Excel sheet to get the sum of values stored in column C from rows 40 to 50
9. Which equation in Excel will find the standard deviation of column B from rows 12 to 24?	Correct Answer is (d) stdev(B12:B24)	As, using the Function STDEV, we will use in the way like “=STDEV(B12:B24)” in any cell of the MS Excel sheet to find the standard deviation of column B from rows 12 to 24
10. Which equation in Excel will find the variance of column B from rows 12 to 24?	Correct Answer is (c) var(B12:B24)	As, using the Function VAR, we will use in the way like “=VAR(B12:B24)” in any cell of the MS Excel sheet to find the Variance of column B from rows 12 to 24