Question Discussion & Solution

The correct answer is the formula bar.

Key Points

• By using the Defined names, the user can make the formulas much easier to understand and maintain.
• The user can define a name for a cell range, function, constant, or table. With the practice of using names in the workbook, the user can easily update, audit, and manage these names.
• The user Defined names will appear in the formula bar. 

Additional Information

• Steps to define names from a selected range
  • Select the range you want to name, including the row or column labels.
  • Select Formulas > Create from Selection.
  • In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
  • Select OK.
• Steps to use names in formulas
  • Select a cell and enter a formula.
  • Place the cursor where you want to use the name in that formula.
  • Type the first letter of the name, and select the name from the list that appears.
  • Or, select Formulas > Use in Formula and select the name you want to use.
  • Press Enter.
• How to manage names in your workbook with Name Manager
  • On the Ribbon, go to Formulas > Defined Names > Name Manager. You can then create, edit, delete and find all the names used in the workbook. 

Given pair is Thing: Main element

Prime constituent of pen is Ink

Similarly, prime constituent of Cigarette is Tobacco

Hence, he is moving in north direction now.

A keyboard is for putting information including letters, words, and numbers into the computer. A keyboard's primary function is to act as an input device. Using a keyboard, a person can type a document, use keystroke shortcuts, access menus, play games and perform a variety of other tasks.

Key Points

• A modifier key is a key on a computer's keyboard that's only used in conjunction with another key.
• Modifier keys are often used with other keys to perform computer keyboard shortcuts and other commands.
• For example, in many text editor programs pressing the Ctrl+A selects all text.

Additional Information

• The function keys or F keys are lined across the top of the keyboard and labeled F1 through F12. These keys act as shortcuts, performing certain functions, like saving files, printing data, or refreshing a page.
  • For example, the F1 key is often used as the default help key in many programs. The F5 key is used in an Internet browser to refresh or reload a web page. The function of these keys can differ by the operating system and by a software program.
• A special key or media key, or multimedia key is a keyboard key that performs a special function not included with the traditional 104-key keyboard.
  • For example, the picture shows a Logitech keyboard.
• An ergonomic keyboard is a keyboard designed for comfort, ease of use, and reduced strain on the user.
  • Such keyboards may include features like concave or tapered keys, keys that are well-spaced, or keys that separate and angle out from a central pivot point.

Therefore, based on the above information The keys of a keyboard, which are used to modify the input of other keys, are called modifier keys.