USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Currency
|
|
|
Percentage
|
|
|
Roman Numerals
|
|
|
Date
|
Detailed explanation-1: -You can add between 200 and 250 custom number formats, depending on the language version of Excel that is installed on your computer. For more information about custom formats, see Create or delete a custom number format.
Detailed explanation-2: -The FORMAT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Detailed explanation-3: -For Microsoft Excel 2007-2019, go to the Home tab, click the Number Format drop-down menu in the Number group, and select the desired format. You can also click one of the quick number-formatting commands below the drop-down menu.