Please answer b,c,d 27123456768891011121314151617AMinimum Sales Made$555$B$5,000.0010,000.00NameRyanAndyStanleyPhyllisJimDwightMichaelPamKarenCreed$$$$$Ssssssssss$$$$$CReward LevelBronzeSilverGoldTotal Sales Made3,800.005,000.006,000.007,500.0012,000.0014,500.0010,000.00300.008,500.00200.00SSS$$$DAverage (AVERAGEIF)1,433.336,750.0012,166.67Reward Level (IF/AND)BronzeSilverSilverSilverGoldGoldGoldBronzeSilverBronzeECount (COUNTIF)343Reward Level (VLOOKUP)BronzeSilverSilverSilverGoldGoldGoldBronzeSilverBronzeUse the above spreadsheet for the following questions a, b, c, and d.a) Create a formula in cell D8 that uses the IF and AND functions. The formula willdetermine each Reward Level based on the possible Rewards and accompanyingminimum sales made. You should be able to autofill down through cells D8:D17.b) Create a formula in cell E8 that uses the VLOOKUP function with the tablearray $B$3:$C$5. The formula will determine each customer membership statusbased on the possible reward levels and accompanying minimum sales made. Youshould be able to autofill down through cells E8:E17.c) Create a formula in cell D3 that uses the AVERAGEIF function. The formula willdetermine the average of the total sales made for each reward level. You should beable to autofill down through cells D3:D5.d) Create a formula in cell E3 that uses the COUNTIF function. The formula willdetermine the amount of salespeople in each Reward Level. You should be able toautofill down through cells E3:E5.

SOLUTION - AverageIF(): =AVERAGEIF($D$8:$D$17,C2,$C$8:$C$17) This function calculates the average of…

b) Create a formula in cell E8 that uses the VLOOKUP function with the table array $B$3:$C$5. The formula will determine each customer membership status based on the possible reward levels and accompanying minimum sales made. You should be able to autofill down through cells E8:E17. c) Create a formula in cell D3 that uses the AVERAGEIF function. The formula will determine the average of the total sales made for each reward level. You should be able to autofill down through cells D3:D5. d) Create a formula in cell E3 that uses the COUNTIF function. The formula will determine the amount of salespeople in each Reward Level. You should be able to autofill down through cells E3:E5.

b) Create a formula in cell E8 that uses the VLOOKUP function with the table array $B$3:$C$5. The formula will determine each customer membership status based on the possible reward levels and accompanying minimum sales made. You should be able to autofill down through cells E8:E17. c) Create a formula in cell D3 that uses the AVERAGEIF function. The formula will determine the average of the total sales made for each reward level. You should be able to autofill down through cells D3:D5. d) Create a formula in cell E3 that uses the COUNTIF function. The formula will determine the amount of salespeople in each Reward Level. You should be able to autofill down through cells E3:E5.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

For the following regular expression, find the equivalent NFA and then convert that NFA to a DFA: (a*ab*bc*)*
Binary numerals are used to assign each item in a store's inventory a distinct binary sequence. What is the minimum number of bits required for each binary sequence if the store has between 75 and 100 items in stock?
Given the following notations,evaluate given Prefix notation : *-50 -* 2 +2 3 * 5 4 2
Coordinates : A(2,0) B(2,2) C(2,5) D(0,5) E(0,2) F(0,0) Assume a custom Q6 isoparametric. Compute N, J11, J21, B in isoparametric format. (1)
Answer me number three please don't use ChatGPT it didn't gave me the right answer thank you
Provide an example of the use of the arithmetic operators and describe how they work.
Please provide an illustration of what we mean by "coding conventions."
Q) perform all operation
QUESTION Write a C program (“01.c") that can be entered some integer numbers (at least 3 integers) and calculates the given below. Use only loops and conditional statements. Also do not use arrays, matrix, any library functions and so on. If -1 is entered, the program must be terminated and number -1 must be excepted from all calculations. Sum of all numbers Average Minimum Second minimum Third minimum Sample Outputs Enter some numbers until -1 entered 3 Enter some numbers until -1 entered 7 -1 Sum of all numbers: 15 Average: 5.00 Minimum is: 3 Second Minimum is: 5 Third Minimum is: 7 -1 Sum of all numbers: 18 Average: 3.60 Minimum is: 1 Second Minimum is: 2 Third Mini mum is: 3 Enter some numbers until -1 entered Enter some numbers until -1 entered -1 Sum of all numbers: 26 Average: 5.20 Minimum is: 4 Second Minimum is: 5 Third Minimum is: 6 Sum of all numbers: 41 Average: 4. 56 Minimum is: 1 Second Minimum is: 2 Third Minimum is: 3
Write the decimal numbers from 10 to 15 in base 3. and explain every step, please