Practice MidtermYour exam will not be this long.It will consist of approximately 6-8 questions.YOU SHOULD ALSO REVIEW THE CLASS LECTURE WORKSHEETS, COURSE NOTES, AND COURSESLIDES AS YOU ARE RESPONSIBLE FOR ALL THE MATERIAL WE HAVE COVERED TO DATE.Text Functions and Macros will not be covered on the Midterm.The “None Of” =Not(Or(….)) and “Only” =And…(Not(Or(…)))Constructs will not be covered on the Midterm.FunctionsAND(logical1, [logical2],…)AVERAGE(number1, [number2]…)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(criteria_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])IFERROR(value, value_if_error)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,[criteria_range2,criteria2],…)AVERAGEIFS(average_range,criteria_range1,criteria1, [criteria_range2,criteria]…)COUNTIFS(criteria_range1,criteria1, [criteria_range2,criteria2]…)Use cell references wherever possible. Failure to do so willresult in a loss of points.Page 1of 7

Problem DescriptionWay, way back when cavemen ruled the earth, cell phone charges were based on the number of calls and the number of minutes of each call. Let’s assume that you are back in that time era, and your first job out of Cave Man University is with a new cell phone carrier named, Excel Wireless. As a project manager, your job responsibilities included setting up an efficient and effective way to track customer phone usage as well as transforming that usage into a readable monthly statement that can be delivered to your customers. After weeks of learning how data usage will be tracked by the company, studying the