Question

The ………………tab of format cells dialog box has fraction option.​

Answer 1

Answer:

What are the different tabs available in format cells dialog box?

There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection.May 21, 2020

Answer 2

Answer:

The Number tab of format cells dialog box has fraction option.​

Explanation:

• Fractions in Excel are a number format used to display the number as an actual fraction instead of decimal numbers. Excel Fraction formatting comes with various options like Up to one digit, two digits, three digits, halves, quarters, eighths, sixteenths, etc.
• In Excel, when we separate any two numbers using the slash (“/”) sign, then it converts that number into decimal format. To keep fractions for such kinds of numbers, we have the Fractions option; first, select the cell whose value we need to convert infractions and select the Format Cells option from the right-click menu list. From the category section, choose Fraction under which we have multiple conditions for fractioning type up to one digit, two digits or three digits such as halves, eighths, etc.
• There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The following sections describe the settings available in each tab.

Number Tab

Auto Number Formatting

• By default, all worksheet cells are formatted with the General number format. With the General format, anything you type into the cell is usually left as-is. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526. This is because the cell remains in the General number format. However, if you first format the cell as a date (for example, d/d/yyyy) and then type the number 36526, the cell displays 1/1/2000.
• There are also other situations where Excel leaves the number format as General, but the cell contents are not displayed exactly as they were typed. For example, if you have a narrow column and you type a long string of digits like 123456789, the cell might instead display something like 1.2E+08. If you check the number format in this situation, it remains as General.
• Finally, there are scenarios where Excel may automatically change the number format from General to something else, based on the characters that you typed into the cell. This feature saves you from having to manually make the easily recognized number format changes. The following table outlines a few examples where this can occur:

If you type Excel automatically assigns this number format

1.0 General

1.123 General

1.1% 0.00%

1.1E+2 0.00E+00

1 1/2 # ?/?

$1.11 Currency, 2 decimal places

1/1/01 Date

1:10 Time

Generally speaking, Excel applies automatic number formatting whenever you type the following types of data into a cell:

• Currency
• Percentage
• Date
• Time
• Fraction
• Scientific

Reference Link

• https://brainly.in/question/8063953