USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You want to create a worksheet where the user can see seven choices in a list all at once. When the user makes a selection on the list, another cell on the worksheet will show the number (position) of the item they selected (not the text itself from the item selection). Which control must be inserted into the worksheet?
|
|
A form list box control
|
|
|
An activeX option button control
|
|
|
A form combo box control
|
|
|
An activeX list box control
|
Explanation:
Detailed explanation-1: -The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. The Name Box displays the cell reference of the active cell.
Detailed explanation-2: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).
Detailed explanation-3: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon.
There is 1 question to complete.