USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Number
|
|
|
Currency
|
|
|
Text
|
|
|
Money
|
Detailed explanation-1: -The type-declaration character for Currency is the at () sign. The Currency data type is useful for calculations involving money and for fixed-point calculations in which accuracy is particularly important.
Detailed explanation-2: -Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.
Detailed explanation-3: -The Currency format refers to a built-in number format of MS Excel used particularly for currencies like prices. It adds a currency sign before the entered values within the formatted cells. The currency format is most commonly used for denoting general monetary values in Excel cells.
Detailed explanation-4: -In a Data Model, each column has an associated data type that specifies the type of data the column can hold: whole numbers, decimal numbers, text, monetary data, dates and times, and so on.
Detailed explanation-5: -So to change the default currency symbol in Excel, it has to be done from the Control Pane settings. Type “ctrl” without the “ “ marks in the windows’ search box on the bottom left corner of taskbar on the screen. Type your local currency symbol in the Currency Symbol Textbox. Default is $ symbol.