DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
four
|
|
|
there is no limit
|
|
|
three
|
|
|
seven
|
Detailed explanation-1: -When you create custom number formats, you can specify up to four sections of format code. These sections of code define the formats for positive numbers, negative numbers, zero values, and text, in that order.
Detailed explanation-2: -You can add between 200 and 250 custom number formats, depending on the language version of Excel that is installed on your computer.
Detailed explanation-3: -A number format can have up to four sections of code, separated by semicolons. These code sections define the format for positive numbers, negative numbers, zero values, and text, in that order. You do not have to include all code sections in your custom number format.
Detailed explanation-4: -A custom Excel number format changes only the visual representation, i.e. how a value is displayed in a cell. The underlying value stored in a cell is not changed. When you are customizing a built-in Excel format, a copy of that format is created. The original number format cannot be changed or deleted.