E | Super Survey Maker

Write an Excel formula in Summary!C15 that can be copied down to Summary!C18, to determine the average total cost for each type of ad.

=SUMIF(Data!B$5:B$12,A15,I$4:I$11)/B$15

=AVERAGEIF(Data!B$5:B$12,A15,I$4:I$11)

=SUMIF(Data!B$5:B$12,A15,I$4:I$11)

=AVERAGEIF(I$4:I$11,A15,Data!B$5:B$12)

Write an Excel formula in Summary!C4 which can be copied down to Summary!C11, to determine the number of lines needed for each customer’s ad listed. Remember that symbols are considered “words” when considering the number of lines needed. Write your answer so that the result is rounded to the nearest whole number.

=ROUND(SUM(Data!E5,Data!G5)*B4,0)

=ROUND(SUM(Data!E5,Data!G5)/B4,0)

=ROUND(SUM(Data!E$5,Data!G$5)*B4,1)

=ROUND((Data!E$5*Data!G$5)/B4,0)

Write an Excel formula in Summary!K4 that can be copied down to Summary!K11, to determine the order for each customer based on the total cost of their ad. The customer with the highest total cost will be 1.

=RANK.EQ(K4,K$4:K$11, 0)

=RANK.EQ(I4,I4:I11, 1)

=RANK.EQ(K4,K4:K11, 1)

=RANK.EQ(I4,I$4:I$11, 0)

Write an Excel formula in Summary!J4 that can be copied down to Summary!J11, to determine True or False if the corresponding ad costs least of all ads.

=RANK.EQ(I4,I4:I11,1)=1

=I4=MIN($I4:$I11)

=I4=MIN(I$4:I$11)

MIN(I$4:I$11)

Which of the following Excel formulas can be used in Summary!D4 that can be copied down to Summary!D11, to determine the total cost of all the words. Do not forget that part of the cost for the words in an ad includes the base cost of every ad as well as the cost for each line. You do not need to factor in the number of days the ad will run in this calculation.

=Units!B$1+Units!B$2*C4

=SUM(Data!E5+Data!G5+Units!B1+Units!B2/C4)

=Data!E5+Data!G5+Units!B1+Units!B2+C4

=Units!$B1+Units!$B2*C4

Write an Excel formula in Summary!B4 which can be copied down to Summary!B11, to determine the number of words that can be placed in each line of the ad for each customer. Remember that the number of words that can fit on one line of an ad depends on the font size.

=IF(Data!D$5<14, Fonts!B$2, IF(Data!D$5<=22, Fonts!C$2, Fonts!D$2))

=IF(Data!D5<14, Fonts!B$2, IF(Data!D5<=22, Fonts!C$2, Fonts!D$2))

=IF(Data!D5>14, Fonts!B$2, IF(Data!D5>=22, Fonts!C$2, Fonts!D$2))

=IF(Data!D5>22, Fonts!B$2, IF(Data!D5>=14, Fonts!C$2, Fonts!D$2))

Which of the following Excel formulas can be used in Summary!H4 that can be copied down to Summary!H11, to determine the cost of an image which is measured in length only. You do not need to factor in the number of days the ad will run in this calculation.

=Data!K5*Units!$B3*Units!$B4

=Data!K5/Units!B$3*Units!B$4

=Data!K5*Units!B$3*Units!B$4*Data!C4

=Data!K5*Units!B$4

Write an Excel formula in Data!F17 to determine TRUE or FALSE if at least one pet ad and all personal ads have an image.

=AND(J5,J6,J12,OR(J9,J11))

=AND(J5,J6,J12,AND(J9,J11))

=OR(J5,J6,J12,OR(J9,J11))

=OR(J5,J6,J12,AND(J9:J11))

Which of the following Excel formulas can be used in Data!F16 to determine TRUE or FALSE if only pet ads, at least some of them, have color.

=NOT(AND(OR(I9, I11), OR(I5:I8,I10,I12)))

=AND(I9, I11, NOT(I5, I6, I7, I8, I10, I12))

=OR(AND(I9, I11), NOT(OR(I5:I8,I10,I12)))

=AND(OR(I9, I11), NOT(OR(I5:I8,I10,I12)))

Which of the following Excel formulas can be used in Data!F15 to calculate how many advertisers use font sizes that are in between 10-15(both inclusive)

=COUNTIFS(D5:D12, ">=10", D5:D12,"<=15")

=COUNT(AND(D5:D12>=10,D5:D12<=15)

=COUNTIFS(D5:D12, >=10,D5:D12,<=15)

COUNTIF(D5:D12, AND(“>=10”, “<=15"))

Write an Excel formula in Summary!F4 that can be copied down and across to Summary!G11, to determine the cost of bolding the title for each customer’s ad. When copied across this formula will calculate any additional costs for running the ad in color. You do not need to factor in the number of days the ad will run in this calculation.

=IF(Data!H5="TRUE", Data!H3,0)

=IF(Data!H$5, Data!H3,0)

=IF(Data!H5, Data!H$3,0)

=IF(Data!H5, Data!$H$3,IF(Data!H5="FALSE",0))

Write an Excel formula in Data!F14, that will calculate the total number of days to run the Personal type of Ad?

=COUNTIF(Summary!A15:A18,Summary!A15, Summary!B15:B18)

=SUMIF(B5:B12,Summary!A15, C5:C12)

=COUNTIF(C5:C12,Summary!A15)

=SUMIF(C5:C12,Summary!A15, B5:B12)

Which of the following Excel formulas can be used in Summary!E4 that can be copied down to Summary!E11, to determine the cost of the symbols used in the ad. Remember that the Symbols worksheet has the price for each of the symbols. You do not need to factor in the number of days the ad will run in this calculation.

=IF(Data!F5=Symbols!A2,Symbols!B2,IF(Data!F5=Symbols!A3,Symbols!B3, IF(Data!F5=Symbols!A4,Symbols!B4,0)))*Data!G5

=IF(Data!F5=Symbols!A$2,Symbols!B$2,IF(Data!F5=Symbols!A$3,Symbols!B$3, IF(Data!F5=Symbols!A$4,Symbols!B$4,0)))*Data!G5

=IF(Data!F5=Symbols!A$2,Symbols!B2,IF(Data!F5=Symbols!A$3,Symbols!B3, IF(Data!F5=Symbols!A$4,Symbols!B4,0)))*Data!G5

= IF(AND(Data!J3, Data!F5=Symbols!A$2, Symbols!B$2, IF(AND(Data!J3, Data!F5=Symbols!A$3, Symbols!B$3, IF(AND(Data!J3, Data!F5=Symbols!A$4, Symbols!B$4,0)))*Data!G5

Write an Excel formula in Summary!B15 that can be copied down to Summary!B18, to determine the number of ads for each type of ad.

=SUMIF(Data!B$5:B$12,A15,A15:A18)

=SUMIF(A15:A18,A15,Data!B$5:B$12)

=COUNTIF(Data!B$5:B$12,A15)

=COUNTIF(A15:A18,Data!B5)

E

More Quizzes