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. 

The image is flipped horizontally.

Hence, option 4 is the mirror image of the given image.

Explanation:

• Dynamite is an explosive which is used in mining, quarrying, construction and demolition industries. 
• It is made of Nitroglycerin, sorbents and stabilizers. 
• It was invented by Swedish Chemist Sir Alfred Nobel on whose memory the Nobel Prize has been constituted. 
• Nitro Glycerin: C3H5N3O9

The correct answer is 20 August, 1949

Key Points

• Rajasthan Public Service Commission was established on 20 August 1949.
• At the time of formation of Rajasthan, the institution of Public Service Commission existed in only three of the 22 covenanting states viz. Jaipur, Jodhpur and Bikaner.
• The successor administration after the merger of the princely states promulgated an ordinance on 16th August, 1949 establishing the Rajasthan Public Service Commission Ajmer which was published in Rajasthan Gazette at 20th August, 1949.
• Rajasthan Public Service Commission came into effect on 22 December, 1949.

Additional Information

• Rajasthan Board of Secondary education was set up on 4 December, 1967.
• Union Public Service Commission was set up on 1 October, 1926.
• Staff Selection Commission was set up on 4 November, 1975.

The correct answer is Light Pen.

Key Points 

• Light Pen -
  • It is an input device of the computer which serves to give commands to the computer.
  • It is also called an electronic pen.
  • It looks like an ordinary pen.
  • It is used as a mouse.

Additional Information 

• A wave of light emerges from the tip of this pen.
• With this point, the icon made on the screen is touched and clicked.
• This work is done in the same way that we click by moving the mouse pointer on the screen.
• The tip of the light pen acts in a way like the Enter / Ok button.​