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

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

How can you remove Borders applied in a cell?Answer areaChoose none on Border tab on Format cellsNone of AboveOpen the list on Border tool in Format Cell toolbar then choose first tool (none)Both of Above

Where can you set the shedding color for a range of cells in Excel?Answer choicesSelect only one optionREVISITChoose required color form Patterns tab of Format Cells dialog boxChoose required color on Fill Color tool in Formatting toolbarChoose required color on Fill Color tool in Drawing toolbarAll of above

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.

Where can you set the shading colour for range of cells in Excel?Answer areaChoose required colour on Fill Colour tool in Formatting toolbarAll of the AboveChoose required colour form Patterns tab of Format Cells dialog boxChoose required colour on Fill Colour tool in Drawing toolbar