Write a switch statement that tests the value of the char variable response and performs the following actions: if response is y, the message your request is being processed is printed if response is n, the message you anyway for your consideration is printed if response is h, the message sorry, no is currently available is printed for any other value of response, the message invalid entry; try again is printed

Following is the C++ code using switch statement.

#include <iostream>

using namespace std;

int main() {

char response;//response variable of type char..

cout<<"Enter the response"<<endl;

cin>>response;//taking input...

switch(response)

{

   case 'y':

cout<<"Request is being processed"<<endl;//printing for response y

   break;

   case 'n':

cout<<"Thank you anyway for your consideration"<<endl;//printing for response n

   break;

   case 'h':

cout<<"Sorry no help is currently available"<<endl;;//printing for response h

   break;

   default:

cout<<"Invalid entry; please try again"<<endl;//printing for other response

}

return 0;

}

Output:

Enter the response

y

Your request is being processed

Enter the response

o

Invalid entry; please try again

Explanation:

I have taken a char variable response and have taken input form the user.Then switch cases are used according to the question.

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok