DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Negative numbers, Zero, Text, Positive Numbers
|
|
|
Positive Numbers, Negative Numbers, Zero, Text
|
|
|
Zero, Text, Positive Numbers, Negative Numbers
|
|
|
Negative numbers, Zero, Positive Numbers, Text
|
Detailed explanation-1: -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-2: -In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, select Number from the drop-down.
Detailed explanation-3: -Select the cells that have the numbers when you want to add the + sign. Right-click and then click on Format Cells. In the Format Cells dialog box, within the Number tab, click on Custom option with the Category. In the Type field, enter the following: +0; -0; 0.
Detailed explanation-4: -You can press Ctrl+1, or on the Home tab, click Format > Format Cells. Click Number > Custom. In the Type box, type 0; -0; ; , and then click OK.