Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

E

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)
=MAX(E5:E12)
=RANK(E5,E5:E12)
=LARGE(E5:E12,90)
=LARGE(E5,E12,1)
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)
{"name":"E", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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., 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., 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.","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

All about Calliann
11614
Manjaro Read 1 pages 5-7
4218
Common Entrance Mathematics Practice Test 56 (tklesson)
50250
Kitty or Puppy
1680
Inspirasian & Pride Trivia - Chinese History & Mythology + Iron Widow!
10521
Science
10595
ურიდიული სტატისტიკა II ვარიანტი
45220
Number quiz
210
Ava quiz. DO IT !
4219
Pop Quiz
840
Hygiene Habits
1050
Flow modelling
10514
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker