Question

1. 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)

1b. 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

1c. 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)

1d. 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)

1e. 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

1

b) median(C4:C51)

The command for calculating median is “median”

1b

b) ceiling,math

This is the command for rounding up. In the newer excel versions you can also use “roundup”

1c

c) sum(C40:C50)

The correct command is “sum” and the parameters do not have any hyphen in them.

1d

d) stdev(B12:B14)

The command for standard deviation is “stdev” and the ranges need to contain letter in the parameter

1e

c) var(B12:B24)

The variance command is “var” and the range is written as B12:B24