Quiz 4- Sample Multiple Choice Questions for Exam 1

10

Given the worksheet entries shown below, what value will be returned by the function? =IF(SUM(A2:A4)>100, MAX(A1:A4), MIN(A1:A4))

C19*$E$4+F22

If you copy the formula from cell E10 to cell D19, the formula in cell D19 will be: **Refer to picture**

=IF(D2<$D$13,D2*C2,C2*$D$13)

Refer to the figure shown below, what formula should you enter in cell E2 in order to compute the employees regular pay which is calculated as regular hours worked multiplied by the hourly wage? The number of regular hours worked does not appear explicitly in the worksheet, but is calculated from the total hours worked and the overtime threshold specified in cell D13. Specify the formula in cell E2 in such a way that it can be copied to the other employee records, cells E3 through E8. **Refer to phone for picture for spreadsheet** =IF(D2<$D$13,D2*C2,C2*$D$13) =IF(D2<40,D2*C2,C2*$D$13) =(D2-$D$13)*C2

=SUM(E2:F2)

Refer to the figure shown below, what formula should you enter in cell G2 to calculate Gross Pay which is the regular pay plus the overtime pay? Specify the formula in cell G2 in such a way that it can be copied to the other employee records, cells G3 through G8. ** Refer to phone for picture for spreadhseet =SUM($E$2:$F$2) =TOTAL(E2:F2) =SUM(E2:F2) =TOTAL($E$2:$F$2)

$C$8*D7

Referring to the following worksheet, if you copy the formula from cell A10 to cell C5, the formula in cell C5 will be: **Refer to picture** =$C$8*B12

2

Referring to the following worksheet, what value will be returned by the COUNT function in cell A6? Sammy 20 James 40 =COUNT(A1:A4)

4

Referring to the following worksheet, what value will be returned by the COUNTA function in cell A6 Sammy 20 James 40 =COUNTA(A1:A4)

102

Referring to the following worksheet, what will be the result of the formula typed into cell A7? 20 2 30 4 40 8 50 100 =SUM(A3:A4,MIN(A1:B2),10)

400

Referring to the following worksheet, what will be the result of the formula typed into cell A8, that is =IF((A4+A5/B1)>70,A1^B1,A3*B2): A | B 1 | 20 2 2 | 30 4 3 | 40 5 4 | 50 5 | 60

no

Referring to the following worksheet, what will be the result of the formula typed into cell A8, that is: =IF((A1*B1)>A3,"yes","no") 20 2 30 4 40 5 50 60

60

Referring to the following worksheet, what will be the result of the formula typed into cell B7, that is: =MAX(SUM(A1:A2), SUM(A3:B3)) 20 2 40 3 50 5 200

40

Referring to the following worksheet, what will be the result of the formula typed into cell B7, that is: = A4-A2*B1*(B3-B2) 20 2 40 3 50 5 200

600

Referring to the following worksheet, what will be the result of the formula typed into cell F2, that is: **Refer to picture** =VLOOKUP(E2,$A$2:$C$4,3)

HLOOKUP(WEEKDAY(TODAY()),$A$1:$G$2,2)

Referring to the following worksheet, which of the following formulas shows the correct way to determine what day of the week it is today? **Refer to picture**

=PMT(VLOOKUP(C6,$A$18:$C$20,2)/12,C6*12,-E6)

What formula should be entered into the worksheet to calculate the monthly payment in cell F6 **Refer to picture**

140

What will be the result of the formula typed into cell A7, that is: =A3+A4*B1 20 2 30 4 40 8 50 100

Refer to Picture for Answer... Pivot Table Filters

Which layout procedures the following PivotTable? **Refer to Picture**

Refer to picture for answer.

Which layout produces the following Pivot Table **Refer to Picture**

=PMT(.05/12,36,-10000)

Which of the following computes the monthly payment for a car loan of $10,000 that is amortized over 3 years at 5%? =PMT(.05,36,-10000) =PMT(.05,3,-10000) =PMT(.05/12,36,-10000) =PMT(.05,3,10000)

=VLOOKUP(A4,$A$16:$C$18,3,FALSE)*C4

Which of the following is the correct formula to enter in cell D4 **Refer to picture**