BUSINESS DATA ANALYSIS PRACTICE EXAM 1
PREP QUESTIONS WITH 100% CORRECT
ANSWERS
a) If you copy =(A$5+$G6)/$A$1 from cell C3 to cell J2, what will it read? - ANS-=(H$5+$G5)/$A$1
b) You have entered =SUM(A1:A30) into cell C6. If you delete row 1, what will the formula read? - ANS-
=SUM(A1:A29)
c) Columns C through F of my class roster workbook contain students' scores on lab exercises 1 through
4. In G2, I have the formula =RANK(C2,C2:C18,0) to determine the placement of the first student's score
on LE1. What should the formula be in order to copy it successfully for all students and all lab exercises
(in columns G through J)? - ANS-=rank(C2,C$2:C$18,0)
d) Cells B1:U1 contain the numbers 1 through 20 as do A2:A21. At the intersection, we would like to
compute the product of the row and column. Write the formula for cell B2 that can be copied through
the entire range. - ANS-=product($A2,B$1)
e) What will be the result of copying =SUM($A11:C11)/A$1 from cell B14 to cell D14? - ANS-
=sum($A11:E11)/C$1
a) Count the cells in a column with values greater than 5 - ANS-countif
b) Determine the most frequently occurring observation in a specified range - ANS-mode
c) Average the scores of all students who are MIS majors - ANS-averageif
d) Find the second smallest number in a list - ANS-small
e) Determine the position of a student's final score in the class, i.e., 1st ... 36th - ANS-rank
f) Obtain a number at a specified precision level below the given/computed number - ANS-rounddown
simulate the labor cost per minute, which is expected to vary between $.045 and $0.55, with an
indeterminate number of decimal place - ANS-rand
average scores of all students who are mis majors and have completed an intership - ANS-averageifs
PREP QUESTIONS WITH 100% CORRECT
ANSWERS
a) If you copy =(A$5+$G6)/$A$1 from cell C3 to cell J2, what will it read? - ANS-=(H$5+$G5)/$A$1
b) You have entered =SUM(A1:A30) into cell C6. If you delete row 1, what will the formula read? - ANS-
=SUM(A1:A29)
c) Columns C through F of my class roster workbook contain students' scores on lab exercises 1 through
4. In G2, I have the formula =RANK(C2,C2:C18,0) to determine the placement of the first student's score
on LE1. What should the formula be in order to copy it successfully for all students and all lab exercises
(in columns G through J)? - ANS-=rank(C2,C$2:C$18,0)
d) Cells B1:U1 contain the numbers 1 through 20 as do A2:A21. At the intersection, we would like to
compute the product of the row and column. Write the formula for cell B2 that can be copied through
the entire range. - ANS-=product($A2,B$1)
e) What will be the result of copying =SUM($A11:C11)/A$1 from cell B14 to cell D14? - ANS-
=sum($A11:E11)/C$1
a) Count the cells in a column with values greater than 5 - ANS-countif
b) Determine the most frequently occurring observation in a specified range - ANS-mode
c) Average the scores of all students who are MIS majors - ANS-averageif
d) Find the second smallest number in a list - ANS-small
e) Determine the position of a student's final score in the class, i.e., 1st ... 36th - ANS-rank
f) Obtain a number at a specified precision level below the given/computed number - ANS-rounddown
simulate the labor cost per minute, which is expected to vary between $.045 and $0.55, with an
indeterminate number of decimal place - ANS-rand
average scores of all students who are mis majors and have completed an intership - ANS-averageifs
