Sean has carefully set up some complicated Conditional Formatting to one of the columns in his worksheet. He now wants to apply the same rules to another column in his worksheet. What is the quickest way for him to do this?1 pointHe can use the Format Painter. He can copy and paste the original column and then delete the content of the cells using the Clear tool. There is only one way, he needs to select the next column and then set up the Conditional Formatting rules again.

You can check the conditions against __________ when applying conditional formatting*Cell valueFormulaBoth of aboveNone of above

You should ideally use_____________ feature to highlight the cells to identify Duplicate values/entries in an excel sheet?Select one:a.Format painterb.Remove duplicatesc.Format cellsd.Conditional formattin

In the hospital charges dataset, take a column with a numeric variable (say, Average Medicare Payments). Using conditional formatting, attempt the following tasks:Fill the column in any one colour (red or green) so that the highest value has a darker shade of the colour and the lowest value has the lightest shade of the same colour. Fill the column in red and green so that the values above a certain number (say 5000) are highlighted in a gradient of red, and the ones below the number are highlighted in a gradient of green.Is it possible to do the second task? Mention the reason.

From the following list, select the choice that is NOT one of the choices shown in the drop-downmenu that appears when you click the “Conditional Formatting” button within the Ribbon.*Cell RangesTop/Bottom RulesHighlight Cell Rules

1. It opens a palette with different three- and two-colored scales that you can apply to the cellselection to indicate their values relative to each other by clicking the color scale thumbnail.*Highlight Cells RulesColor ScalesData Bar2. It opens a continuation menu, where you can remove the conditional formatting rules for the cellselection*New RuleClear RuleManage Rule3. It opens the Conditional Formatting Rules Manager dialog box, where you edit and deleteparticular rules*New RuleClear RuleManage Rule4. It enable you to automate almost any task that you can undertake in Excel 2010.*MacroPanesVisual Basic5. Opens the Macro dialog box where you can select a macro to run or edit.*View MacrosRecord MacroUse Relative References6. It is the column of data that contains the answer that you want.*Col_index_num3lookup_valueCol_index_num7. It is the area of cells in which the table is located.*lookup_valueThe table_arrayCol_index_num8. It is a TRUE or FALSE value.*Range_lookupCol_index_numlookup_value9. From the following list, select the name of the checkbox option that you can check oruncheckwithin the "Share Workbook" dialog box in order to share or remove sharing from aworkbook.*Share workbook and allow changes by other users.Allow changes by more than one user at a time. This also allows workbook merging.Allow reviewing and commentary by other users.10. From the following list, select the choice that BEST describes the purpose of using cell validationin Excel worksheets.*It allows you to see changing values in cells that you cannot actively view within the worksheet.It allows you restrict the range of values that can be entered into selected cells in a worksheet.It allows you to check if cell references being displayed by auditing arrows that point to externalworkbooksare correct and valid.