Midterm A - CSE 2111 Midterm A\/250 Functions AND(logical1[logical2 AVERAGE(number1[number2 AVERAGEIF(range criteria[average_range COUNT(value1[value2

Midterm A - CSE 2111 Midterm A/250 Functions...

This preview shows page 1 - 3 out of 5 pages.

CSE 2111 Midterm A ________/250 Functions AND(logical1, [logical2],…) AVERAGE(number1, [number2]…) AVERAGEIF(range, criteria, [average_range]) COUNT(value1, [value2],…) COUNTIF(range, criteria) RANK.EQ(Number, Ref, [Order]) ROUND(number,num_digits) SMALL(array, k) LARGE(array, k) SUM(number1, [number2],…) SUMIF(range, criteria, [sum_range]) AVERAGEIF(range, criteria, [average_range]) MAX(number1, [number2],…) MIN(number1, [number2],…) NOT(logical) OR(logical1, [logical2],…) FV(rate, nper, pmt, [pv], [type]) NPER(rate, pmt, pv, [fv], [type]) PMT(rate, nper, pv, [fv], [type]) PV(rate, nper, pmt, [fv], [type]) RATE(nper, pmt, pv, [fv], [type]) IF(logical_test,[value_if_true],[value_if_false]) HLOOKUP(lookup_value, table_array, row_index_no,[ range_lookup_type]) VLOOKUP(lookup_value, table_array, col_index_no, [range_lookup_type]) SUMIFS(sum_range,criteria_range1,criteria1,…) AVERAGEIFS(average_range,criteria_range1,criteria1,…) COUNTIFS(criteria_range1,criteria,…) Page 1
CSE 2111 Midterm A PROBLEM DESCRIPTION You work in the advertising department of the local newspaper. It is your job to collect the information for each ad that has been purchased. You have entered each ad onto the Data and Answers worksheets. The Data worksheet includes the following: the name of the person placing the ad (column A) type of the ad (column B)- personal, pet, car or home number of days the ad will run (column C) font size for each ad (column D) number of words per ad (column E) symbols types, if any, that are used (column F) – only one type of symbol/ad is allowed number of symbols used in the ad (column G) whether or not the customer wants to bold the title (column H)- bolding the title costs $2.00 per ad per day (cell Data!H3 ) whether of not the ad uses colored ink (column I)- using colored ink for the ad costs $10.00 per ad per day (cell Data!I3 ) whether or not the ad includes an image (column J) – only one image allowed per ad the length in inches of the image (column K) The Answers worksheet is where you will calculate the costs for the ads your clients are purchasing.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture