Hyperlinks hare With the Summary worksheet active, insert a hyperlink in cell B2 to the range E2:E11 in the Qtr1 S - worksheet. With the Summary worksheet active, insert a hyperlink in cell C2 to the range E2:E11 in the Qtr2 worksheet With the Summary worksheet active, insert a hyperlink in cell D2 to the range E2:E11 in the Otr3 worksheet With the Summary worksheet active insert a hyperlink in call E2 to the range $2:off in the Click theme Move to Next QuestionIn cell B3, insert a relative reference to cell E3 on the Qtr1 worksheet. Use the fill handle to copy the formula through cell B10. Move to Next QuestionValidation Rule On the Qtr4 worksheet, create a validation rule for the range B5:D5 to allow decimal values that are between 12000 and 16000. Do not close the Data Validation dialog box. Create an input message using Food & Drink as the title text and Enter the monthly food and drink amount. (including the period as the input message. Do not close the Data Validation dialog box1.00 Point: XL Step 9.1.2: Enter and Share Format Data on Grouped Worksheets Group the Qtr1 through Qtr4 worksheets. Use AutoSum to simultaneously total the values of the data in the range B3:E11. Simultaneously format the ranges B3:E3 and B11:E11 using the Accounting Number Format. Type Monthly Sales in cell A11 Select cell A11, and then apply Bold 2 of 16 maining