10 In cell D6, reference the named range Avg Magazine to return the value in cell D19 on the GuestData worksheet. Similarly, in cell D7, reference the named range Avg Radio. In cell D8, reference the named range Avg Television. In cell D9, reference the named range AvgInternet. 10 In cell D6, reference the named range Avg Magazine to return the value in cell D19 on the GuestData worksheet. Similarly, in cell D7, reference the named range Avg Radio. In cell D8, reference the named range Avg Television. In cell D9, reference the named range AvgInternet