You are using a worksheet reference when supplying values to a drop-down menu. A range of values in the range A2:A6 is supplied directly inside the data validation window. Which of these is the right way to enter the range to prevent the range from changing as the data validation is applied to other cells? A$2:A$6 $A2:$A6 None of the mentioned options You are using a Clustered Column chart to show the data of a worksheet in 2-D columns. What should the categories represent in order to use the clustered column chart? 1. Ranges of values 2. Specific scale arrangements 3. Names that are not in any specific order Choose the correct answer from the options given below. Only 1&2 All 1,2&3 Only 2 and 3 Only 1&3 ou want to search multiple cell references in a worksheet using Reference box. The cells Names, Salary and Age are ranges B12:C12,E2:F12 and J10:J30 respectively. Which of the following is the right way to do so? B12:C12,E2:F12,J10:J30 \$B\$12:\$C\$12,\$E\$2:\$F\$12,\$J\$10:\$J\$30 You are using a worksheet reference when supplying values to a drop-down menu. A range of values in the range A2:A6 is supplied directly inside the data validation window. Which of these is the right way to enter the range to prevent the range from changing as the data validation is applied to other cells? A$2:A$6 $A2:$A6 None of the mentioned options You are using a Clustered Column chart to show the data of a worksheet in 2-D columns. What should the categories represent in order to use the clustered column chart? 1. Ranges of values 2. Specific scale arrangements 3. Names that are not in any specific order Choose the correct answer from the options given below. Only 1&2 All 1,2&3 Only 2 and 3 Only 1&3 ou want to search multiple cell references in a worksheet using Reference box. The cells Names, Salary and Age are ranges B12:C12,E2:F12 and J10:J30 respectively. Which of the following is the right way to do so? B12:C12,E2:F12,J10:J30 \$B\$12:\$C\$12,\$E\$2:\$F\$12,\$J\$10:\$J\$30